Someone sends you a spreadsheet. It is an XLSX file. You do not have Microsoft Office installed, and you do not want to pay for a subscription just to look at a single file. Or maybe you are on a machine where you cannot install software. Or you are on Linux, where Excel does not run natively.
The good news: XLSX is an open format, and many tools can read it. The bad news: they are not all equal. Some handle formulas well but struggle with large files. Others are great for viewing but cannot edit. This guide walks through the real options, with an honest look at what each one does well and where it falls short.
What is an XLSX file, exactly?
Before comparing tools, it helps to understand what you are working with. An XLSX file is actually a ZIP archive containing a collection of XML files. You can verify this yourself:
XLSX is formally known as Office Open XML (OOXML). It has been an international standard (ISO/IEC 29500) since 2008. This is why multiple applications can read it — the format is documented and publicly available, unlike the older proprietary XLS format.
That said, "standard" does not mean "perfectly interoperable." Excel uses many extensions and undocumented behaviors that other applications may not replicate exactly. Complex macros, pivot tables, and advanced conditional formatting are the most common sources of incompatibility.
Option 1: LibreOffice Calc
LibreOffice Calc is the closest free equivalent to Excel. It is a full-featured desktop spreadsheet application that runs on Windows, macOS, and Linux.
How to open XLSX in LibreOffice:
- Download and install LibreOffice from
libreoffice.org(free, open-source) - Double-click your XLSX file, or open LibreOffice Calc and use File > Open
- The file opens in the Calc interface, which looks and works similarly to Excel
What works well:
- Most formulas work identically (SUM, VLOOKUP, IF, INDEX/MATCH, etc.)
- Cell formatting, conditional formatting, and charts transfer reliably
- Multiple sheet tabs are preserved
- Data validation and drop-down lists work
- You can edit and save back to XLSX format
What does not work well:
- VBA macros do not run (LibreOffice uses its own macro language)
- Complex pivot tables may lose some settings or formatting
- Some newer Excel functions (XLOOKUP, LAMBDA, dynamic arrays) may not be supported in older LibreOffice versions
- Font rendering differs slightly, which can shift column widths and page breaks
- Same 1,048,576 row limit as Excel
Best for: users who need a full Excel replacement for everyday spreadsheet work, do not rely on VBA macros, and want a free desktop application.
Option 2: Google Sheets
Google Sheets can open XLSX files directly in your browser. Upload the file to Google Drive, and it converts automatically.
How to open XLSX in Google Sheets:
- Go to
sheets.google.com(requires a free Google account) - Click the folder icon or drag the XLSX file onto the page
- The file opens in Google Sheets with most formatting preserved
What works well:
- Most standard formulas work
- Basic formatting transfers cleanly
- Multiple people can view or edit simultaneously
- No software to install
- Auto-saves to Google Drive
What does not work well:
- 10 million cell limit — large XLSX files may not import
- File upload limit of about 100 MB
- Complex charts and formatting may change or break
- VBA macros are stripped entirely
- Requires internet connection and a Google account
- Privacy concern: your file is uploaded to Google servers
Best for: quick viewing of small-to-medium XLSX files when you do not want to install anything, and you are comfortable with your data on Google's servers.
Option 3: Viztab
Viztab opens XLSX files directly in your browser without uploading them anywhere. It is designed for speed, especially with large files.
Drop your XLSX file
Drag and drop the file onto the app. It parses locally in your browser — nothing is uploaded.
View, sort, filter, export
Full spreadsheet interface with 370+ formulas. Sort and filter any column. Export as CSV or XLSX.
What works well:
- Opens large XLSX files that Google Sheets and LibreOffice struggle with
- No file size limit beyond your machine's memory
- Data never leaves your computer — processed entirely in the browser
- Fast opening and smooth scrolling, even with hundreds of thousands of rows
- 370+ formula functions supported
- Works on any operating system with a modern browser
What does not work well:
- Does not support VBA macros (no browser-based tool does)
- Complex chart types are not rendered (data is preserved)
- Advanced pivot tables are not interactive (source data is accessible)
Best for: opening large XLSX files, privacy-sensitive data that should not be uploaded to the cloud, and quick exploration of spreadsheet data without installing software.
Option 4: Apple Numbers
If you are on a Mac, iPad, or iPhone, Apple Numbers comes pre-installed and opens XLSX files with a double-click.
What works well:
- Pre-installed on all Apple devices — no download needed
- Clean, intuitive interface for basic spreadsheet tasks
- Good handling of basic formatting and formulas
What does not work well:
- Apple-only — not available on Windows or Linux
- Many Excel formulas are not supported or behave differently
- Row limit of 1,000,000 (slightly less than Excel)
- Poor handling of complex XLSX files with multiple pivot tables or advanced formatting
- Saving back to XLSX can introduce formatting changes
Best for: Mac users who need to quickly view a simple XLSX file and do not need full Excel compatibility.
Option 5: Online XLSX viewers
Several websites offer XLSX viewing without any software install. These include Microsoft's free Office for the Web (at office.com), Zoho Sheet, and various "XLSX viewer" sites.
Microsoft Office for the Web is the most compatible option — it is Excel running in the browser, made by Microsoft. It handles formatting, formulas, and even some chart types correctly. However, it requires a Microsoft account and uploads your file to OneDrive. The free version also has limited editing capabilities compared to desktop Excel.
Zoho Sheet is similar to Google Sheets but from a different company. It handles XLSX well for small-to-medium files. Like Google Sheets, it uploads your data to their servers.
Generic XLSX viewer sites should be used with caution. Many are ad-heavy, some have unclear privacy policies, and most have strict file size limits (often 10-50 MB). If your file contains any sensitive data, avoid these entirely.
Comparison at a glance
| Tool | Cost | Max File Size | Data Privacy | Install Required |
|---|---|---|---|---|
| LibreOffice Calc | Free | ~500 MB | Local only | Yes |
| Google Sheets | Free | ~100 MB | Uploaded to Google | No |
| Viztab | Free / Pro | Multi-GB | Local only | No |
| Apple Numbers | Free (Mac only) | ~200 MB | Local only | Pre-installed |
| Office for the Web | Free (limited) | ~100 MB | Uploaded to OneDrive | No |
Which option should you choose?
The right tool depends on what you need to do with the file:
- Just need to view the data quickly? Viztab or Google Sheets. No install needed for either. Viztab is better for privacy and large files.
- Need to edit and save back to XLSX? LibreOffice Calc or Office for the Web. LibreOffice is better for offline work and complex files.
- Working with a large XLSX (100 MB+)? Viztab. Other browser-based tools will fail at this size, and even LibreOffice will be slow.
- Sensitive data that cannot go to the cloud? LibreOffice or Viztab. Both process files locally with no data upload.
- Need to collaborate with others? Google Sheets or Office for the Web. These are the only options with real-time multi-user editing.
Preguntas frecuentes
Yes. Several free tools can open XLSX files: LibreOffice Calc (free desktop app for Windows, Mac, and Linux), Google Sheets (free in any browser with a Google account), Viztab (free in browser, no account needed), and Apple Numbers (free on Mac and iOS). Each handles XLSX files with varying degrees of formula and formatting compatibility.
It depends on your needs. LibreOffice Calc is the most feature-complete free Excel alternative and works offline. Google Sheets is best for collaboration but requires a Google account and internet connection. Viztab is best for large XLSX files and privacy-sensitive data since nothing is uploaded. Apple Numbers is simplest for Mac users but has limited formula compatibility.
LibreOffice Calc preserves most XLSX formatting including conditional formatting, charts, and pivot tables, though complex macros (VBA) will not work. Google Sheets handles basic formatting well but may change some fonts, chart styles, and advanced conditional formatting. Viztab preserves data, formulas, and basic formatting but focuses on data analysis rather than complex visual formatting.
When you open an XLSX file in Google Sheets, the file is uploaded to Google servers. This may not be appropriate for confidential or regulated data. Viztab processes XLSX files entirely in your browser — the file never leaves your computer. LibreOffice and Apple Numbers also work offline with no data upload. Always check the privacy policy of any online tool before uploading sensitive files.
Open XLSX files instantly, privately
Viztab reads your XLSX in the browser. No upload, no account, no Office subscription.
Abrir Viztab