Excel does run on macOS, and for a lot of people the honest answer is to buy it. This page is for the other situation: you do not want a subscription, you have one spreadsheet to deal with, and every specialist tool you find turns out to be Windows-only.
It is worth separating two different needs that get discussed as if they were one. Editing a spreadsheet — formulas, formatting, a document you maintain — and reading one, which is what an export from an accounting system, a shop or a CRM actually needs. Most of the frustration comes from using an editing tool for a reading job.
| Option | Good at | Where it bites |
|---|---|---|
| Numbers (free, installed) | Your own documents; genuinely nice to use; charts look good with no effort | Round-tripping .xlsx with Excel users changes formatting and breaks less common formulas. Row ceiling is one million, slightly below Excel's |
| LibreOffice Calc (free) | The closest functional match to Excel on macOS; a real CSV import dialog with per-column types | The interface is dated and does not feel like a Mac app — the usual reason people give up on it |
| Google Sheets (free with an account) | Collaboration; nothing to install; works anywhere | The file is uploaded to Google by definition. For a client's data that may not be your call. Slows noticeably past a few hundred thousand cells |
| Excel for Mac (subscription) | Exact compatibility, which is sometimes the entire requirement | Cost, and it carries the same CSV import behaviour as the Windows version |
If you exchange files with Excel users all day, Excel is the answer and the rest is a compromise. If you mostly receive exports and need to understand them, none of these four is really aimed at the job.
An export arrives. You want to know what is in it: which columns, how many rows, what the totals are by category, whether anything looks wrong. Opening it in a spreadsheet is how most people start, and it introduces a problem before you have learned anything — the import rewrites values. Leading zeros disappear from reference codes, long identifiers become 1.23457E+14, and text that looks like a date becomes one. Excel does this, and so, in their own ways, do Numbers and Google Sheets. The details are in why Excel ruins CSV files.
For reading, what you want is something that shows the file as it is and summarises it, without converting anything and without you having to build the summary yourself.
A browser can read a file from your disk directly, using an API that has existed for well over a decade, and process it with code running on your own machine. No upload, no account, no installer — and no platform question, because the work is done by the browser rather than by a macOS application. The same page behaves the same way on a Mac, a PC and a Linux machine.
That is what makes "Windows-only" so often a distribution decision rather than a technical one. Native desktop tools ship for Windows because that is where the business audience is and a second native build costs real money to maintain. A web page has no such choice to make.
And you can verify the no-upload part yourself, on any tool. Open developer tools, go to the Network tab, then drop your file in. Nothing new in the list means the file stayed on your machine. A POST the size of your file means it did not.
That is a mechanism rather than a promise, which is the point. More on it in how to analyze a CSV without uploading it anywhere.
Sheet Insights is a web application. On a Mac you open it in the browser you already have and drop a file in — nothing to install, and the file is read locally, same as on any other platform.
The paid version is a Windows app from the Microsoft Store, and there is no macOS build of it. What it adds is the ability to save things back out: the cleaned file, the report, the JSON. So on a Mac you get the analysis — all of it — and not the export step. That is a real limitation and it is better stated here than discovered later.
The free web version opens two files of your own and shows everything: executive summary, totals by category, trends, column statistics, outliers, data-quality checks, charts, and the clean-up recipe. There is also a sample dataset that does not count against those two, so you can see the whole thing before deciding whether it is useful to you.
Each is a single page with no account and no server behind it.
For editing documents on a Mac, Numbers if they are yours and LibreOffice Calc if they have to survive contact with Excel users. For collaboration, Google Sheets, as long as uploading the file is a decision you are allowed to make. For reading and understanding an export, none of those is the right shape — a browser-based tool avoids both the platform question and the import conversions, because it neither installs anything nor rewrites your values on the way in.
Why Excel ruins CSV files: the conversions every spreadsheet applies while opening a CSV.
A CSV viewer that does not ask you to upload the file: for when you only need to look.
How to open a CSV that is too big for Excel: the row ceiling, and what to do above it.
Sheet Insights reads an Excel or CSV file and builds the analysis straight away — executive summary, totals by category, trends over time, column statistics, outliers, data-quality checks and a repeatable clean-up recipe for the columns that always come in dirty. No installation, no account, no upload, no row limit. The free web version opens two files of your own and shows all of it; saving the cleaned file, the report or the JSON back out is what the Windows app does.
Open it and drop a file in