Re: Recommendations for a Mac-compatible CSV editor?

Amy_Goldfine
Level 10 - Champion Alumni

Recommendations for a Mac-compatible CSV editor?

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
1 REPLY 1
Warren_Stokes3
Level 1

Re: Recommendations for a Mac-compatible CSV editor?

Heya - 

 

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:

  1. Open the .csv file in a text editor like TextEdit on Mac.
  2. Do a find&replace. Find "," and replace with ";".
  3. Save the .csv file.
  4. Drag-and-drop the file onto the Numbers app icon.
  5. 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.

 

Hope that helps