To open an XLSX file: Double-click it — opens in Microsoft Excel (Windows) or Numbers (Mac). Free alternatives: Upload to Google Sheets online, or download free LibreOffice Calc. On phone: use Excel app or Google Sheets (both free).
How to Open XLSX File
Complete guide to open Microsoft Excel spreadsheets on Windows, Mac, Android, iPhone & online — Free methods included
Quick Answer: How to Open XLSX File
- Windows: Double-click file → opens in Microsoft Excel
- Mac: Double-click → opens in Numbers (free) or Excel
- Android/iPhone: Tap file → opens in Excel app or Google Sheets (free)
- Online (Free): Go to sheets.google.com → File → Open → Upload XLSX
No Excel? Use Google Sheets (free, online) or LibreOffice Calc (free download)
Quick Facts About XLSX Files
Full NameOffice Open XML Spreadsheet
DeveloperMicrosoft Corporation
Released2007 (with Office 2007)
MIME Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Max Rows1,048,576 rows
Max Columns16,384 columns (XFD)
Free Online XLSX Viewer - Open XLSX File Instantly
Drop your THIS FORMAT file below to view the spreadsheet data. 100% private — your file never leaves your device.
Drop your XLSX file here
or click to select a file
100% Private: Your XLSX file is processed entirely in your browser using SheetJS. Nothing is uploaded to any server.
What is an XLSX File?
An XLSX file is a spreadsheet file created by Microsoft Excel. The XLSX format became the default for Excel starting with Office 2007, replacing the older .XLS format.
WORKBOOKS stands for Office Open XML Spreadsheet. Like DOCX, THE SPREADSHEET files are ZIP archives containing XML files. This makes them smaller and more reliable than the old XLS format.
What Can XLSX Files Contain?
- Data in cells — text, numbers, dates, times
- Formulas — calculations like SUM, VLOOKUP, IF
- Charts and graphs — bar, line, pie, scatter plots
- Formatting — colors, fonts, borders, conditional formatting
- Multiple sheets — tabs within one file
- Pivot tables — data analysis and summaries
- Images and shapes — embedded graphics
- Data validation — dropdown lists, input rules
- Macros — in .XLSM files (macro-enabled)
THIS FORMAT vs XLS: Key Differences
| Feature | XLS (1997-2003) | XLSX (2007+) |
|---|---|---|
| Maximum Rows | 65,536 | 1,048,576 |
| Maximum Columns | 256 (IV) | 16,384 (XFD) |
| File Size | Larger | ~50% smaller |
| Format | Binary | XML (open standard) |
| Security | Can hide macros | Macros require .XLSM |
How to Open XLSX File on Windows
Method 1: Microsoft Excel (Best)
- Double-click the THEM file
- Opens automatically in Microsoft Excel
- Full support for formulas, charts, macros
Method 2: LibreOffice Calc (Free)
- Download LibreOffice
- Install LibreOffice Calc
- Right-click XLSX → Open with → LibreOffice Calc
Compatibility: Excellent for most spreadsheets. Complex formulas may need adjustment.
Method 3: Google Sheets (Free Online)
- Go to sheets.google.com
- Click folder icon → Upload → Select WORKBOOKS file
- Edit online, download as THE SPREADSHEET or CSV
Method 4: Excel Online (Free)
- Go to office.com
- Sign in with Microsoft account (free)
- Upload XLSX file to OneDrive
- Click to open in Excel Online
How to Open XLSX File on Mac
Method 1: Apple Numbers (Free)
- Double-click THIS FORMAT file
- Opens in Numbers automatically
- Export back: File → Export To → Excel
Method 2: Microsoft Excel for Mac
- Install from Mac App Store or Microsoft 365
- Double-click EXCEL FILES to open
- Best formula compatibility
Method 3: LibreOffice Calc
- Download from libreoffice.org
- File → Open → Select XLSX
How to Open XLSX File on Android & iPhone
Android
- Install Microsoft Excel (free) or Google Sheets
- Tap SPREADSHEETS file in Files app
- Select Excel or Sheets to open
iPhone/iPad
- Tap IT file in Files, Mail, or Messages
- Opens in Numbers preview
- Tap "Copy to Numbers" or use Excel app for editing
Best Software for XLSX Files
| Program | Platform | Price | Best For |
|---|---|---|---|
| Microsoft Excel | All platforms | $6.99/mo | Full compatibility, advanced features |
| Google Sheets | Web, Mobile | Free | Collaboration, basic spreadsheets |
| LibreOffice Calc | Win, Mac, Linux | Free | Offline, full-featured |
| Apple Numbers | Mac, iOS | Free | Mac users, nice templates |
| WPS Spreadsheets | All platforms | Free | Excel alternative |
Common XLSX Formulas
XLSX files support hundreds of formulas. Here are the most common:
| Formula | Purpose | Example |
|---|---|---|
=SUM() | Add numbers | =SUM(A1:A10) |
=AVERAGE() | Calculate average | =AVERAGE(B1:B20) |
=VLOOKUP() | Look up values | =VLOOKUP(A1,Sheet2!A:B,2,FALSE) |
=IF() | Conditional logic | =IF(A1>10,"High","Low") |
=COUNT() | Count numbers | =COUNT(A:A) |
=CONCATENATE() | Join text | =CONCATENATE(A1," ",B1) |
Formulas are preserved when opening THEM in Google Sheets or LibreOffice, though some advanced functions may need adjustment.
Convert XLSX Files
WORKBOOKS to CSV
- Excel: File → Save As → CSV
- Google Sheets: File → Download → CSV
- Online: Zamzar.com
XLSX to PDF
- Excel: File → Save As → PDF
- Google Sheets: File → Download → PDF
CSV to THE SPREADSHEET
- Open CSV in Excel → File → Save As → THIS FORMAT
XLSX File Will Not Open - Common Problems
❌ "File is corrupted" Error
- Try opening in Google Sheets
- Excel: File → Open → Browse → Open and Repair
- Rename .xlsx to .zip → extract → check xl/worksheets/
⚠️ Formulas Show #NAME? or #REF!
- Formula may use Excel-specific functions
- Open in Microsoft Excel for full compatibility
- Check if referenced cells/sheets exist
💡 File Too Large to Open
- XLSX can have 1M+ rows - may be slow
- Try Google Sheets (handles large files well)
- Split file into smaller worksheets
Common XLSX Problems & Solutions
Having trouble with Excel files? These guides solve the most common issues:
Best Programs to Open XLSX Files (2026 Comparison)
While Microsoft Excel is the standard, many excellent alternatives can open EXCEL FILES files:
| Program | Platform | Price | Formula Support | Best For |
|---|---|---|---|---|
| Microsoft Excel | Windows, Mac, Web, Mobile | $6.99/mo or $159.99 | ★★★★★ Full | Professional work, complex spreadsheets |
| Google Sheets | Web, Mobile (all platforms) | Free | ★★★★☆ Excellent | Collaboration, cloud access |
| LibreOffice Calc | Windows, Mac, Linux | Free | ★★★★☆ Excellent | Offline work, Excel alternative |
| Apple Numbers | Mac, iOS, iCloud | Free | ★★★☆☆ Good | Mac users, visual spreadsheets |
| WPS Office | All platforms | Free (ads) | ★★★★☆ Very Good | Excel clone, familiar interface |
| OnlyOffice | Windows, Mac, Linux, Web | Free | ★★★★☆ Very Good | Self-hosted, privacy-focused |
| Zoho Sheet | Web, Mobile | Free | ★★★★☆ Very Good | Business users, Zoho ecosystem |
💡 Our Recommendation: Use Google Sheets for free, cloud-based editing with real-time collaboration. For offline work or maximum Excel compatibility, LibreOffice Calc is excellent and completely free.
Essential XLSX Tips & Keyboard Shortcuts
Work faster with these Excel essentials:
Windows Excel Shortcuts
Ctrl + S | Save file |
Ctrl + C / V | Copy / Paste |
Ctrl + Z / Y | Undo / Redo |
Ctrl + F | Find |
Ctrl + H | Find & Replace |
Ctrl + Home | Go to cell A1 |
Ctrl + End | Go to last used cell |
Ctrl + Arrow | Jump to edge of data |
Ctrl + Shift + L | Toggle filters |
F2 | Edit cell |
F4 | Repeat last action / Toggle absolute reference |
Alt + = | AutoSum selected cells |
Mac Excel Shortcuts
Replace Ctrl with Cmd for most shortcuts. Notable differences:
Cmd + T— Create tableCmd + Shift + T— Toggle total rowFn + F4— Toggle absolute reference
Is It Safe to Open XLSX Files?
Standard SPREADSHEETS files are safe, but there are security considerations:
✓ XLSX Safety Features
- IT cannot contain macros — only XLSM can
- XML-based format is transparent and auditable
- Modern Excel warns before running external content
- Protected View opens suspicious files in read-only mode
⚠️ Potential Risks
- XLSM files: Macro-enabled files CAN run code — only open from trusted sources
- External links: Formulas linking to external files may load remote content
- Fake extensions: Malware may disguise as .xlsx but be executable — check file properties
- DDE attacks: Older Excel versions vulnerable to Dynamic Data Exchange exploits
THEM Security Best Practices
- Check file extension: Right-click → Properties — confirm .xlsx not .xlsm or .exe
- Keep Office updated: Security patches protect against known vulnerabilities
- Don't enable macros: If Excel asks to "Enable Content" — verify the source first
- Use Protected View: Don't disable it — opens untrusted files safely
- Scan attachments: Email attachments are common malware vectors
XLSX Won't Open? Complete Troubleshooting Guide
Problem 1: "The file format or extension is not valid"
Causes:
- File is corrupted during download or transfer
- File has wrong extension (might be XLS or CSV)
- Excel version is too old
Solutions:
- Try "Open and Repair": File → Open → Select file → Click dropdown arrow → "Open and Repair"
- Rename .xlsx to .zip and extract — open xl/worksheets/sheet1.xml to recover data
- Upload to Google Sheets — sometimes opens corrupted files
- Re-download from source
Problem 2: File Opens But Shows Garbled Characters
Cause: Encoding mismatch, especially with CSV data imported incorrectly.
Solutions:
- Data → From Text/CSV → select UTF-8 encoding
- If Japanese/Chinese: ensure language pack is installed
- Copy-paste data into new workbook with correct encoding
Problem 3: Formulas Show Errors (#REF!, #NAME?, #VALUE!)
#REF! | Referenced cell was deleted — check formula ranges |
#NAME? | Formula name not recognized — typo or unsupported function |
#VALUE! | Wrong data type — text where number expected |
#DIV/0! | Division by zero — add IF check for zero |
#N/A | VLOOKUP/MATCH can't find value — check lookup data |
Problem 4: File Is Too Large / Opens Slowly
Solutions:
- Delete unused rows/columns: Ctrl+End shows actual data range
- Remove conditional formatting on large ranges
- Convert formulas to values: Copy → Paste Special → Values
- Save as XLSB (binary format) — faster and smaller
- Split into multiple files or sheets
Problem 5: Can't Edit Protected Spreadsheet
If you forgot the password:
- Sheet protection (not file): Various online tools can remove it
- File encryption: Cannot be bypassed without password
- Check with the file creator for the password
Complete XLSX Resource Center
Everything you need to work with Excel files:
📊 Spreadsheet Software
- Microsoft Excel (Paid)
- Google Sheets (Free)
- LibreOffice Calc (Free)
- Apple Numbers (Free for Mac)
🔄 XLSX Converters
🔧 Excel Tools
XLSX Technical Specifications
| File Extension | .xlsx |
| MIME Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| Developer | Microsoft Corporation |
| Standard | ECMA-376 / ISO/IEC 29500 |
| Max Rows | 1,048,576 |
| Max Columns | 16,384 (A to XFD) |
| Max Cell Characters | 32,767 |
| Format | ZIP container with XML |
Frequently Asked Questions
What is an WORKBOOKS file? +
THE SPREADSHEET is Microsoft Excel's default spreadsheet format since 2007. It uses the Office Open XML standard to store data, formulas, charts, formatting, and multiple worksheets in a compressed ZIP archive containing XML files. XLSX files can contain up to 1,048,576 rows and 16,384 columns per sheet.
How do I open THIS FORMAT without Excel? +
Several free alternatives can open EXCEL FILES files: (1) Google Sheets at sheets.google.com — free, online, excellent compatibility, (2) LibreOffice Calc — free download for Windows/Mac/Linux, (3) Apple Numbers — free on Mac/iOS, (4) WPS Office — free with ads. All can open, edit, and save XLSX files with good formula support.
What's the difference between XLS and SPREADSHEETS? +
XLS is Excel's old binary format (1997-2003) with a 65,536 row limit and larger file sizes. IT is the modern XML-based format (2007+) supporting 1 million rows, 50% smaller files, and better security since macros require the separate XLSM format. Always use XLSX for new files.
Can I open THEM on my phone? +
Yes! On iPhone/iPad: Numbers (built-in), Microsoft Excel app (free), or Google Sheets. On Android: Microsoft Excel app (free), Google Sheets, or WPS Office. All can view and edit WORKBOOKS files. For large files, Google Sheets handles them best on mobile.
How do I convert XLSX to CSV? +
In Excel: File → Save As → select "CSV (Comma delimited)". In Google Sheets: File → Download → Comma Separated Values (.csv). Note: CSV only exports the active sheet, loses formatting, charts, and formulas (converts to values). For multiple sheets, export each separately.
Why won't formulas work when I open THE SPREADSHEET in Google Sheets? +
Most Excel formulas work in Google Sheets, but some are incompatible: XLOOKUP (use VLOOKUP or INDEX/MATCH), certain array formulas, and VBA macros don't work at all. Google Sheets shows errors for unsupported functions. For full compatibility, use Microsoft Excel or LibreOffice Calc.
What's the difference between THIS FORMAT and XLSM? +
XLSX is a standard spreadsheet that cannot contain VBA macros. XLSM is macro-enabled and can run Visual Basic code when opened. For security, always verify XLSM files before enabling macros, as they can execute malicious code. If you don't need macros, use EXCEL FILES.
How do I recover a corrupted XLSX file? +
Try these methods: (1) Excel's Open and Repair: File → Open → select file → click dropdown arrow → "Open and Repair", (2) Rename .xlsx to .zip, extract, and open xl/worksheets/sheet1.xml in a text editor, (3) Upload to Google Sheets which sometimes opens corrupted files, (4) Use recovery software like Stellar Repair for Excel.
Can I password protect an SPREADSHEETS file? +
Yes. In Excel: File → Info → Protect Workbook → Encrypt with Password. This prevents opening without the password. You can also protect individual sheets (Review → Protect Sheet) to prevent editing while allowing viewing. Note: Sheet protection is easily bypassed; file encryption is secure.
Why is my XLSX file so large? +
Common causes: (1) Unused rows/columns with formatting — delete them, (2) Embedded images — compress or remove them, (3) Conditional formatting on large ranges — simplify rules, (4) Excessive formulas — convert to values where possible. Saving as XLSB (binary) can reduce size by 50-75%.