CSV file format for review imports

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.

Columns

Your headers don't have to use these exact names. You can drag your own columns onto the fields during mapping.

Example

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

Delimiters and encoding

Default values

Automatic mapping

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.