CSV Desk Open an XLSX File on a Mac Without Excel

Open an XLSX File on a Mac Without Excel

You don't need Excel to read a workbook on a Mac. What you need depends on whether you want to look at it, edit it or turn it into something else.

A workbook is not like a CSV, which any text editor can read. An .xlsx file is a compressed archive of XML, so it takes an app that understands the format. A Mac already has two.

Quick Look

Select the file in Finder and press Space. You get a preview of the workbook, usually with a tab for each sheet. It’s the fastest way to check what’s in a file, and it can’t change anything.

Numbers

Numbers is free and comes with macOS. Double-click won’t use it if another app owns the file type, so right-click the file and choose Open With, then Numbers. It imports a copy, so your original stays as it was. Complex formatting and some functions may not come across exactly.

LibreOffice

LibreOffice is free and is the closest thing to Excel here, with real editing and formulas. It’s also the heaviest install, and it’s more than you need if you only want to read a file.

CSV Desk

CSV Desk opens .xlsx, .xls and .ods files read-only. You pick the sheet, and it shows the values in a grid you can sort, filter and search, with statistics for each column. There’s no formatting and no formulas: you see each cell’s value as the workbook stored it, and your workbook isn’t changed.

It suits the case where you got a workbook from someone else and want to know what’s in it, or need the data out of it.

Converting Excel to CSV

For one file, open it, pick the sheet and export. For a folder of them, File, then Convert Files takes a list of workbooks and CSVs and writes each one in the format you choose, into a folder you pick. Your originals aren’t touched, and nothing gets replaced: if a name is taken, the new file becomes “name 2”. Each sheet with data becomes its own file, such as book – Sheet1.csv.

There are Shortcuts actions for the same job on macOS 13 and later, so a conversion can run from a Finder Quick Action or an automation.

Which to use

To glance at a file, use Quick Look. To work inside a workbook, use Numbers or LibreOffice. To read the data, check it or get it out as CSV, use CSV Desk.

Questions

Can I open an XLSX file on a Mac without Excel?

Yes. Numbers comes with every Mac and opens .xlsx files. Quick Look shows a preview without opening anything. LibreOffice is free and handles .xlsx, .xls and .ods. CSV Desk opens all three read-only and shows the values.

How do I convert an Excel file to CSV on a Mac?

In CSV Desk, open the workbook, pick the sheet, and use File, then Export. To convert many at once, use File, then Convert Files. Each sheet with data becomes its own CSV. In Numbers, use File, then Export To, then CSV.

What happens to formulas when a workbook becomes CSV?

You keep each formula's calculated result, and lose the formula. A CSV holds plain values, with no formulas, formatting, colours or extra sheets. That is why the original workbook is worth keeping.

Can CSV Desk edit an XLSX file?

It won't change the workbook you opened. You can edit the values in the app, and saving writes a new CSV. Export can also write a new .xlsx, with values only and no formatting.