Skip to main content
Amy_Goldfine
Amy_Goldfine
Level 9
May 11, 2020
Question

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Warren_Stokes1
Warren_Stokes1
Level 2
May 12, 2020

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

 

Translate
Terms & ConditionsAccessibility statement

Loading footer...