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.

Before you import

Notes:

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

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	john@example.com
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)	https://abc.myshopify.com/products/blue-t-shirt
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.	https://picture1.png, https://picture2.jpg

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	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: 29 15 Column header*: CFWhat model did you buy? *Value: A123* B456

Note: You can leave product_url, product_id, and product_handle empty to import as Store reviews.

Considerations

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:

From your Judge.me admin, go to Reviews.
Find the review you want to update.
Click the three-dot menu next to the review and select Edit review.
Upload your video(s).
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 by following these steps :

From your Judge.me admin, go to Settings > Import reviews.
Scroll to the Manual reviews import section, click Get started.
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.