Skip to content

How to Bulk Import Testimonials From a CSV File

If you already hold reviews or testimonials in a spreadsheet, you do not need to recreate them one by one. A CSV bulk import lets you bring a whole collection into a testimonial wall in one pass, ready to display through website widgets and other marketing materials.

Step 1: Prepare your CSV file

Before uploading anything, check that every row contains the two required pieces of information: who wrote the testimonial and what they said. Everything else improves the display but is not mandatory.

Use this field checklist when building your file:

  • author_name — required. The name of the person who gave the testimonial, such as John.
  • message_content — required. The full text of the testimonial.
  • author_image — optional. A direct image URL for the author.
  • work_title — optional. The author's role or designation, such as CEO at Acme Inc.
  • star_rating — optional. A rating from 1 to 5.
  • message_link — optional. A link to the author's profile, social account, blog or website.
  • media_image — optional. An image URL to show beneath the testimonial text.
  • testimonial_type — optional. The source type of the testimonial. Blank values are treated as text testimonials. Supported values include Text, Twitter, Linkedin, Reddit, Playstore, Appstore, Producthunt, Trustpilot, Picture, Google, G2, Capterra, Shopify, Facebook, Slack, Amazon, Discord, Youtube, Instagram, Telegram, Whatsapp, Goodfirms, Clutch and Yelp.
  • message_time — optional. The date and time the testimonial was submitted, in ISO format such as 2024-01-10T23:37:47.000Z.

Your CSV headings do not have to match these names exactly. Different headings are fine because you will connect them to the correct fields during the import step.

Step 2: Upload the file and map the fields

Open the dashboard and create the testimonial wall that will receive the imported entries. Then choose the Add Testimonial option at the top right.

From there, select Bulk Import CSV and upload the file you prepared. The import screen then shows the destination fields on one side and the columns from your file on the other. Use the dropdowns to pair each destination field with the matching column in your CSV. Take a moment to check the required fields in particular — author_name and message_content must both be assigned before you proceed.

Once every mapping looks correct, select Confirm Import at the bottom. The entries are then added to the wall in bulk, so you can review them and choose how to display them.

Before you confirm: a final check

A quick pre-import check saves rework afterwards:

  • Confirm each row has both an author name and testimonial text.
  • Check that image URLs open directly rather than linking to a webpage.
  • Keep star ratings within the 1 to 5 range.
  • Use only supported testimonial_type values, or leave the field blank for a text testimonial.
  • Format dates as full ISO date-and-time values.
  • After mapping, scan the required fields once more before confirming.

If you do not yet have testimonials to import and need to gather them from customers first, start with a collection process and then use the same CSV format for any existing material you already hold.

Frequently asked questions

Does my CSV need to use the exact destination field names?

No. Your file can use its own column headings. During upload, you connect each column in your file to the matching destination field, so the names do not need to be identical beforehand.

Which fields must I include in every row?

Only the author's name and the testimonial text are required. The remaining fields — including the author's image, job title, star rating, profile link, supporting image, testimonial type and submission date — are optional.

What happens if I do not specify a testimonial type?

If you leave the type blank, the entry is treated as a text testimonial. If you do supply a type, use one of the supported values, such as Twitter, LinkedIn, Google, Trustpilot, YouTube or Instagram.

What format should the submission date use?

Use a full date-and-time value in ISO format, for example 2024-01-10T23:37:47.000Z, so the submission time is preserved accurately.