Title: CSV Import
Last modified: December 15, 2019

---

# CSV Import

 *  Resolved [gpinkflamingo](https://wordpress.org/support/users/gpinkflamingo/)
 * (@gpinkflamingo)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/csv-import-45/)
 * Hi! I’m trying to import a new listing from CSV file.
 * When I upload the CSV the message here below appears:
 * “Line 2 has too many columns
 * Line 3 has too many columns
 * Line 4 has too many columns”
 * Import type is well selected “new listing”.
 * The fields in the file are the same as the one I got when I exported my current
   listing: post_id title level_id directory_id status user description excerpt 
   categories locations address_line_1 address_line_2 zip latitude longitude map_icon_file
   tags images videos expiration_date contact_email claimable phone website email
 * Everything works fine when I just update the existing listing.
 * Am I doing something wrong to import a new listing?
 * Kind regards.

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

 *  Plugin Author [Shamalli](https://wordpress.org/support/users/mihail-chepovskiy/)
 * (@mihail-chepovskiy)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/csv-import-45/#post-12264825)
 * Hello,
 * this means that you have wrong number of columns in your CSV file. Take a look
   at the demo CSV file we included into documentation folder.
 *  Thread Starter [gpinkflamingo](https://wordpress.org/support/users/gpinkflamingo/)
 * (@gpinkflamingo)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/csv-import-45/#post-12284109)
 * Thanks for your answer.
 * I found the demo CSV file on my FTP access.
 * The fields are well separated by comas in the cell A1 (company_name,level_ID,
   contact_email,expiration_date,…)
 * But I notice that the data is split into 5 different cells.
    A2 – Benton, John
   B Jr,1,contact@bentonjohnbjr.ru,25.12.2018 12:15,USA > Lousiana B2 – Canada >
   Ottawa > Ottawa,”6649 N Blue Gum St, New Orleans C2 – 1210 Stittsville Main Street”,…
 * Is 5 the number max of columns for the import?
 * Because when I import the same file but with separated cells for each field as
   such:
    A2 – Benton, John B Jr B2 – 1 C2 – [contact@bentonjohnbjr.ru](https://wordpress.org/support/topic/csv-import-45/contact@bentonjohnbjr.ru?output_format=md)
   D2 – 25.12.2018 12:15 E2 – …
 * the error message “Line 2 has too many columns” appears again.
 *  Thread Starter [gpinkflamingo](https://wordpress.org/support/users/gpinkflamingo/)
 * (@gpinkflamingo)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/csv-import-45/#post-12284172)
 * Actually, when I upload the demo CSV file without changing anything, the importation
   works fine.
 * But if I change only 1 character of the data (“Benton” to “Alex”), the error “
   Line 2 has too many columns” appears.
 * How can I solve that issue?
 *  Plugin Author [Shamalli](https://wordpress.org/support/users/mihail-chepovskiy/)
 * (@mihail-chepovskiy)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/csv-import-45/#post-12328064)
 * This could be because you save the file in wrong format. MS Excel saves CSV in
   wrong way when you add/change columns. Try to save the file using Google Tables
   tool.

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

The topic ‘CSV Import’ is closed to new replies.

 * ![](https://ps.w.org/web-directory-free/assets/icon-256x256.gif?rev=3281630)
 * [Web Directory Free](https://wordpress.org/plugins/web-directory-free/)
 * [Support Threads](https://wordpress.org/support/plugin/web-directory-free/)
 * [Active Topics](https://wordpress.org/support/plugin/web-directory-free/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/web-directory-free/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/web-directory-free/reviews/)

## Tags

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

 * 4 replies
 * 2 participants
 * Last reply from: [Shamalli](https://wordpress.org/support/users/mihail-chepovskiy/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/csv-import-45/#post-12328064)
 * Status: resolved