LAI Docs
Search…
Import from other apps (CSV)
Help you migrate reviews from other reviews apps using a CSV file, XLSX file, Google Sheet. Contact support if migrate from Loox, Judge.me, Stamped, Shopify Product Reviews

Google Sheets

To import reviews using the free spreadsheet app Google Sheets:
2. Make a copy:
3. Fill in the review data according to the instructions in the spreadsheet below
** Do not rename or remove any of the columns Including the column titles.
Column Title
Description
Example
product_id
(Required)
To get an ID number, from your Shopify admin, you go to Products > Click the name of the product > The last numbers of this product page link is the ID number
Refer to this tutorial photo: https://prnt.sc/w7jjsu
author
(Required)
The name of the customer
(The name will appear on the review exactly as inserted here)
Harley G.
content (Required)
The text of the review
Highly recommend this product!
photo
A public URL for the review photo. Use this template:
["link photo 1","link photo 2","link photo 3"]
*Note: If you don’t have a photo URL, you can create one by following these instructions:
1) Save the relevant images to your computer
2) Go to your Shopify settings - Files
3) Click "Upload files"
4)Choose one of the images and upload it Copy its photo URL from the "URL" column once it has been uploaded
Example format of uploading many photos:
["Link1"]
email (Required)
You can leave this column empty if you don’t have the customer’s email address
rating (Required)
Valid values are 1/2/3/4/5
Please use whole numbers only.
5
date_time (Required)
Must be in the following format:
YYYY-MM-DD HH:mm:ss UTC.
The date must appear as Year-Month-Day, other formats will not be accepted.
2020-12-31 08:45:00 UTC
country
The 2-letter country abbreviation codes. If you don’t know these codes, please look up at this page:
Canada is written as CA
4. Download it as CSV before import to our app.
Click to "File" > "Download" > "Comma-separated values (.csv, current sheet)".
5. Upload your file in the empty box below:
If you have any troubles, please contact us via [email protected] and we are always willing to support you!
Note: CSV file can be formatted wrong when it's opened by Excel. For the best result, suggest merchants edit data by Google Sheet template, try not to edit data by Excel. When data is all set, save it as a CSV file and then upload that file to our app right away.
Is this instruction helpful for you? Please vote below. Your feedback means a lot. Thanks so much 😊
Last modified 1mo ago
Copy link