Importing CSV file of subscribers.

Questions related to the phpList Hosted service

Importing CSV file of subscribers.

Postby derekjackson » 10:20am, Mon 20 Jun, 2011

I'm struggling to import our contact list in CSV format. I was hoping to bring in the person's first name, surname and company along with their email address but I keep getting this message:
Fatal Error: Cannot find column with email, please make sure the column is called "email" and not eg e-mail, and that your column delimiter is correct

My list is in an Excel table setup like the attached image. As my email column seems to be named as required, I guess the error is the column delimiter - what should I be doing here? (I've left the Field and Record Delimiter values as default)

Any help appreciated!


CSV file.jpg
CSV file example
CSV file.jpg (201.35 KiB) Viewed 3795 times
phpList newbie
Posts: 3
Joined: 3:48pm, Thu 16 Jun, 2011

Re: Importing CSV file of subscribers.

Postby Dragonrider » 12:03pm, Mon 20 Jun, 2011

Easiest way I have found to be sure I get the format correct is to do an export from phpList, then use that as the basic format to import your own data.
My sites:-,,,
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Return to phpList Hosted

Who is online

Users browsing this forum: No registered users and 1 guest