Sign up ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I am looking for a free editor to edit comma-delimited text files, or .csv format.

share|improve this question
What do you need a special, CSV-specific editor to do that something like CodeWrangler (or anything with column-based selections) can't do for you? Might help guide the answers if you could detail why something like Google Docs or CodeWrangler doesn't cut it for you. – Ian C. Jun 14 '11 at 13:56
@IanC What is CodeWrangler? When I google it, I don't find a link to a piece of software by that name. – Daniel Dec 24 '11 at 17:38
@Daniel it's a typo. I meant TextWrangler from Bare Bones Software. – Ian C. Dec 24 '11 at 19:01
@IanC. darn. I'd hoped there was a cool piece of software I didn't know about. TextWrangler is awesome, but I've been using it since it first came out. – Daniel Dec 27 '11 at 2:16
Column-based selection won't help if the CSV has varying-width fields, right? – Alan Shutko Aug 22 at 0:49

8 Answers 8

Google Docs

I just used Google Docs for exactly this purpose but all I needed to do was extract a column of email addresses from a CSV file.

share|improve this answer


LibreOffice does quite a good job now and is compatible even with OS X 10.9

share|improve this answer
And it's fast to start and compatible with all the weird CSV gotchas floating around. +1 – a paid nerd Jan 13 at 1:32


The latest version of NeoOffice works fine (in that it supports Versions etc) but you need to donate a small amount of money to download it before the end of August 2011.

share|improve this answer
24$ yuck, to test a beta, probably never... others are paying you to test beta :) – sorin Aug 11 '11 at 17:34
I highly recommend NeoOffice. I have used it for eight years. It is a fork of OpenOffice and LibreOffice with Mac OS-specific features and fully suports Mac OS 10.7 Lion. You can download and use version 3.1 for free; only the most recent version 3.2 requires a donation. – Wheat Williams Dec 24 '11 at 18:34

csveditor (Java)

Very simple (no undo), java program (some may stop reading here ;) - does the job

You have to create an empty table upon launch but then you can open any file.

Screenshot: Java csveditor, by bertramfritz

share|improve this answer
You most certainly lost me at "Java" – AMomchilov Aug 22 at 1:39


Disclaimer: Free on new Macs

Apple Numbers also opens and saves to CSV. Just had to add to the list.

CSV in Text Editor


Numbers CSV Edit

Save as CSV after editing:

Export to CSV

Note that you can choose text encoding as well when exporting if needed for other systems.

share|improve this answer
For my CSV editing needs (which are few) I use Numbers and TextEdit. – GEdgar Aug 22 at 0:48
Yep, that works. For me, Textastic or TextWrangler and Numbers work just fine. – bjbk Aug 22 at 0:51

Open Refine

When interacting with large and messy text csv and other structured text files, I now typically go to Google Refine (now called Open Refine). I've used it for TSV/CSV, JSON, and XML documents. In my experience it crashes rarely, and is pretty good for mangling data (you can apply transformations with scripting languages).

Its approach is more database-oriented, rather than spreadsheet oriented.

share|improve this answer

Apache Open Office

Free. Reads, writes, creates CSV, Excel, Word and an number of other formats.

share|improve this answer


XTabulator edits CSV but is not free.

XTabulator is a tabular data file editor for Mac OS X. With XTabulator, you can edit, manipulate, massage, slice, and dice comma-separated (CSV), tab-separated (TAB), or anything-separated files quickly and easily.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.