Bulk import testimonials from CSV

Updated October 8, 2026

Short answer

In VideoTestimonials, open Dashboard → Import → Reviews & Other and click Upload CSV. Drop a .csv, .xlsx, .xls or .json file, map your columns to fields (only Name is required), preview the first 10 rows and import. Rows need text or a video URL, duplicates are skipped, and rows import as approved unless a mapped Status column says otherwise. The Free plan lists CSV import of 50 rows.

Import many testimonials at once from a spreadsheet. CSV, Excel (.xlsx / .xls), and JSON files are all accepted.

Steps

Go to Dashboard → Import.
Open the Reviews & Other tab and click Upload CSV — the Import Testimonials modal opens.

Upload your file — drag-and-drop or click to pick a .csv, .xlsx, .xls, or .json file. Need a template? The modal has a Download Template button that gives you a ready-to-fill CSV with the exact headers we expect (name,email,company,role,text_content,video_url,rating,status).
Map the columns — we auto-match common headers; tweak any that aren't right. Only Name must be mapped. Each row also needs testimonial text or a video URL, or it's skipped.
Preview — check the first 10 rows and the total row count before confirming.
Import — when it finishes you see how many rows were imported, skipped, and failed. Details of skipped and failed rows appear in the History tab.

Tips

Rating should be a whole number from 1 to 5. Decimals are cut down (4.5 becomes 4).
Status: approved imports as approved; any other value imports as pending. Without a Status column, rows import as approved.
Video URL is saved as given. Automatic transcription works when it's a direct link to a video file (for example .mp4).
Rows with the same email, or the same name and text, as a testimonial already in the space are skipped as duplicates.
For Excel files, only the first sheet is read.
For columns that don't map to a known field, pick Ignore this column — we won't import that data.

Frequently asked questions

Is CSV import free?

Yes. The Upload CSV button is available on every plan, and the Free plan's feature list includes CSV import of 50 rows. The Free plan also lists 20 text and 10 video testimonials, while Starter ($24/month) and higher plans list unlimited testimonials.

What columns does the CSV template include?

The Download Template button gives you a CSV with the headers name, email, company, role, text_content, video_url, rating and status, plus two sample rows. You can also map Avatar URL and Date columns from your own file. Set any column you don't need to Ignore this column during mapping.

Why were some rows skipped?

A row is skipped when it has no text and no video URL, or when the space already has a testimonial with the same email or the same name and text. Rows without a name are dropped before import, and rows that fail to save count as Failed. The History tab shows the counts and the first few warnings and errors.

Can I import video testimonials from a spreadsheet?

Yes. Map a column to Video URL and each row with a link is saved as a video testimonial pointing to that URL. VideoTestimonials then tries to transcribe it automatically, which works when the link points straight to a video file such as an .mp4 rather than to a page like YouTube.

Want to try this yourself?

The free plan includes 10 video testimonials, 20 text, a Wall of Love embed and CSV import. No credit card, and nothing expires.

Start free

Was this article helpful?