Title: Import csv help
Last modified: September 21, 2021

---

# Import csv help

 *  Resolved [cbraun8675309](https://wordpress.org/support/users/cbraun8675309/)
 * (@cbraun8675309)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/import-csv-help/)
 * I used another review plug in before called site reviews. These reviews were 
   submitted without being linked to an order id or product id. I would like to 
   import these to be shared with my new reviews on customer reviews plug in. I 
   set the product id to -1 so they would be included as a shop review.
 * I inputed the available information into csv with matching format however I get
   an error “The CSV file contains invalid or missing column headings, please refer
   to the template in step 1”. Are all of the heading required? Would there be any
   work around?
 * This is the export from site reviews plug in
    date,title,review_content,ID,review_id,
   review score,type,is_approved,is_pinned,name “2019-12-30 14:57:27″,”Better than
   expected”,”Thank you!!! These are so much better than expected. I bought them
   as a gift. He absolutely loved them!”,”5″,”Lora”,”email@gmail.com”
 * and I modified it like so
    product_id,date,title,review_content,review_score,
   display_name,email “-1″,”2019-12-30 14:57:27″,”Better than expected”,”Thank you!!!
   These are so much better than expected. I bought them as a gift. He absolutely
   loved them!”,”5″,”Lora”,”email@gmail.com”

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [cusrev](https://wordpress.org/support/users/cusrev/)
 * (@cusrev)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/import-csv-help/#post-14949486)
 * Thanks for trying our plugin!
 * Can you please upload your CSV file on some cloud storage and share the link?
 *  Thread Starter [cbraun8675309](https://wordpress.org/support/users/cbraun8675309/)
 * (@cbraun8675309)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/import-csv-help/#post-14949581)
 * Hey thanks for the reply. The original file was json so I was constructing the
   csv file manually. I ended up finding a free online json to csv conversion tool
   and managed to get them imported.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Import csv help’ is closed to new replies.

 * ![](https://ps.w.org/customer-reviews-woocommerce/assets/icon-256x256.png?rev
   =2532349)
 * [Customer Reviews for WooCommerce](https://wordpress.org/plugins/customer-reviews-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/customer-reviews-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/customer-reviews-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/customer-reviews-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/customer-reviews-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/customer-reviews-woocommerce/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [cbraun8675309](https://wordpress.org/support/users/cbraun8675309/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/import-csv-help/#post-14949581)
 * Status: resolved