Free ways to view a CSV file on a Mac.

Download Caxton for Free · 7-day free trial of Caxton Pro, no credit card required · 7 MB · macOS 13.0+

Quick Look, for a glance

Good at: the fastest look there is. Select the file in Finder and press the Space bar; Apple describes Quick Look as "a fast, full-size preview of nearly any kind of file without opening the file." Nothing launches and nothing changes. Where it stops: it is a preview, not a viewer you work in. There is no search, no filter, and Apple's page does not say which file types it renders beyond "nearly any kind of file," so a large or unusual CSV may show as text or not at all.

Numbers, for a spreadsheet view

Good at: a familiar table with sorting and filtering. Apple's guide documents filtering: "You can filter the data in a table to show only the data you want to see," by "creating rules that determine which rows in a table are visible." Where it stops: Numbers reads the values on the way in. Its documentation says it "formats table cells automatically," treats a value with a hyphen or a slash as a date, and normally removes a leading zero, so what you view is Numbers' reading of the file, not the file. Apple also notes that a spreadsheet "over 500 MB" may perform better saved as a package. When Numbers can't open your file covers the big ones.

Excel, if you already have it

Good at: the same spreadsheet view, with Find and AutoFilter, inside the app most offices already use. Where it stops: the same automatic reading of values, which Microsoft documents under Automatic Data Conversion ("Removing leading zeros from numerical text and converting to a number," "Converting a continuous string of letters and numbers to a date"), and a worksheet of "1,048,576 rows by 16,384 columns." Excel is part of Microsoft 365, so it is only free to view with if you already have it. CSV too big for Excel is the guide for the file that passes its limit.

TextEdit, for the raw text

Good at: showing exactly what is in the file, commas, quotes and all, with ⌘F to find a word. It is on every Mac. Where it stops: there are no columns to read down, no filter, and a wide export is a wall of long lines.

The Terminal, for small files and scripts

Good at: a quick aligned view with tools that are already there. The column command's manual page documents -t as "Determine the number of columns the input contains and create a table" and -s as "Specify a set of characters to be used to delimit columns for the -t option," so column -s , -t customers.csv | less lines the columns up on the screen. grep finds a row. Where it stops: column does not understand quoted commas, and its manual page notes that "Input lines are limited to LINE_MAX (2048) bytes in length." For real CSV rules, csvkit's csvlook "Renders a CSV to the command line in a Markdown-compatible, fixed-width format," with --max-rows to truncate the display; by default it infers types, and its -I, --no-inference option turns that off so values are shown as written. Both need a few minutes in the Terminal to install and learn.

column -s , -t customers.csv | less -S
csvlook -I --max-rows 50 customers.csv

Online CSV viewers

Good at: a table in a browser tab with nothing to install. Where it stops: every one of them works by uploading the file to a server you do not control. For a customer list, a financial export or anything with personal data in it, that is the wrong trade, and a large file is slow or refused. Everything else on this page reads the file on your own Mac.

Dedicated CSV apps for Mac

Several apps are built for CSV files specifically. Each is described here only from its own site, and prices are left out on purpose.

• Tad is "a free (MIT Licensed) desktop application for viewing and analyzing tabular data," described on its site as "A fast viewer for CSV and Parquet files and SQLite and DuckDb databases that supports large files," with installers for "macOS (x86 and Apple Silicon), Linux and Windows." No size limit is documented.
• Table Tool is "A simple CSV editor for OS X," open source under the MIT licence, which "detects the specification of a CSV file for you and displays its contents in a table view" and handles "different record delimiters (comma or semicolon), character encodings, decimal separators or quoting styles." Its project page says "Any formatting options or features like formulas will be out of scope for the project." No size limit is documented.
• Modern CSV is "a powerful CSV file editor/viewer application for Windows, Mac, and Linux," with "a read-only mode that loads large files quickly and with a small memory footprint just a fraction of the file size" and "Multiple character encodings supported." No size limit is documented.
• Easy CSV Editor is "A beautiful and powerful editor for your CSV files. Specifically created for Mac," with the delimiter and encoding set per document. No size limit is documented.

Caxton Free, a CSV viewer at any size

Caxton is a Mac editor for text and data files, and Caxton Free is the viewer part of it, with no time limit. A .csv, .tsv, .psv or .dsv file opens straight into a table that is a view of the file itself: nothing is imported, and every value is shown exactly as the file has it. The grid button, or View ▸ CSV Grid View (⇧⌘C), shows the same file as plain text and back. ⌘F searches and counts every match; Filter Lines (⇧⌘L), Filter to a value from a cell's right-click menu, and CSV ▸ Advanced Filter… narrow the rows without touching the file; the Column Profile (⌃⌘7) lists what a column holds, counted. A file of 300 MB or more opens through the Open Large File dialog and is indexed in the background while you read; the measured runs, up to 50 GB, are on the benchmarks page. Editing cells, sorting, transforms and saving are Caxton Pro, which comes with a 7-day free trial of Caxton Pro and no credit card. For editing rather than viewing, choosing a CSV editor on a Mac is the guide.

How do the viewers compare?

Say it plainly: for a glance, Quick Look; for a spreadsheet you will keep working in, Numbers or Excel; for the exact bytes, TextEdit; for a script, the Terminal. Caxton Free's lane is the CSV you want to read as a table without a spreadsheet re-reading the values, at any size, with search and filters, and the file left exactly as it was.

Frequently asked questions

Sources

• Apple Support: View and edit files with Quick Look on Mac
• Apple Support: Filter data in Numbers on Mac
• Apple Support: Format dates, currency, and more in Numbers on Mac
• Apple Support: Save a large spreadsheet as a package file in Numbers on Mac
• Microsoft Support: Set automatic data conversions in Excel
• Microsoft Support: Excel specifications and limits
• column(1), the manual page shipped with macOS (man column): -s, -t and the LINE_MAX note
• csvkit documentation: csvlook
• Tad: tadviewer.com
• Table Tool on GitHub
• Modern CSV: moderncsv.com
• Easy CSV Editor: vdt-labs.com
• Caxton manual: the CSV workbench and the benchmarks page