Title: Import CSV error
Last modified: August 31, 2016

---

# Import CSV error

 *  [joelcdmedia](https://wordpress.org/support/users/joelcdmedia/)
 * (@joelcdmedia)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/import-csv-error-1/)
 * Hi there,
 * I am trying to import a CSV file with events in it and I keep getting this error:
 * array(6) { [0]=> string(5) “sep=,” [1]=> string(0) “” [2]=> string(0) “” [3]=
   > string(0) “” [4]=> string(0) “” [5]=> string(0) “” } array(6) { [0]=> string(
   5) “title” [1]=> string(10) “start date” [2]=> string(8) “end date” [3]=> string(
   4) “time” [4]=> string(8) “location” [5]=> string(7) “details” }
 * My CSV file has dates in this format: 01-04-2016 and I have changed the setting
   to d m Y.
 * What could be causing this?
 * Thanks
 * [https://wordpress.org/plugins/event-list/](https://wordpress.org/plugins/event-list/)

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

 *  [redthinkingcap](https://wordpress.org/support/users/redthinkingcap/)
 * (@redthinkingcap)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/import-csv-error-1/#post-6946071)
 * I also have this issue and can’t figure out the solution. I have also been adjusting
   my date formats, to no avail. Developer please help!
 *  [Jaaaarne](https://wordpress.org/support/users/jaaaarne/)
 * (@jaaaarne)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/import-csv-error-1/#post-6946093)
 * It’s something the editing software (Excel or Calc etc.) does. It adds extra 
   commas to the first line of the CSV file, like this:
 * `"sep=,",,,,,`
 * However, the correct line should look like this:
 * `"sep=,"`
 * These extra commas cause the import to fail.
 * The solution I personally use:
 * – add all your events to the example CSV file,
    – save the file as CSV and close
   it, – open it in a UTF text editor (avoid Windows Notepad; I personally use UnicEdit,
   it’s good and free), – remove extra commas from the first line, don’t touch anything
   else, – save the file, – import it without a hitch.

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

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

 * ![](https://s.w.org/plugins/geopattern-icon/event-list_f8f8f8.svg)
 * [Event List](https://wordpress.org/plugins/event-list/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/event-list/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/event-list/)
 * [Active Topics](https://wordpress.org/support/plugin/event-list/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/event-list/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/event-list/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [Jaaaarne](https://wordpress.org/support/users/jaaaarne/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/import-csv-error-1/#post-6946093)
 * Status: not resolved