Why not just open the CSV in a spreadsheet?
A fair look at what a spreadsheet does well with a CSV file, and where a dedicated CSV workbench picks up the difference. Every spreadsheet fact below is sourced.
Where spreadsheets struggle with CSV
A spreadsheet was built for rows you type by hand, not a file handed to you by a bank, an ERP or a lab instrument. The first limit is size: an Excel worksheet holds 1,048,576 rows and 16,384 columns, and a Numbers table holds up to 1,000,000 rows, so a file past that line loses its last rows without a clear warning.1
By default, opening a CSV in Excel also removes leading zeros and turns some values that look like dates into dates, or into 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, this can be turned off in Excel's settings, but it stays 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
What a CSV workbench 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 built 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 Every column gets a type proposed from a sample and checked on every row; values that don't fit are counted, never silently converted. A 16-digit ID or a gene name stays text, because nothing decided it should become a number or a date.
Side by side, for CSV work
| What matters for CSV | Spreadsheet apps | Tabulay |
|---|---|---|
| File size and row limit | 1,048,576 rows in Excel; 1,000,000 in Numbers1 | Up to 2 GB, millions of rows2. Larger files open read-only |
| Leading zeros and long IDs | Leading zeros drop by default; a 16-digit number loses its last digit to a zero34 | Every column keeps its type until checked; IDs and long numbers stay text |
| Gene names and dates, auto-converted | 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 rewritten 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 |
| SQL | Formulas and pivot tables; no query language | A full analytical SQL engine, built in (Tabulay Pro) |
| Preview before a bulk change | Find and replace runs immediately; no count shown first | Shows the exact changes and their count before anything happens (Tabulay Pro) |
| Undo history | Steps back through recent actions in the session | Every change is a named step; undo, redo, or jump back to any point |
| Network and data | A desktop spreadsheet can stay local; a cloud one needs the file uploaded | No network permission at all; macOS blocks any connection |
1. Microsoft: Excel specifications and limits. Apple: Numbers User Guide.
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, 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.
4. Microsoft: last digits changed to zeros.
5. Bruford et al., Nature Genetics, 3 Aug 2020.
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. Filter chips, Find, sorting and status-bar totals are free, and stay free. SQL, column insights, Find & replace, split and merge, Normalize, Remove Duplicates, Compare and Excel workbook (.xlsx) support are Tabulay Pro, included in the 14-day 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 built in a few clicks, and typing data in by hand are what spreadsheets are for, and Tabulay does none of them. 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 workbench 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 workbench trades some of that for a grid you can look at, a preview before every change, and a history you can undo.
Microsoft Excel is a trademark of Microsoft Corporation. Tabulay is not affiliated with it.