> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.widereviewapp.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Importing reviews from a CSV file

**Wide Hello!** 

WideReview lets you import reviews directly from an existing CSV file.

Here’s how: 

### 1️⃣ Open the page to import the reviews

Go to the page dedicated to importing reviews.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_7drqeu.png)

### 2️⃣ Copy our CSV template

In order to import reviews and so that WideReview is able to recognize them, you have to use our template.

**Click on the link** for the template.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_1te6o8x.png)

This will redirect you to a Google Sheets page where you will be able to copy the file to your Google account.

**Click on Make a copy** in Google Sheets.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_owlz5w.png)

### 3️⃣ Add your reviews to the document

You can start to add your reviews to the document by referring the example shown below.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_1jcc4vq.png)

Column A: Enter your product’s **"handle"** or **ID**. ([How to find your product ID](https://help.widereviewapp.com/en/article/how-to-find-your-product-id-or-handle-ck6lzn/?bust=1654708216774))
Column B: Enter the rating attributed to the review (from 0 to 5).
Column C: Enter the author of the review.
Column D: Enter the review text.
Column E: Enter the URL of a photo or video associated with the review (optional)
Column F: Enter the word TRUE if you want “Verified” to appear on the review, otherwise, enter FALSE.

### 4️⃣ Save the file in CSV format

Once you've finished entering your reviews, you have to upload it in CSV format.

For this, **click on the File menu**.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_vzda5x.png)

Then, **hover the mouse over Download**.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_1q6qlsx.png)

Select **Comma-separated values**.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_1os75tz.png)

### 5️⃣ Import the document to WideReview

Now that you've downloaded your file, you can import it to WideReview.

Click on the **Import CSV file** button.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_ys85o0.png)

**Select your CSV file**.

A status bar will appear showing you the import progress when you import your reviews.

![](https://storage.crisp.chat/users/helpdesk/website/fb9ba398921ca800/image_1rqbokr.png)

If there is something wrong with any of your reviews, the application will inform you.

Here are some errors you might encounter:

* Your file is not a CSV file (you did not properly download your reviews).
* There’s a problem with your CSV file (the file is corrupted).
* Product not found (the handle or ID for the review does not match any products in your online store).
* Missing field (you forgot to complete a field, WideReview will let you know which one).
* The image or video does not exist (the link is not correct).
* The image or video is too large (reduce the file size, which is also essential for optimizing download time)

And there you go! You’ll find the reviews right in your app!

And if some of them were incorrect, you’ll have to re-add them in a new file, and correct the errors!

See you soon!