Import Store Reviews Using CSV
Overview
Rivyo lets you import store reviews in bulk using a spreadsheet file (CSV/Excel). Store reviews describe a customer’s overall experience with your store (shipping, support, packaging, etc.) rather than feedback about a specific product.
After import, these reviews can be shown on your storefront to build trust and highlight customer satisfaction.
Before you import
- Make sure your file is saved as
.csv,.xlsx, or.xls. - Use one row per review (one customer review per line).
- Confirm your columns match the required fields below (spelling and order do not need to match, but the headers should).
Import store reviews
From your Shopify admin, open the Rivyo app.
In Rivyo, go to Reviews → Import Reviews.
Select the Store Reviews tab (not Product Reviews).
Click Add files, then select your CSV/Excel file.
Choose whether to auto-approve reviews and whether to skip duplicates (details below).
Click Import Review. Rivyo will process your file and add the store reviews to your account.
Supported file formats
.csv.xlsx.xls
Required fields
Your file must include these columns so Rivyo can import each review correctly:
| Field | What it means | Accepted format |
|---|---|---|
Name |
Customer name shown on the review | Text |
Email |
Customer email address (used for identifying/importing) | Email (example: [email protected]) |
Rating |
Star rating for the store review | Number from 1 to 5 |
Date |
Date the review was left | YYYY-MM-DD (example: 2026-03-07) |
Date format is not YYYY-MM-DD, the import may fail or the review date may not display as expected.
Example CSV (recommended format)
Use the header row exactly once, then add one review per row.
Name,Email,Rating,Date,Title,Review
"Sarah Ahmed","[email protected]",5,2026-03-01,"Fast delivery","Order arrived early and support was helpful."
"Mike Chen","[email protected]",4,2026-02-18,"Great service","Easy checkout and quick responses from the team."
Title and Review columns in the example above are optional—include them if you want richer store reviews.
Optional fields
You can include additional columns to import more detail (these are not required):
- Review title (for example,
Title) - Review description/comment (for example,
Review,Comment, orDescription) - Customer images (if your file supports it and you have image data available)
Import options
During import, you may see these options:
Approve all reviews
Turn this on if you want imported store reviews to be published immediately on your storefront. If it’s off, the imported reviews may be added as pending and require approval before they display.
Skip existing reviews
Turn this on to prevent duplicates. Rivyo will try to skip reviews that already exist, helping keep your store review list clean.
Import history
After the import finishes, open Import Review History to confirm results. This area shows:
- Import date
- Number of reviews imported
- Import status
Use this to quickly verify whether your file was processed successfully and how many reviews were added.
Product reviews vs. store reviews
These two review types appear in different places and behave differently:
- Linked to a specific product
- Displayed on product pages
- Best for product quality, sizing, fit, and product-specific feedback
- Not linked to any product
- Reflect overall store experience (delivery, service, packaging, etc.)
- Commonly displayed on home pages, testimonial sections, or dedicated review pages
Troubleshooting
- Confirm every row includes all required fields (
Name,Email,Rating,Date). - Check
Ratingvalues are only1–5. - Make sure
Dateis inYYYY-MM-DDformat. - If Skip existing reviews is enabled, reviews that match existing entries may be skipped.
Re-check the Date column formatting in your spreadsheet. Export again as CSV and ensure dates are saved as
YYYY-MM-DD (example: 2026-03-07).
Put the review text inside quotes in the CSV (most spreadsheet tools do this automatically on export).
Example: "Great service, fast shipping".