Title: importing csv
Last modified: August 4, 2017

---

# importing csv

 *  Resolved [martineva](https://wordpress.org/support/users/martineva/)
 * (@martineva)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/)
 * Hello !
    I’m totally updating my website and my old version (no CMS) had a hundred
   testimonials on it. The webmaster gave me the CSV file of it, but I must say 
   I’m quite lost with it, I saw it could be possible to import them, but I have
   not the first idea wat I should do … Would it be possible to have some help ?
   If I could skip the long step of copying mannually each one of them it would 
   be great 🙂

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

 *  Plugin Contributor [Chris Dillon](https://wordpress.org/support/users/cdillon27/)
 * (@cdillon27)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/#post-9380087)
 * Hi [@martineva](https://wordpress.org/support/users/martineva/),
 * Importing can be tricky and every situation is different. There are many decision
   points along the way. Wherever possible, I recommend hiring a programmer. Someone
   with experience could do it in 1-2 hours, barring any complications.
 * That said, I will try to help.
 * 1. Have you worked with CSV files before?
 * 2. What’s your favorite code editor?
 * 3. Are you able to test on a development site first?
 * Please open the CSV file and copy and paste the first two lines here.
 *  Thread Starter [martineva](https://wordpress.org/support/users/martineva/)
 * (@martineva)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/#post-9380394)
 * Hi !
    And thanks for your quick answer and trying to help newbies 🙂 Soooo ….
   1- Nope 2- not very skilled in any. Got some knowledge with html, css but I don’t
   know if it can help here. I don’t have any favorite code editor . 3 – yep and
   the first two lines :
 *     ```
       "robin","Message de robin","8","Accueil très chaleureuxRestaurant décoré avec goûtRepas copieux, raffinéUne soirée très réussie. Je vous conseil à tous ce lieu unique dans notre région.Remerciements sincères à la maîtresse des lieux.","2007-04-24"
       "Diane et Pierre","Message de Diane et Pierre","9","Une excellente cuisine ainsi qu'un accueil chaleureux. Ambiance musicale discrète et agréable.Merci pour cette soirée et félicitations aux maitres des lieux. Diane et Pierre
       ```
   
 *  Plugin Contributor [Chris Dillon](https://wordpress.org/support/users/cdillon27/)
 * (@cdillon27)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/#post-9380683)
 * To import the file into WordPress, I recommend Really Simple CSV Importer. It
   still works well despite not being updated recently.
    [https://wordpress.org/plugins/really-simple-csv-importer/](https://wordpress.org/plugins/really-simple-csv-importer/)
 * But first, you will need to edit that file. If you are on a PC, I recommend the
   free version of Ron’s Editor.
    [https://www.ronsplace.eu/Products/RonsEditor](https://www.ronsplace.eu/Products/RonsEditor)
 * Tip: Don’t edit the original file. Always work on a copy.
 * The first line needs to be a header record that identifies the fields. Here’s
   an example of a header record and one testimonial:
 *     ```
       post_type,post_status,post_date,post_title,post_content,client_name,tax_wpm-testimonial-category
   
       wpm-testimonial,publish,2007-08-31,"The Backstreet DJ's were great.","They kept the party jumping and everyone had a good time. The music was a hit with the guests.",Roma Sison,backstreet-djs
       ```
   
 * The minimum required fields: post_type, post_status, post_date, post_content.
 * client_name is a custom field.
 * tax_wpm-testimonial-category is the testimonial category slug (not the name).
   That’s optional.
 * I think this would be your current header record:
 * `client_name,post_title,post_id,post_content,post_date`
 * You will need to delete the post_id field in each record.
 * You will need to add post_type and post_status for each record like the sample
   above.
 * It looks like line breaks and/or list items were stripped during export. For 
   example,
    `Accueil très chaleureuxRestaurant décoré avec goûtRepas copieux, raffinéUne
   soirée très réussie.` should have at least a space between chaleureux and Restaurant.
   Reinstating paragraphs could be done in the file by wrapping each segment in `
   <p>`,`</p>` tags but it’s probably easier to do that in the WordPress post editor
   where you can just hit Enter to create paragraphs.
 * When you’re ready to import, make a backup first. If you need it, I recommend
   BackupGuard for this sort of thing. It allows you to backup the database only
   which is all you would need to restore if something goes wrong.
    [https://wordpress.org/plugins/backup/](https://wordpress.org/plugins/backup/)
 * Import the file. Check the testimonials. If something did not import properly,
   restore the database, fix the import file, try again.
 *  Thread Starter [martineva](https://wordpress.org/support/users/martineva/)
 * (@martineva)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/#post-9386713)
 * Now THAT was a nice tuto, thank you so much for helping with step-by-step tips
   🙂
    Worked well, now I’ve got all my testimonials back, thanks again !
 *  Thread Starter [martineva](https://wordpress.org/support/users/martineva/)
 * (@martineva)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/#post-9386714)
 * closed 🙂

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

The topic ‘importing csv’ is closed to new replies.

 * ![](https://ps.w.org/strong-testimonials/assets/icon-256x256.png?rev=3134855)
 * [Strong Testimonials](https://wordpress.org/plugins/strong-testimonials/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/strong-testimonials/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/strong-testimonials/)
 * [Active Topics](https://wordpress.org/support/plugin/strong-testimonials/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/strong-testimonials/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/strong-testimonials/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 5 replies
 * 2 participants
 * Last reply from: [martineva](https://wordpress.org/support/users/martineva/)
 * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/importing-csv-7/#post-9386714)
 * Status: resolved