Excel List Won't Import

I’ve used phpList in the past with no problems importing excel lists [all items with same attributes. This morning I got the following fatal error when trying to import a list of email addresses:
“Fatal Error: Some characters that are not valid have been found. These might be delimiters. Please check the file and select the right delimiter. ,”

I also then receive an email which says:
"An error has occurred in the Mailinglist System
URL: /lists/admin/?page=import1
Error: Some characters that are not valid have been found. These might
be delimiters. Please check the file and select the right delimiter. , "

I have tried importing several lists, always getting the same “fatal error”.

Not to sound dumb, but what’s a “delimiter”. I have checked all the email addresses on the list & found no structural errors. Or do I have to indicate the “delimiter” somewhere else? if so, where?

Problem resolved. I forgot to change the xls file to txt [tab delimted].
Scores high on the dumb category. :smile:
-George

2 Likes

You can also set the deliminator you want to use when you import https://www.phplist.org/manual/ch013_adding-subscribers-to-lists.xhtml