# Cannot get CSV contact file import working **URL:** \ **Category:** Pro and Max\ **Created:** [September 9, 2018, 10:07am UTC](https://integration.keap.com/t/cannot-get-csv-contact-file-import-working/51871 "2018-09-09T10:07:31Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Jari\_Kaitera](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@Jari\_Kaitera](https://integration.keap.com/u/Jari_Kaitera)\ **Post date:** [September 9, 2018, 10:07am UTC](https://integration.keap.com/t/cannot-get-csv-contact-file-import-working/51871/1 "2018-09-09T10:07:31Z")
Hi, just starting to use the system (new version). My contact file in excel. Is pretty clean and ok based on instructions. But once I save it in MAC excel (Save as, CSV UTF-8 comma delimited csv. format), infusion soft does not recognize this file. Once I got it to show import but all the columns were together (not separated). Can anone help? I have tried to import also this in Macintosh and MS-DOS comma separated format, but system complaings that something went wrong. FIle has some empty fields as it is an export from old CRM system. ---
**Author:** ![martinc](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/martinc/32/14_2.png) [@martinc](https://integration.keap.com/u/martinc)\ **Post date:** [September 10, 2018, 4:23pm UTC](https://integration.keap.com/t/cannot-get-csv-contact-file-import-working/51871/2 "2018-09-10T16:23:00Z")
Hi, @Jari_Kaitera. Do you have the option to save it as just “CSV Comma Delimited” I think the problem may be that those other CSV versions are trying to re-encode your data and it’s breaking things. If I knew [the file itself was solid](https://classic-infusionsoft.knowledgeowl.com/help/prepare-your-csv-file-to-import), I would upload it to Google Sheets and download it again as a plain CSV and try to upload it again. ---
**Author:** ![Jari\_Kaitera](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@Jari\_Kaitera](https://integration.keap.com/u/Jari_Kaitera)\ **Post date:** [September 10, 2018, 6:14pm UTC](https://integration.keap.com/t/cannot-get-csv-contact-file-import-working/51871/3 "2018-09-10T18:14:24Z")
@martinc thanks, I eventually also discovered that Excel does not make the CSV file with commas but instead semicolons. So I saved the file in excel, then opened it in text editor, replaced all the semincolons with commas. Then saved it, and it worked. So import completed successfully. ---
**Author:** ![Juha-Mikael\_Malinen](https://avatars.discourse-cdn.com/v4/letter/j/73ab20/32.png) [@Juha-Mikael\_Malinen](https://integration.keap.com/u/Juha-Mikael_Malinen)\ **Post date:** [May 5, 2020, 12:10pm UTC](https://integration.keap.com/t/cannot-get-csv-contact-file-import-working/51871/4 "2020-05-05T12:10:20Z")
We have a same problem with CSV and semicolons. We are also using Mac. Have you found easier way to import CSV files than changing semicolons to commas manually in a text editor?