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.
Large file text editors on a Mac
Nothing mainstream was designed for 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.
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.
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.
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.