Import reviews from a CSV file

You can bulk-import reviews from a spreadsheet, for example reviews exported from another app or collected elsewhere. For the columns A2Reviews accepts, see CSV file format for review imports.

Two ways to import

Step 1: Upload the file

  1. Click Upload CSV and choose your file. Files should be smaller than 5 MB.
  2. To reuse a file you uploaded before, pick it under Or From History Upload.
  3. Click Import Now next to the file. The Import CSV Editor opens.

Step 2: Mapping fields

The editor shows the columns found in your file under Header columns from CSV, and the A2Reviews fields under them.

  1. A2Reviews tries to match columns automatically. Click Auto mapping fields to run it again.
  2. For any field left empty, drag a CSV column onto the matching A2Reviews field. Click the x next to a mapping to remove it.
  3. Make sure the required fields are mapped: rating, handle and author.

Step 3: Edit Reviews

Look over the reviews before they are saved. You can filter by star rating, photos or country, and fix or remove rows.

Step 4: Finish

  1. Choose what to do when a product with the same handle already has reviews:
  2. If a handle doesn't match any product yet, A2Reviews creates a product entry for it. You can give it a title and image (JPG or PNG) before you import.
  3. Click Import Reviews and wait until you see "All reviews from CSV have been imported!"

Tip: Handles must match your store's product handles exactly, or the reviews won't show on the right product page. Run Sync Products before you import so your store products are listed.

If the editor says "Not found CSV file or file format error.", see the file requirements in CSV file format for review imports.