The short answer. SmoothCSV is the one built for the file: fast opening, proper quoting, and SQL queries over the rows. Tad is the viewer for analysing tabular data, which is the read-first interpretation. TableTool is the CSV browser for looking at a file without opening a spreadsheet. Numbers is the spreadsheet, which is the right tool when the file is going to become a document with formulas. MDB Explorer handles the Access database format, which is a different problem that arrives with the same shape. The dividing question is whether you are editing a file or analysing a table, because a text editor with columns and a spreadsheet with formulas are different answers to “I have a CSV”.
This guide covers 5 csv and tabular data editors for macOS. Every fact below is drawn from the same verified records that back each app’s own page. The recommendations are our editorial judgment, not payment.
Quick comparison
| App | What it is | Pricing | Licence | Version |
|---|---|---|---|---|
| MDB Explorer | developer tool | not published | not published | — |
| Numbers | productivity app | Free | not published | — |
| SmoothCSV | productivity app | Free | not published | 3.25.1 |
| TableTool | productivity app | not published | not published | 1.2.1 |
| Tad | productivity app | Open source | MIT | 0.14.0 |
What actually decides this
- Edit or analyse. An editor changes values and saves the file. An analyser filters, sorts and aggregates without pretending to be a spreadsheet. The second is faster for a question and the first is necessary for a correction.
- Whether quoting survives a round trip. A field containing a comma, a quote or a newline is where CSV tools fail. The test is to open a file with all three, save it, and diff the result. Most tools pass the display and fail the save.
- How large a file it opens. A hundred thousand rows is a spreadsheet. Ten million is a database problem with a CSV interface. The tool that streams is the one that opens the file at all.
- Whether it can query. SQL over a CSV is the feature that turns a file into a table you can ask questions of. It is also the feature that reveals whether the tool parsed the types correctly, because a column of numbers stored as text will sort wrong.
- What the output is. Saving the same CSV, exporting to another format, or producing a chart are three different endings. If the file has to go back into a pipeline, the first is the only acceptable one.
Our picks
- SmoothCSV — Its record describes a fast, full-featured CSV editor with SQL queries, which is the editor case. Choose it when you need to edit a large CSV without breaking its quoting.
- Tad — Its record describes viewing and analysing tabular data such as CSV files, which is the analysis case. Choose it when you want to look at and analyse tabular data.
- TableTool — Its record describes an effortless CSV browser, which is the read-only case. Choose it when you just need to browse a CSV quickly.
- Numbers — Its record describes creating spreadsheets, which is the spreadsheet case. Choose it when the file is going to become a document with formulas.
- MDB Explorer — Its record describes opening, reading and exporting MDB files, which is the Access case. Choose it when the file is a Microsoft Access database.
The apps
MDB Explorer
MDB Explorer is a developer tool for macOS. MDB tool to open, read, export your MDB files to other formats and databases. Its pricing is not published.
Full profile and verified facts for MDB Explorer →
Numbers
Numbers is a productivity app for macOS. Create impressive spreadsheets. It is free.
Full profile and verified facts for Numbers →
SmoothCSV
SmoothCSV is a productivity app for macOS. Fast, full-featured CSV editor with SQL queries. It is free.
What it does. SmoothCSV is the ultimate CSV editor for macOS, Windows, and Linux — open huge files in seconds and edit with a familiar spreadsheet UI.
SmoothCSV is listed with current version 3.25.1.
Full profile and verified facts for SmoothCSV →
TableTool
TableTool is a productivity app for macOS. Effortless CSV Browser! Its pricing is not published.
What it does. The Effortless CSV Browser.
TableTool is listed with current version 1.2.1.
Full profile and verified facts for TableTool →
Tad
Tad is a productivity app for macOS. Application for viewing and analyzing tabular data such as CSV files. It is released under MIT.
What it does. Tad is a fast, free, cross-platform desktop application for viewing and analyzing tabular data files.
Tad is listed with current version 0.14.0.
Full profile and verified facts for Tad →
How to choose
- Free of charge. Numbers and SmoothCSV — no payment is required.
- No licence fee, source available. Tad — the source can be read and, under the terms of each licence, reused.
- Pricing not published in our data. MDB Explorer and TableTool — check the developer’s own site before assuming anything about cost.
Open source: Tad (1 of 5).
Common mistakes
- Saving a CSV from a spreadsheet and changing the delimiter or the encoding without noticing.
- Opening a ten-million-row file in a tool that loads it into memory.
- Sorting a numeric column that was parsed as text and trusting the order.
- Editing a production export in place instead of a copy.
- Assuming a CSV browser can save what it displayed. Some can only look.
- Letting a spreadsheet guess the column type and silently turning an ID into a date.
- Trusting a row count from a tool that skipped the lines it could not parse.
How this guide was put together
Each app’s facts come from its own record: the developer’s own pages and repository, the App Store listing where one exists, and the documentation, each with a source grade and an access date. Where a fact rests on the developer’s own statement rather than on something we verified independently, the sentence says so. Where our data has no value for something, the guide says “not published” instead of guessing.
A price appears here only where the record carries one from a stated source; the guide never estimates one, and it records the pricing model alongside so the two can be read together. Prices change and vary by region, so each app links to its own page for the current detail.
The facts and the recommendations are kept apart on purpose. Everything in the app entries, the comparison table and the answers above is composed from the records. The short answer, the criteria and the picks are our editorial judgment: they reflect what we would choose and why, and they are not paid for. Where we make a recommendation we name the condition it applies under, because we do not call anything “the best” without explaining the criteria.
Frequently Asked Questions
How do I choose between these csv and tabular data editors?
There is no single answer — it depends on what you need. This guide covers 5 csv and tabular data editors: MDB Explorer, Numbers, SmoothCSV, TableTool and Tad. They differ mainly in pricing model, licence and the trade-offs each one carries. Pick by the trade-off you care about rather than by rank.
Are these csv and tabular data editors free?
Pricing across this group: not published (MDB Explorer and TableTool), free (Numbers and SmoothCSV) and open source (Tad). Where we list pricing as not published, the developer does not state a model we could verify — check their own site before assuming anything about cost. We quote a price only where the record carries one from a stated source, and we never estimate one. Prices change and vary by region and by store, so always check the developer’s own page for the current figure.
Which of these csv and tabular data editors are open source?
Tad (MIT) is open source.
Do these csv and tabular data editors support Apple Silicon?
Our data does not carry an explicit Apple Silicon statement for any app in this group, so we do not claim one. The absence of a statement is not the same as the absence of support.
How do I choose between them?
Start with how you pay: the guide groups these apps by pricing model, because the budget is the constraint most people actually have. Then check the trade-offs listed for each app: the limitations are the part that decides most people’s choice, because they describe what the app will not do for you.
