ARRA User Migrate – how to create a CSV file on a Mac

If you are creating a .CSV file on MAC, please be sure that you are using the option Save As = CSV (Windows), otherwise the format will not be correctly recognized by ARRA User Migrate, .CSV Import.

The same problem is in Linux also (Open Office). It is because Windows uses different End Of Line character than unix-based operating systems, so end of line is not recognized in CSV Import and all fields are treated as columns. https://en.wikipedia.org/wiki/Line_feed

If your Excel don’t have Save As = CSV (Windows) option, use any of the advanced MAC text editors like Textmate or free TextWrangler. Open the .csv file that Excel generated, go to “Save As” and you should be able to save the same file with the correct line endings.