Importing CSV files

Afternoon

I'm just trying to get my data imported for a large send out next week.  I have several Excel files that I'm saving as CSV and importing them into my subscriber list.

One file contained around 2000 entries.  It seemed to be ok but said that a lot of entries already existed, etc.  When I checked the final list there were about 75% missing.

I imported them 'manually' 200 at a time and loads more were added.  There seemed to be a regular pattern where 135 names imported, 63 already existed and 2 were suppressed 4 or 5 times.  It might have been coincidence.

Has anyone had anything similar?  Might there have been a corrupt line in the CSV file that stopped names being imported?

Regards

Andy Jacobs

tobystokes, 8 years ago

Yes, I have had dodgy csv files cause me problems.

If you're opening .xls files, and resaving as .csv, check in the original files for delimiter characters in the data, especially quotation marks and commas!

Join 200,000 companies around the world that use Campaign Monitor to run email marketing campaigns that deliver results for their business.

Get started for free
1-888-533-8098