Guides
Practical answers for working with large files and CSVs on a Mac: what the common tools were designed for, with honest free alternatives before Caxton.
Download Caxton for Free · 7 days, no card · 5 MB · macOS 13.0+
Large file text editors on a Mac
Most mainstream editors are not designed around multi-gigabyte files. What EmEditor, VS Code, BBEdit, Hex Fiend, and less were each built for, and what was built for this.
EmEditor for Mac
There is no Mac version; EmEditor is Windows-only. The migration mapping for its huge-file workflow, feature by feature, including the honest gaps.
UltraEdit alternatives for a Mac
UltraEdit runs on macOS by subscription. The native options by the job you are replacing, and the one-time-purchase editors, prices dated.
File too large for VS Code
Past 30 MB or 300K lines VS Code turns off tokenization, wrapping, and folding by documented design. Keep it for code; open the file next to it.
Choosing a CSV editor on a Mac
Numbers and Excel are good up to their documented caps. The desktop utilities, the command-line tools, and the editor for files past all of them.
Edit a CSV without Excel changing the data
Leading zeros, long IDs, and date-shaped text change on import by design. Excel's own Text import holds it back; a direct CSV editor never re-types at all.
Sort a multi-million-row CSV on a Mac
sort and DuckDB write ordered copies free. Sorting you can see, check, and edit afterward takes a grid with no fixed row limit.
CSV too big for Excel on a Mac
Excel stops at 1,048,576 rows on every machine. Splitting, querying with DuckDB, when Google Sheets fits, and opening every row.
How to open a large CSV file on a Mac
Files in the hundreds of megabytes freeze apps that load everything into memory. Streaming tools, SQL without opening, and memory-mapped editing.
Choosing a log viewer on a Mac
Console for the Mac's own logs, less and lnav free in Terminal, klogg and Whaile as viewers. Moving through a 10 GB log by time and severity, then fixing it, is the editor's lane.
How to open a 10 GB log file on a Mac
less views it instantly and free. Searching millions of matches, filtering the noise, and fixing the file need a memory-mapped editor.
How to filter a large log file on a Mac
grep extracts the error lines free. Iterating on conditions, keeping line numbers, and editing the result take a filter that is a live view.
Find and replace in a huge file on a Mac
sed streams a known substitution to a new file. A million-site rewrite with a preview, honest counts, and one undo step is an editor job.
How to open a SQL dump on a Mac
less and grep read it free; restoring locally answers queries. Editing the dump itself, megabyte-long INSERT lines included, takes a long-line editor.
How to open a large JSON file on a Mac
jq and DuckDB answer questions free. Seeing and editing the raw text, one-line exports included, is a memory-mapped editor job.
When Numbers can't open your file
Apple Numbers holds 1,000,000 rows and 1,000 columns per table. What those limits mean and what opens the file instead.