Review import skipped rows or failed

Last updated

After an import, the Import / Export tab lists what happened to every row. Here is each message, in the dashboard's words, and what to do.

The file was refused

  • The file has no review rows. The file is empty below its header. Export again from the old app.
  • The file is larger than 5 MB. or The file has more than 5,000 rows. Split it and import the parts.
  • The file could not be read as CSV: a quote is not closed. A text cell has an opening quote with no closing one. Open the file in a spreadsheet app and save it as CSV again.
  • No rating column was found. Use the CSV template (Download the CSV template) or an export from Judge.me, Shopify Product Reviews, Loox or Yotpo.
  • You have reached 20 imports today. Try again tomorrow.

Some rows were skipped or hidden

  • Already imported before. The same review is in an earlier import; nothing to do.
  • Skipped, no rating from 1 to 5. Fix the rating cell of those rows, or leave them out.
  • Skipped, no readable date. Use dates like 2026-09-14.
  • Dates like 03/04/2024 that could be day/month or month/day. They were read as day/month; check a few of those reviews.
  • Marked as spam by the old app (hidden) and Hidden in the old app, imported as hidden. These came in hidden on purpose. You can publish any of them from the Reviews tab.
  • Not matched to a product in your Shopify store (kept by handle). The review keeps the handle from the file; it shows where the widget's data-product uses that handle.

Step-by-step exports per app: Judge.me, Yotpo, Loox, Shopify Product Reviews, WooCommerce and Etsy.

Questions: support@formgong.com.