This article explains how to lay out a CSV file for Import reviews from a CSV file. The first row must be a header row, and each row after it is one review.
rating (required): a whole number from 1 to 5, where 5 is the most positive.handle (required): the end of the product URL. For https://your-store.com/products/blue-t-shirt the handle is blue-t-shirt.author (required): the reviewer's name as it should appear.email: the reviewer's email address. It is not shown publicly.avatar: a URL of the reviewer's picture.title: a short headline, for example "Awesome!".content: the review text.images: photo URLs, either as a list like ["url1","url2"] or comma-separated url1,url2.created_at: the date and time of the review, for example 2024-05-18 14:30:00.country_code: a 2-letter country code such as US or DE.Your headers don't have to use these exact names. You can drag your own columns onto the fields during mapping.
rating,handle,author,email,title,content,images,created_at,country_code 5,blue-t-shirt,Anna K.,[email protected],Love it,"Great fit, soft fabric.","https://example.com/a.jpg,https://example.com/b.jpg",2024-05-18 14:30:00,US 4,blue-t-shirt,Mark T.,,Good value,Runs slightly large.,,2024-06-02,GB
|) are supported.created_at value that can't be read is replaced with the date and time of the import.country_code default to US.Auto mapping fields matches a column when its header contains a field name (for example product_handle maps to handle). It also maps body_text or text to content, body_urls to images, and any header containing date to created_at. Always check the result before you continue.
Tip: Try a small file with a few rows first. Once it imports correctly, upload the full file.