Why not just open the CSV in Numbers or Excel?
A fair look at what a spreadsheet does with a CSV file, what a text editor does, and where a native CSV editor fits between them. Every fact below about another tool is sourced.
Where spreadsheets struggle with CSV
A spreadsheet is made for numbers you type. A CSV is data someone else wrote: a bank, an ERP, a streaming service, a lab instrument. The first limit is size. Numbers stops at 1,000,000 rows. Excel stops at 1,048,576.1 A Google Sheets spreadsheet holds up to 20 million cells, and lives in Google Drive.6 Past that line, the rest of the file doesn’t fit.
The second limit is what happens to the values. By default, opening a CSV in Excel removes leading zeros and turns some values into dates or scientific notation.3 Excel keeps 15 significant digits, so a 16-digit card number or account ID loses its last digit to a zero.4 Since late 2023, the conversions can be turned off in Excel’s settings, but they stay on by default. In 2020, the HUGO Gene Nomenclature Committee renamed 27 human genes, among them SEPT1 and MARCH1, partly because spreadsheets kept turning their names into dates.5
Where a text editor stops
A plain text editor keeps every value as the file wrote it, which is what a CSV needs. It shows lines, though, not columns: no header to sort by, no filter on one column, no total, no type check. Notepad++ runs on Windows. It has never had an official Mac version.7
Notepad++ never shipped for the Mac. Tabulay was made for it.
What a native CSV editor does instead
Tabulay is built around one rule: never change a value you didn’t ask to change. It doesn’t load the file into a grid made for typed data: it memory-maps the file and indexes it in one pass, then parses a row only when it’s shown or queried. A 207 MB, 1.3-million-row file indexes in 0.35 s.2 The grid draws each value as the file wrote it: a 16-digit ID or a gene name stays text, because nothing decided it should become a number or a date. Every column gets a type proposed from a sample and checked on every row; values that don’t fit are counted, never silently converted.
The editor is free: open, find, filter, sort, edit and save from the keyboard, with a full undo history. Tabulay Pro adds what the file needs after that: charts for any column, duplicates and differences shown before anything changes, and a full SQL engine.
Side by side, for CSV work
| What matters for CSV | Spreadsheet apps | Tabulay |
|---|---|---|
| File size and row limit | 1,000,000 rows in Numbers; 1,048,576 in Excel1; 20 million cells in Google Sheets6 | Up to 2 GB, millions of rows2. Larger files open read-only |
| Leading zeros and long IDs | In Excel, leading zeros drop by default; a 16-digit number loses its last digit to a zero34 | Drawn as the file wrote them; IDs and long numbers stay text |
| Gene names and dates, auto-converted | In Excel, by default, date-like values become dates3. 27 human genes were renamed partly for this reason5 | A column’s type comes from what’s in it: identifiers stay exactly as written |
| Saving untouched rows | The whole grid is written back on save, converted values included | Untouched rows are copied byte for byte: same delimiter, quotes, encoding, line endings |
| Decimal comma | Depends on regional settings; set wrong, -1.234,50 is read as text | Detected per column. Sorts, filters and totals to the cent, saved as written |
| Charts | Charts you build and lay out from a selection | Column insights: spread, outliers, breakdowns and timelines for any column, in one click (Tabulay Pro) |
| Queries | Formulas and pivot tables | A full analytical SQL engine, built in (Tabulay Pro) |
| Preview before a bulk change | Replace All runs at once; no count shown first | Shows the exact changes and their count before anything happens (Tabulay Pro) |
| Network and data | Numbers and Excel can stay local; a Google Sheets spreadsheet lives in Google Drive6 | No network access at all; macOS blocks any connection |
1. Numbers: tested on 06/10/2026 with Numbers 14.1 on macOS 27. A CSV with 1,000,050 data rows opened as a table of 1,000,000 rows, header included, and the rest was not imported; a CSV with 1,100 columns opened with 1,000. Microsoft: Excel specifications and limits (1,048,576 rows and 16,384 columns).
2. Tabulay’s own figures, measured on a 207 MB, 1.3-million-row CSV file with a release build of Tabulay’s core engine, on a MacBook Pro, Apple M4 Max, 36 GB, September 2026. Actual times vary with the file and the Mac. See tech specs.
3. By default; Excel for Mac 16.77 and later let you turn this off in settings. Microsoft: import or export text files, Microsoft: automatic data conversions, Microsoft 365 Insider: control data conversions, version 16.77.
4. Microsoft: last digits changed to zeros.
5. Bruford et al., Nature Genetics, 3 Aug 2020.
6. Google Drive Help: files you can store in Google Drive (“up to 20 million cells” for a spreadsheet created in or converted to Google Sheets), checked September 2026.
7. notepad-plus-plus.org; Notepad++ news, 1 May 2026: “Notepad++ has never released a macOS version.”
More on one row from the table: how Tabulay handles decimal-comma bank exports.
Where Tabulay stops
Tabulay opens files up to 2 GB for editing; larger files still open, but read-only. Find, filter chips, sorting, editing, saving and status-bar totals are free, and stay free. Tabulay Pro has eight features: column insights, Remove Duplicates, Compare, SQL queries, query plans, Transform (find & replace, split, merge, computed columns), Normalize and Excel workbooks (.xlsx), all included in the eligible 14-day introductory trial.
When a spreadsheet is the better tool
None of this makes a spreadsheet the wrong tool, only the wrong tool for this job. Live formulas, charts you design and format, and typing data in by hand are what spreadsheets are for. Tabulay has no live formulas, and its charts describe one column; they aren’t documents to lay out. A small file a colleague needs to open, comment on and hand back as one shared workbook belongs in a spreadsheet too: Tabulay edits one file at a time, on one Mac, with no sharing built in. Keep using a spreadsheet for that. Reach for a CSV editor when the file itself is the problem: too big, too easily misread, or too important to risk a silent change.
Other ways to check a file
A command line with a CSV-aware tool filters, sorts and totals a file of any size without opening it in any app, at the cost of remembering the syntax and losing a visual preview. A short script in a language with a data library does much the same, with more flexibility and more setup. Both need someone willing to write and rerun a command each time the question changes; a CSV editor trades some of that for a grid you can look at, a preview before every change, and a history you can undo.
Related guides
Microsoft Excel is a trademark of Microsoft Corporation. Numbers is a trademark of Apple Inc. Google Sheets is a trademark of Google LLC. Notepad++ is a trademark of its author, Don Ho. Tabulay is not affiliated with Apple, Google, Microsoft or Notepad++.