After years of fighting with Excel when cleaning up CSVs to upload to Marketo (tradeshow lists, etc.), it occurred to me that there has to be something better! I think we've all experienced Excel being "helpful" by turning a phone number into scientific notation, or changing a range (e.g. "1-10") into a number. Does anyone have a macOS tool that they like?
Amy Goldfine Marketo Champion & Adobe Community Advisor
If your company has g-suite you can use import csv. https://help.loyverse.com/help/how-open-csv-file-google-sheets bonus being that google sheets is quite smart at recognising the phone numbers. I don't recommend your personal Gmail account for handling sensitive information
On 'numbers' which is the standard mac application:
Open the .csv file in a text editor like TextEdit on Mac.
Do afind&replace. Find","and replace with";".
Save the .csv file.
Drag-and-drop the file onto the Numbers app icon.
Apple Numbers displays the data in a new sheet.
Alternatively, the best way would not have to edit it. If I see a new variation of field name come across I'll always add it to the list import alias within-field management (under admin) I find this a tad quicker than having to map it on upload.
Adchoices