Recommendations for a Mac-compatible CSV editor? | Community
Skip to main content
Amy_Goldfine
Amy_Goldfine
Level 9
May 11, 2020
Question

Recommendations for a Mac-compatible CSV editor?

  • May 11, 2020
  • 1 reply
  • 2423 views

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

 

Terms & ConditionsAccessibility statement

Loading footer...