47

I need to view (large) CSV files on my Mac. I could use something like OpenOffice, but unfortunately it's pretty big and slow. I'm wondering if there's a Mac equivalent of some of the Windows tools mentioned on this SU question.

  • 1
    Adding on my own remark about the slowness of OpenOffice: the new LibreOffice is a lot faster in starting up than the old Oracle version. Still a bit heavy for just viewing CSV files though. – Hay Feb 25 '11 at 15:19
51

Quick Look the file. There are two methods of doing so.

  1. Right click the file, in the context menu, select 'Quick Look "file you right-clicked"'.
  2. Click the file, keyboard shortcut Command-Y.
| improve this answer | |
  • 2
    Probably the easiest way of doing this. – John Riselvato Jun 11 '12 at 2:59
  • 7
    also you can select the file and press "spacebar" – GusDeCooL Jun 28 '13 at 22:14
  • Too slow on the latest MBP for CSV files even over a few MB... – Matt Sep 18 '13 at 5:06
  • This is cool and all, but you can't even select data to copy/paste. – Ezekiel Victor Mar 9 '18 at 0:48
17

Update 7/24/2019

Commenter @Boris Yakubchik points out there's a new CSV app: Tablecruncher - tablecruncher.com . I have not tested it.

Update 4/13/2017

There's a new desktop app for viewing and analyzing CSV files on macOS: Tad.

Update 9/8/2016

There's a new cross-platform desktop app for viewing CSV files: Comma Chameleon.

Original answer

Open Refine weighs in at 50.6 MB, but I don't think that's the 'weight' you're interested in. Anyway I think it's a good tool for any size dataset. They make it faster by paginating the data.

| improve this answer | |
  • 1
    This is the BEST tool to edit/refine/reformat CSV files. Period. – Landitus Feb 4 '12 at 22:26
  • Very good indeed, but that's not what we can call lightweight – lajarre Jan 17 '13 at 17:26
  • Google Refine is now archived. Can you suggest alternatives? – Manu Manjunath Jan 14 '16 at 6:49
  • @Manu Google no longer maintains Refine, but it's still available as an open source project: openrefine.org – Patrick Berkeley Jan 14 '16 at 11:39
  • Chokes on a 2GB file. – logic-unit Aug 5 '16 at 13:15
5

Not sure how light-weight it is, but I found this with a quick Google search: XTabulator 2

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.

| improve this answer | |
  • A note for others: Free version adds a line "Created by XTabulator" in every CSV you edit with it. – Manu Manjunath Jan 14 '16 at 6:51

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