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.
Considerations
Reviews imported even when using Judge.me template won't be verified in Judge.me as they don't provide verification data that meets our standards.
It's not possible to import reviews that only contain star ratings (a review body is required).
It's also not possible to import videos when importing reviews — only text and images are supported.
Before you import
To import reviews using Judge.me template, 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 the basic columns and example values to guide you — fill in the review details using these basic columns.
You can also add advanced columns if you want to include extra information (e.g. reply and custom questions).
We’ll explain the basic and advanced columns in detail below.
Basic columns
Column | Need to fill in | 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:
|
Advanced columns
Besides the basic columns, you also can add more information to your reviews by adding these advanced columns to your CSV file:
Column header | Need to fill in | Description | Example |
product_id | No | The ID of your product in your store | 1234567891234 |
product_handle | No | The unique handle of your product in your store | 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:
Column header: CFWhat model did you buy? Value:
|
Note: You can leave product_url, product_id, and product_handle empty to import as Store reviews.
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 by following these steps :
From your Judge.me admin, go to Settings > Import reviews.
Click the Import from a spreadsheet button.
Upload your CSV file.
Choose to import your reviews as product or store reviews.
Check the box I confirm my reviews are genuine and I have permission to import them.
Click Next.
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.
Select your preferred product identifier. For example, product URL.
Click Import.
Note:
We do not send any emails to customers listed in your CSV file during the review import process. Imported reviews are treated as historical data and will not trigger any notifications.
After you import
Once you upload the review file, we process it in the background.
When the import is complete (usually within 5 minutes), you’ll receive an email with the results, sent to the address listed under your Admin notifications.
You can also view these results directly in the Reviews Import Log inside your Judge.me admin.
If your import succeeds
If your reviews are successfully imported:
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.