How to Open an XLSX File Without Excel
An .xlsx file is an Excel workbook, but you do not need Excel, or a Microsoft 365 subscription, to open one. The format is an open standard (Office Open XML), so plenty of free programs read it. This guide covers six of them, what each is good at, and what to do when a workbook refuses to open.
What is inside an XLSX file #
An .xlsx file is a ZIP archive of XML files. Each worksheet is stored as its own file (xl/worksheets/sheet1.xml, sheet2.xml, and so on), next to shared strings, styles and the workbook structure. You can check this yourself: copy the file, rename the copy to .zip, and open it, or run unzip -l report.xlsx in a terminal.
That is why a text editor shows gibberish, and why any program that understands the format can read it without Excel. The older .xls format (Excel 97–2003) is a different, binary format, but most of the tools below open it too.
Option 1: open it in your browser, no account needed #
The online Excel viewer opens a workbook directly in the browser tab. The file is read on your device with SheetJS and is not uploaded anywhere, so it also works for spreadsheets you would rather not put in a cloud drive.
- Open the Excel viewer and drop your file on it, or click Browse files.
- Switch between worksheets with the sheet tabs.
- Edit a cell inline if you need to fix a value.
- Click Download .xlsx to save the workbook with your edits, or export the current sheet as CSV.
It opens .xlsx, .xlsm, .xlsb and .xls workbooks, plus OpenDocument .ods and Apple .numbers files, up to 50 MB. Password-protected workbooks saved by current versions of Excel open after you type the password; the password stays in your browser. Each sheet shows up to 100,000 rows and 200 columns, which covers most everyday files.
Two limits to know: the viewer shows the stored values, and when you save, formulas and cell formatting are not kept. Use it to read, check and lightly fix data, not to rebuild a formatted financial model.
If all you need is the data in a simpler format, the Excel to CSV converter lets you pick one worksheet from an .xlsx or .xls file and download it as a CSV.
Option 2: Google Sheets #
If you have a Google account, upload the file to Google Drive and double-click it. Drive opens .xlsx files in Google Sheets and lets you edit them in the original format, or you can choose File > Save as Google Sheets to convert it. Sharing and collaboration then work like any other Sheet.
Good for: editing with other people, keeping formulas. Watch out for: very large workbooks (Sheets has a cell limit per spreadsheet) and confidential data you are not allowed to upload.
Option 3: Excel for the web #
Microsoft offers a free browser version of Excel. Sign in at office.com with a free Microsoft account, upload the file to OneDrive and open it. It is the closest match to desktop Excel, so formulas, charts and formatting look as the author intended, though some advanced features (some macros and add-ins) are not available.
Good for: files that must look exactly right. Watch out for: the file has to live in OneDrive.
Option 4: LibreOffice Calc #
LibreOffice is a free, open-source office suite for Windows, macOS and Linux. Its spreadsheet program, Calc, opens .xlsx and .xls files offline and saves back to .xlsx. Complex formatting, pivot tables and charts sometimes shift slightly, but data and formulas come through well.
Good for: a full offline spreadsheet program with no subscription.
Option 5: Apple Numbers #
On a Mac, iPhone or iPad, Apple Numbers is free and opens Excel files: choose File > Open, or just double-click the file if Numbers is your default app. Numbers converts the workbook to its own format when it opens it; use File > Export To > Excel to send an .xlsx back.
Option 6: Python, for scripts and automation #
If you want the data rather than a grid on screen, pandas reads Excel files with the openpyxl engine:
pip install pandas openpyxl
import pandas as pd
# Every sheet, as a dict of {sheet name: DataFrame}
sheets = pd.read_excel("report.xlsx", sheet_name=None)
for name, df in sheets.items():
print(name, df.shape)
# One sheet, saved as CSV
pd.read_excel("report.xlsx", sheet_name="Sales").to_csv("sales.csv", index=False)
Pandas reads the values, not the formatting, which is usually what you want for analysis.
Which option should you use? #
| You want to… | Use |
|---|---|
| Look at a file right now, without signing in | Excel viewer |
| Get one sheet as a CSV | Excel to CSV converter |
| Edit together with other people | Google Sheets |
| Keep formatting and formulas exactly as built | Excel for the web |
| Work offline in a full spreadsheet program | LibreOffice Calc or Apple Numbers |
| Process many files in a script | Python and pandas |
Why an XLSX file will not open #
When a workbook fails in every program, the cause is usually one of these:
- It is not really an Excel file. Some websites export HTML or CSV with an
.xlsxor.xlsname. Open it in a text editor: if you see<html>or comma-separated text, rename it to.htmlor.csv. - The download is incomplete. A ZIP archive with a missing end cannot be read. Download the file again rather than trying to repair it.
- It is password-protected. Modern Excel encryption can be opened by the Excel viewer and by LibreOffice with the password. Very old encryption schemes may need desktop Excel.
- It has a sensitivity label. Files protected by Microsoft Information Rights Management only open in Excel signed in to an account that has access. Ask the sender for an unprotected copy.
- It is too big for the program. Excel stops at 1,048,576 rows per sheet. For bigger data, ask for a CSV instead and split the large CSV into smaller files, or open it in the CSV editor.
FAQ #
Can I open an XLSX file without Microsoft Office? #
Yes. The Excel viewer, Google Sheets, Excel for the web, LibreOffice Calc and Apple Numbers all open .xlsx files for free.
Is there a way to open an Excel file without uploading it? #
Yes. The Excel viewer and the Excel to CSV converter read the file inside your browser, and LibreOffice, Numbers and pandas work entirely offline.
How do I open an XLSX file on a phone? #
Google Sheets and Microsoft Excel both have free mobile apps that open .xlsx files, and Apple Numbers is free on iPhone and iPad. The Excel viewer also runs in a mobile browser.
What is the difference between XLSX and XLS? #
XLSX is the ZIP-and-XML format Excel has used since 2007. XLS is the older binary format. Both open in the tools above; save new files as .xlsx.
How do I convert an XLSX file to CSV? #
Use the Excel to CSV converter in your browser, File > Download > CSV in Google Sheets, File > Save As > CSV in Excel or LibreOffice, or the pandas snippet above. CSV holds one sheet per file, so convert each sheet separately.
Try the tools from this post
Free and private: your files stay in your browser.
- Excel Viewer and EditorOpen multi-sheet Excel spreadsheets (.xlsx, .xlsm, .xls, .ods), switch between tabs, and edit cell values directly in your browser.
- Excel to CSV ConverterConvert XLSX or XLS workbook sheets to CSV locally in your browser.
- Online Excel EditorEdit Excel spreadsheets in your browser, or start a blank sheet, and download the workbook as .xlsx.