How can I get the correct csv file format for contact uploads?

Created by Michael Brander, Modified on Fri, 20 Sep at 3:53 AM by Michael Brander

On the Impaxio platform, we work with CSV files for contact uploads. In CSV files columns are commonly either separated by comma or separated by semicolon. At Impaxio, we work with CSV files seperated by semicolons [;]. If your CSV contact list is seperated by commas and you try to upload the contact list to the platform, you might get a failure message. Resolve this issue with one of the following two options:

If you have your contact list in CSV format ready, the easiest way to switch the file format is to search and replace all comma by semicolon:

Open file in excel or in "Editor"
Press CTRL+F or (in excel) go to Editing > Find & Select > Find
Search and replace window should open
Click on replace
In field "Find what" enter the following: ,
In field "Replace with" enter the following ;
Click on "Replace all"
Look through the file to see if replacing all commas with semicolons has worked as expected

If you are working with an original Excel file, you can also directly save semicolon seperated CSV files. When the excel file (not the CSV) is opened, click on "File", then "Save as" then select as file type "CSV UTF-8". That should save the excel file as a CSV file seperated by semicolons.