Skip to main content

Importing reviews using Judge.me template

Upload reviews from other platforms or offline sources using our CSV format

Updated today

Available on the Free plan

Have reviews from Facebook, Instagram, offline sales, or personal connections? No problem! With Judge.me, you can quickly create and upload a properly formatted CSV file to showcase customer feedback on your store.


Why imported reviews aren't verified

Imported reviews won't be verified in Judge.me since they don't provide verification data that meets our standards.

We uphold strict verification standards to ensure that Judge.me medals remain a powerful trust signal, which helps you:

  • Build stronger credibility with potential customers

  • Stand out from competitors with authentic social proof

  • Increase conversion rates through customer feedback

To maximize your impact:

  • Focus on collecting new verified reviews via Judge.me’s review requests to maintain strong medal performance.

  • Enable Review transparency badges to show customers where each review comes from and boost trust.


Before you import

To import reviews into Judge.me, you’ll first need to prepare a CSV file containing your reviews in the correct format.

  1. Open our Google Sheet template and click Make a copy to start editing (or click here to download the sample file). This template includes all required columns and example values to guide you.

  2. Fill in your reviews with this format:

Basic columns

Column header

Required

Description

Example

title

No

Short headline for the review

Perfect Fit!

body

Yes

Main review content

(max 5000 characters)

This shirt fits me perfectly.

rating

Yes

Review rating: 1, 2, 3, 4, 5

5

review_date

No

Date of the review in dd/mm/yyyy format

(If empty, we'll use the current date)

24/12/2024

reviewer_name

No

Name of the reviewer

(If empty, we'll use "Anonymous")

John Smith

reviewer_email

No

Email address of the reviewer

product_url

No

Link to the product page

(if your Product URL contains special characters like ™, please skip this column and refer to the product_id advanced column instead)

picture_urls

No

You can add up to 5 images per review:

  • Use direct links to public image URLs (anyone should be able to open them without logging in).

  • Separate multiple links with commas (,).

  • Only use image formats: .jpg, .jpeg, or .png.

Advanced columns

Our default template only includes the basic columns. You can add more information to your reviews by adding these advanced columns to your CSV file.

Column header

Required

Description

Example

product_id

No

1234567891234

product_handle

No

blue-t-shirt

reply

No

A public reply to the review

Thank you for your kind words!

reply_date

No

The date when you replied to the review, in dd/mm/yyyy format

24/12/2024

ip_address

No

The IP address of the customer. We automatically calculate the location (city, country, country code) based on this IP address

34.203.165.149

CFYour Question

No

To import answers to custom form questions (e.g., age, model, etc.), add 1 column for each question.

Each column should start with CF followed by the question text.

(Only text format is accepted)

Column header: CFHow old are you?

Value:

  • 29

  • 15

Column header: CFWhat model did you buy?

Value:

  • A123

  • B456

Special use cases

  • Leave product_url, product_id, and product_handle empty to import as Store reviews.

Considerations

  • Currently, it's not possible to import videos. As a workaround, you can first import the reviews, then edit the imported reviews to add videos.

    1. From your Judge.me admin, go to Manage Reviews > Reviews Dashboard.

    2. Locate the review you want to add the videos.

    3. Click the 3-dot icon (...) next to the review and select Edit review.

    4. Upload your videos and click Save.

    5. After uploading, it may take a few minutes for the video to show in the Reviews Dashboard and on the storefront.

  • We can only import the reviews with Product ID, Product Handle, or Product URL. Currently, it's not possible to import using SKUs.


See the steps for the new app design (coming soon)

Currently, it's not possible to import videos directly with your review files. As a workaround, you can import the reviews first, then manually edit them to add videos.

To add videos to an imported review:

  1. From your Judge.me admin, go to Reviews.

  2. Find the review you want to update.

  3. Click the three-dot menu next to the review and select Edit review.

  4. Upload your video(s).

  5. Click Save.

Note: When importing reviews, you must include a Product ID, Product Handle, or Product URL to match them to your products. Importing by SKU is not supported at this time.


Import your reviews to Judge.me

Once you've finished adding reviews to your file, download it to your computer:

  1. From your Google Sheet screen, go to File > Download.

  2. Select Comma Separated Values (.csv).

Then upload the file you just downloaded to Judge.me:

  1. From your Judge.me admin, go to Manage Reviews > Reviews Dashboard.

  2. Click Import & sync reviews on the top right.

  3. In the Manual reviews import section, click Get started.

  4. Upload your CSV file and click Next.

  5. Match the columns in your CSV file with the corresponding Judge.me fields. Judge.me will attempt to match these columns automatically, but you can adjust them as needed.

  6. Confirm the date format of your reviews. If correct, click Import.


See the steps for the new app design (coming soon)

To upload the file you downloaded to Judge.me, follow these steps:

  1. From your Judge.me admin, go to Settings > Import reviews.

  2. Scroll to the Manual reviews import section.

  3. Click Get started.

  4. Upload your CSV file and click Next.

  5. Match the columns in your CSV file with the corresponding Judge.me fields. Judge.me will attempt to match these columns automatically, but you can adjust them as needed.

  6. Confirm the date format of your reviews. If correct, click Import.


Note:
You can upload your file in any of these formats: .csv, .xls, and .xlsx. But we typically recommend using CSV because it’s the most reliable format. CSV avoids formatting issues that can occur with Excel files, such as hidden characters, merged cells, or formula-based values.


After you import

The import will take around 5 minutes. Once it's finished, we will email you the results, including:

  • How many reviews were successfully imported

  • How many reviews failed to import, plus a CSV file of these failed reviews, and why they failed

You can also find this information in the app:

  1. From your Judge.me admin, go to Manage Reviews > Reviews Dashboard.

  2. Click the Import & sync reviews button.

  3. Scroll down to Reviews import log.


See the steps for the new app design (coming soon)

To view your review import activity, follow these steps:

  1. From your Judge.me admin, go to Settings > Import reviews (under the Review Collection section).

  2. Scroll down to the Reviews import log section.


If your import succeeds

  • To show your imported Product reviews on product pages, install the Star Rating Badge and Review Widget.

  • To show your imported Store reviews, set up the All Reviews Page and Floating Reviews Tab.

  • Since videos are not imported by default, if you have videos in your reviews, after the reviews have been imported, you can edit the reviews to upload your videos.

If your import fails

If, unfortunately, your reviews fail to import, check out this article to fix your CSV file and reimport the failed reviews.


Get your free trial

🚀 Get your 15-day free trial of the Awesome plan to showcase your imported reviews across all widgets and boost your social proof effortlessly.


Follow us on LinkedIn

📢 Stay in the loop! Follow Judge.me on LinkedIn for the latest product updates, tips, and feature launches.

Did this answer your question?