Excel extensions are the three or four letters after the dot in a filename that tell your computer what kind of spreadsheet it is

When you save a spreadsheet in Excel or a similar program, the extension — the part after the period — determines what format the file uses. The most common extension you'll see is .xlsx, which is the standard format for modern Excel files. Other extensions like .xls, .csv, and .xlsm exist because they store data differently or have different capabilities. Understanding which extension you're working with matters because it affects what features you can use, whether other people can open it, and how much space it takes up on your computer.

The extension is not just a label — it's instructions to your computer about how to read the file. If you rename a .xlsx file to .txt, your computer will try to open it as text and show you gibberish. The file itself hasn't changed, but the extension tells your operating system which program should open it and how to interpret what's inside.

Key Takeaways

  • .xlsx is the standard Excel format used by most modern spreadsheets and works on Windows, Mac, and most other programs.
  • .xls is the older Excel format that some older computers or programs still use, but it has fewer features than .xlsx.
  • .csv is a plain-text format that removes all formatting and formulas, making it useful for sharing data between different programs.
  • .xlsm is identical to .xlsx except it can contain macros, which are automated tasks you record or write yourself.
  • Changing an extension by renaming the file does not actually convert it — you must use your program's "Save As" feature to truly change formats.

.xlsx: The standard Excel format

.xlsx is what you get when you open Excel and create a new spreadsheet. It stands for "Excel Spreadsheet" and is the default format in Excel 2007 and all versions since. This format can hold formulas, charts, multiple sheets, cell formatting (colors, bold text, borders), and images. Most other programs — Google Sheets, LibreOffice Calc, Numbers on Mac — can open and save .xlsx files, which makes it the safest choice when you need to share a spreadsheet with someone else.

The .xlsx format compresses your data, so files are smaller than they would be in older formats. A spreadsheet with 10,000 rows of data might be 500 KB as .xlsx but 2 MB as .xls. This matters if you're emailing files or storing them on a limited device.

.xls: The older Excel format

.xls is the format Excel used before 2007. If you open a very old spreadsheet or receive one from someone using an older version of Excel, it will likely be .xls. Modern versions of Excel can still open and work with .xls files without any problem. However, .xls has limits that .xlsx does not — it can hold fewer rows (about 65,000 instead of over 1 million), fewer columns, and some newer features won't work.

You might encounter .xls files from older businesses or government databases that have not been updated. If you need to work with one, you can open it in modern Excel and save it as .xlsx to get access to more features and smaller file size. There is no reason to keep using .xls unless someone specifically requires it.

.csv: The format for sharing data between programs

.csv stands for "comma-separated values." It is a plain-text format that stores only the raw data — no formulas, no colors, no charts, no multiple sheets. Each row is a line of text, and each column is separated by a comma. When you open a .csv file in Excel, it looks like a normal spreadsheet, but if you open it in a text editor like Notepad, you see the commas.

Use .csv when you need to move data between different programs or when someone asks for "data export." For example, if you read your bank transactions, they often come as .csv. If you have a customer list in Excel and need to import it into accounting software, you save it as .csv first. The downside is that .csv strips away all formatting — if your spreadsheet has colored cells or bold headers, those disappear when you save as .csv. Formulas also convert to their results (the numbers they calculate), not the formulas themselves.

Opening a .csv file in Excel is straightforward, but saving one requires using "Save As" and choosing CSV from the format menu. If you just click Save on a .csv file that's open in Excel, it will ask you to confirm that you want to keep the CSV format and lose any formatting.

.xlsm: Excel format with macros

.xlsm is identical to .xlsx except it can contain macros — small programs you record or write that automate repetitive tasks. For example, you might record a macro that formats a column, sorts it, and highlights cells above a certain value. The next time you need to do that, you run the macro instead of doing it by hand.

Most people never need .xlsm. If you receive a .xlsm file and open it in Excel, you might see a security warning asking whether you trust the macros inside. This is because macros can theoretically be used to spread malware, though in practice most .xlsm files are safe. If you don't need the macros, you can save the file as .xlsx and lose nothing except the automated tasks.

Other extensions you might see

.xlsb is a binary format that Excel uses for very large files — it takes up less space and opens faster than .xlsx, but fewer programs can open it. You will rarely encounter this unless you work with massive datasets.

.xltx and .xltm are template formats. If you create a spreadsheet you want to reuse as a starting point (like a monthly budget template or an invoice), you save it as .xltx. When someone opens it, Excel creates a copy so they don't accidentally overwrite your original template. .xltm is the same thing but with macros.

.ods is the format used by LibreOffice Calc and other open-source spreadsheet programs. Excel can open .ods files, and you can save as .ods from Excel if you need to share with someone using LibreOffice.

How to actually change a file's format

straightforward renaming a file from .xlsx to .csv does not convert it. Your computer will try to open it as CSV and fail or show garbage. To truly change formats, you must use your program's "Save As" feature. In Excel, go to File > Save As, choose the location and filename, then click the "Save as type" dropdown and select the format you want.

When you save as .csv from Excel, you lose formatting and formulas. When you save as .xlsx from .csv, you keep the data but gain the ability to add formatting and formulas. Some conversions are lossy (you lose information) and some are not — saving .xlsx as .xls loses some features, but saving .xls as .xlsx does not.

If you are unsure what format to use, .xlsx is the right default. It works everywhere, preserves everything you might want to keep, and is smaller than older formats.

Frequently Asked Questions

Can I open a .xlsx file in Google Sheets or LibreOffice?

Yes. Google Sheets can open .xlsx files directly — you can upload one to Google Drive and edit it in your browser. LibreOffice Calc also opens .xlsx without any conversion needed. Both programs can save back to .xlsx so the file stays compatible with Excel.

What happens if I email a .xlsm file to someone?

They can open it, but they will see a security warning asking if they trust the macros. If they click "Enable," the macros run. If they click "Disable," the spreadsheet opens but the automated tasks won't work. The file itself is not damaged either way.

If I save an Excel file as .csv, can I convert it back to .xlsx without losing data?

The data stays intact, but formatting (colors, bold text, borders) and formulas are gone. You can open the .csv in Excel and save it as .xlsx, and the data will be there, but you will need to reapply any formatting you had before.

Why does my file say .xlsx but my friend's computer won't open it?

The most common reason is that your friend is using very old software that does not support .xlsx — this is rare now, but it happens with older versions of Excel or LibreOffice. Ask them what program they use, and if needed, save as .xls or .csv instead. Corruption is also possible if the file was damaged during read or transfer.

Should I use .xlsx or .csv for a customer list I'm sharing?

.xlsx if the person uses Excel or Google Sheets and you want to preserve any formatting or formulas. .csv if they need to import it into different software (accounting programs, CRM systems, databases) or if you are not sure what they use. CSV is the safer choice for data exchange between different programs.