Judge.me allows you to import reviews from many reviews apps without having to change the CSV file as well as import reviews from AliExpress.
You can also import from an unsupported source with a CSV file following our template.
ON THIS PAGE
Step 1: Download the CSV file
You can download our CSV file for reviews below.
To edit the file:
- Login to Google Sheet and create a new blank sheet.
- Click File > Import > Upload and select the file above.
- Keep the default settings and click Import data.
Google Sheet is free, and compatible with most devices, and it saves the file as CSV without adding unsupported characters to the content.
Step 2: Fill in the information for the reviews
Here's what each column means:
|title||optional||title of the review|
|body||required, has a fallback||body of the review (up to 5000 characters)|
|rating||required||the review rating (1-5)|
|review_date||optional||the date the review was created (dd/mm/yyyy).|
|reviewer_name||optional||name of the reviewer. If empty, "Anonymous" will be used.|
|reviewer_email||optional||email of the reviewer. If empty, a unique fake email will be used .|
|either is required||You just need to fill in either the product_id or product_handle. |
If both are empty, the reviews will be imported as shop reviews.
|reply||optional||the public reply to the review|
|picture_urls||optional||URLs of the images in the review.|
|ip_address||optional||the IP address of the review (e.g. 126.96.36.199). We automatically calculate the location (city, country, country code) based on this IP address.|
If you want to import answers for your customized questions in each review, please create additional columns in your CSV file with the header CFYour Question. We import custom forms as text only so we are unable to import multiple options.
Step 3: Upload the file to Judge.me
- When you've added the reviews, you can download the sheet by choosing File > Download > Comma Separated Value (.csv).
- In Judge.me admin, choose Import & Export > Import reviews > From Judge.me Template (Advanced).
- Choose the file you've downloaded and click Import reviews.
Step 4: Review the results
We will process the file in the background and email you with the details regarding how many reviews have been imported, how many have failed, and the reason they failed.
You will see the successfully imported reviews in the reviews dashboard after a few minutes.
If you have duplicated imported reviews or want to delete all imported reviews, please contact us at email@example.com and we'd be more than happy to help!