Skip to main content

Importing reviews using Judge.me template

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

Updated today

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.

Note:

Imported reviews are not automatically verified. If you are importing reviews from a verified source, such as another store you own, contact support@judge.me with proof (e.g., screenshots of order history) for manual verification.

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.

  • 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.

  • 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

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.

  • 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.

    • From your Judge.me admin, go to Manage Reviews > Reviews dashboard.

    • Locate the review you want to add the videos.

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

    • Upload your videos and click Save.

Import your reviews to Judge.me

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

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

  • Select Comma Separated Values (.csv).

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

  • From your Judge.me admin, go to Manage Reviews > Reviews dashboard.

  • Click Import & sync reviews on the top right.

  • In Import reviews from the CSV file, select Judge.me format.

  • Upload the file and click Import.

After you import

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

  • How many reviews 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:

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

  • Click the Import & sync reviews button.

  • Scroll down to Reviews import log.

If your import succeeds

If the import was successful but reviews don't show on your website, here's what to check:

If you want to show reviews on product pages

Make sure the reviews were imported as Product reviews, not Store reviews.

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

  • Under the Reviewer name, you’ll see a clickable link.

Scenario

Solution

If the link says "your shop", it's a Store review

If you mistakenly imported the reviews as Store reviews:

  • Remove the incorrect import:

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

    • Click the Import & sync reviews button.

    • Scroll down to Reviews import log.

    • Click the 3-dot icon (...) next to your latest import.

    • Click Delete reviews.

  • In the CSV file that you used to import, make sure you add and fill in one of these columns: product_id, product_handle, or product_url.

  • Reimport the file you've corrected.

  • Install the Star Rating Badge and Review Widget (if not already done).

If it links to a product page, it's a Product review

You can install the Star Rating Badge and Review Widget to show these Product reviews on your product pages

If you want to import the reviews as Store reviews

Set up the All Reviews Page and Floating Reviews Tab to show store reviews.

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.

Did this answer your question?