Skip to main content

Import Reviews via CSV/XLSX File | Bulk Upload Guide

Use our CSV template to bulk import customer reviews. Follow our formatting rules for product handles, ratings, and image links to ensure a smooth import.

Step-by-Step Instructions

1. Download the CSV/XLSX Template

Download our CSV template. Either of the two formats will work.

2. Fill Out the CSV/XLSX File

Fill out the columns with the appropriate information from columns A through S.

Note: Columns marked with an asterisk (*) are required fields (Columns A, B, C, and H).

Required Columns Example

Column Details

Column

Name

Description

Format/Requirements

A*

Product handle

The product identifier found in the URL after "products/"

Example: top-retro-womens-t-shirt-short-sleeve

B*

Rating

Numerical rating for the review

Whole numbers from 1-5 only (no decimals)

C*

Author

Name of the customer who left the review

Text

D

Title

Title of the review

Text

E

Content

The review text/comment

Text

F

Author Country

Country of the reviewer

Country code abbreviation only

G

Author Email

Email address of the reviewer

Valid email format

H*

Commented at

Date when the review was submitted

YYYY-MM-DD format

I

Reply

Your response to the review

Text

J

Reply Date

Date when you replied

YYYY-MM-DD format

K

Verified Badge

Show verified badge on the review

Enter "Yes" or "No"

L

Featured Review

Feature this review prominently

Enter "Yes" or "No"

M

Item_type

SKU or variant of the product

Text

N-R

Images

Links to review images

One image link per column

S

Video

Link to a review video

URL

Required fields are marked with an asterisk (*)

Finding the Product Handle

The product handle can be found in the product URL on your storefront right after "products/".

In this example, the product handle is: top-retro-womens-t-shirt-short-sleeve

Product Handle Example

3. Save Your File

Save the file by pressing CTRL+S on your keyboard or saving it in CSV COMMA DELIMITED format or in XLSX.

4. Import the File

  1. Navigate to IMPORT > Import Reviews in your admin panel

  2. Upload your CSV file

  3. To avoid errors during import, ensure your file follows our template format exactly

Tips for Successful Imports

  • Double-check that all required fields are completed

  • Ensure dates follow the YYYY-MM-DD format

  • Verify that product handles match exactly with your store's products

  • Use only whole numbers (1-5) for ratings

  • For country fields, use standard country code abbreviations (e.g., US, UK, CA)

Did this answer your question?