Excel File Formats Explained: XLSX, CSV, XLSB & More

What You'll Be Able to Do, and Why Excel File Formats Actually Matter

Has a client ever opened your Excel file and called you because everything looked wrong: columns collapsed, formatting gone, formulas broken? Or have you pulled a CSV export into Power Query only to find your dates arrived as text strings, right before a presentation? That's not bad luck. That's a file format decision made without thinking it through. This guide walks you through the excel file formats explained correctly, not as a glossary, but as a decision skill. By the end, you'll know which spreadsheet format to choose for any situation, how to save it without destroying your data, and what to check before you send anything. You'll need a copy of Microsoft Excel (any version from 2016 onward) or Google Sheets.

I've been doing data analysis professionally for twelve years. The format stuff stopped being academic for me around 2017, when I was consulting and managing quarterly logistics exports from fourteen regional offices, each one arriving in a slightly different layout, with different date formats, inconsistent column orders, and the occasional CSV that had silently mangled every number in the file. File format awareness became muscle memory fast.

---

Step 1: Match Your Excel File Format to What You're Actually Trying to Do

Most people save whatever Excel defaults to and never revisit it. I think that's the same pattern as using twelve percent of Excel's capability and then blaming the tool. Choosing your format deliberately isn't an advanced skill, it's a basic one, and skipping it creates technical debt that compounds every time someone else touches the file.

The Four Formats You'll Use 90% of the Time (XLSX, CSV, XLSB, XLSM)

XLSX is the default workbook format since Excel 2007, and it's the right choice for most reports, dashboards, and anything that needs to stay formatted. It's built on open XML, which means Google Sheets, Apple Numbers, and OpenOffice can all open it. The catch is version compatibility: an XLSX file built in Microsoft 365 with LAMBDA functions or dynamic arrays will break silently when opened in Excel 2019. Before you send it, ask who's receiving it and what version they're running. That question has saved me more than a few awkward follow-up calls.

CSV is the most portable format that exists, and also the most destructive to typed data. Here's the thing: a CSV will open in any tool, assuming you're not counting on it to remember your date formats, which it won't. No formulas survive. No formatting survives. Multiple sheets collapse into one. If you're sending data to a developer, a database, or any automated pipeline, CSV is usually what they want. If you're sending a report to a human who needs to read it, it's the wrong choice.

XLSB is the excel binary workbook format: same features as XLSX, but stored in binary rather than XML. For large files, this matters. A workbook that takes forty seconds to open as XLSX can open in under ten as XLSB. If you're working with datasets over 100,000 rows or complex models with dozens of pivot tables, XLSB is worth the switch. The tradeoff is that it's less universally compatible, and some third-party tools won't read it cleanly.

XLSM is the macro-enabled workbook format: it's XLSX with VBA support switched on. If your workbook runs macros, this is the only format that keeps them alive. Save an XLSM as XLSX and Excel will warn you the macros are being stripped. Most users click through that warning without reading it, and then spend an hour wondering why their buttons stopped working.

Quick-Decision Matrix: Which Format Fits Your Situation Right Now?

For a broader look at how these formats fit into the larger Excel ecosystem, the Excel Basics for Beginners, Advanced Edition guide covers the foundational concepts that make format decisions easier to understand in context.

---

Step 2: Save to the Right Excel Format Without Losing Data or Formatting

Once you know which format fits your situation, saving correctly is where the real errors happen. The path is File > Save As > Browse, then select your format from the "Save as type" dropdown. Sounds simple. In practice, each conversion has specific things it silently strips, and Excel's warnings are easy to dismiss without reading.

Saving as XLSM when your workbook contains macros: no issues. Saving an XLSM as XLSX: macros gone, no recovery. Saving XLSX as XLSB: fully supported, but verify that any add-ins or external data connections still resolve correctly afterward.

How to Save as CSV Without Losing Data (I Used to Mess This Up Too)

CSV saves only the active sheet as plain text. Every other sheet disappears. All formatting disappears. Every formula is replaced by its last calculated value. If your workbook has multiple sheets, you need to save each one as a separate CSV file. Excel won't do it automatically.

The part that catches people off guard is encoding. Save as CSV UTF-8 if your data contains any non-ASCII characters, like accented letters, currency symbols, or anything outside the standard English alphabet. The plain "CSV (Comma delimited)" option can corrupt those characters silently. And if you're distributing files to European users, be aware that some regional Excel installs default to semicolons as the delimiter instead of commas, which means your "CSV" may not parse correctly on their end without adjustment.

One more thing worth knowing: CSV imports are one of the primary ways leading apostrophes enter a workbook invisibly. Numbers stored as text, dates arriving as strings, these aren't random glitches. They're the direct cost of not understanding what CSV encoding does to typed data. TRIM handles extra spaces; CLEAN handles non-printable characters. You'll use both if you import CSVs regularly. If you're just getting started with how data lives inside Excel cells, the guide on entering data in Excel correctly covers the cell-level behavior that makes this click.

---

Step 3: Check Cross-Platform Compatibility Before You Hit Send

Once you've saved in the right format, there's one more check worth making, especially in 2026, when more teams are mixing Microsoft 365 with Google Sheets and other tools than ever before.

XLSX opens in Google Sheets with reasonable fidelity, though some advanced formatting and newer Microsoft 365 features won't transfer cleanly. Dynamic array functions may appear as static values. Complex conditional formatting sometimes drops. For most standard reports, it's fine.

The difference between XLS and XLSX matters here too. XLS is the legacy format from Excel 97 to 2003. If someone sends you an XLS file in 2026, it's usually from an old automated system that hasn't been updated. You can open it, but don't perpetuate the format. Save it forward to XLSX.

OpenDocument Spreadsheet (.ods) is the format used by LibreOffice and some other open-source tools. Excel can open and save ODS files, but the feature parity is incomplete. Avoid it unless the recipient specifically needs it.

CSV remains the one format that works everywhere, every tool, every platform, every operating system, but at the cost of everything that makes a spreadsheet a spreadsheet. If cross-platform compatibility is your goal and your data is purely tabular with no formulas or formatting that matters, CSV is the right answer. Otherwise, XLSX and a quick confirmation of the recipient's software version is the more reliable path.

If you're still getting comfortable with how workbooks and files relate to each other in the first place, the Excel for Beginners complete starter guide builds that foundation cleanly.

---

Common Mistakes When Choosing Excel File Formats and How to Avoid Them

Opening an XLSM file from an unknown sender without checking the macros first. XLSM files can execute VBA code the moment you enable macros, code you haven't read and can't easily audit. If you didn't request the file, don't enable macros without verifying the source. This is the security angle most format guides skip entirely, but it's a real exposure in professional environments.

Defaulting to XLSX when your dataset is large enough to justify XLSB. If your workbook has hundreds of thousands of rows, complex pivot tables, or takes more than fifteen seconds to save, try XLSB. The performance difference is real and immediate. Most analysts never make this switch because they don't know the option exists.

Assuming CSV preserves everything. It doesn't preserve formatting, formulas, or additional sheets. Full stop. I watched an analyst spend two hours trying to figure out why her dashboard was broken: the export file had dates stored as text strings, which is exactly what CSV does when the source data isn't typed correctly. The file format wasn't the root cause, but it was where the damage became irreversible. Data should never have to be touched more than once by human hands. When a file format forces you to clean data manually on the receiving end, that's a design failure, not a workflow step.

---