Excel files use different extensions depending on how you save them
The most common Excel extension is .xlsx, which is the default format when you save a spreadsheet in Microsoft Excel 2007 and later. If you open an older Excel file or save in a different format, you might see .xls, .xlsm, .csv, or several others. Each extension tells your computer what kind of data is inside and how to open it.
The extension matters because it determines what features your spreadsheet can use, what programs can open it, and whether other people can view your work. Choosing the right one depends on what you're doing with the file and who needs to access it.
Key Takeaways
- .xlsx is the standard Excel format and works with Excel 2007 and newer versions on Windows and Mac.
- .xls is the older Excel format from before 2007 and cannot store as much data or as many features as .xlsx.
- .xlsm is identical to .xlsx except it can contain macros, which are automated instructions that perform tasks in your spreadsheet.
- .csv is a plain-text format that removes all formatting and formulas, but opens in almost any program including Google Sheets and Apple Numbers.
- Choosing the wrong extension can cause you to lose formatting, formulas, or the ability to share your file with others.
.xlsx: The standard format for modern Excel
.xlsx is what you get when you save a spreadsheet in Excel 2007 or any version released after that. It is the default choice in Excel on Windows and Mac. This format can hold up to 1,048,576 rows and 16,384 columns, supports all Excel features including formulas, charts, and conditional formatting, and compresses the file so it takes up less storage space than older formats.
Use .xlsx when you are working with other people who have modern versions of Excel, when you need to preserve all your formatting and formulas, or when you want the file to be as small as possible. If someone tells you to send them an Excel file and does not specify a format, .xlsx is the safe choice.
.xls: The older Excel format
.xls is the format Excel used before 2007. If you have a very old spreadsheet or work with someone using Excel 2003 or earlier, you might encounter this extension. Files saved as .xls can hold only 65,536 rows and 256 columns, which is much smaller than .xlsx.
You should avoid saving new files as .xls unless someone specifically asks for it. If you open an .xls file in modern Excel and save it, Excel will ask whether you want to keep it in the old format or convert it to .xlsx. Converting to .xlsx is usually the better choice because it gives you more space and better compatibility with other programs.
.xlsm: Excel with macros
Macros are recorded sequences of actions that automate repetitive tasks in Excel. If your spreadsheet contains a macro — for example, a button that automatically fills in dates or calculates totals — you must save it as .xlsm instead of .xlsx. The "m" in .xlsm stands for "macro."
If you save a file with macros as .xlsx, the macros will be deleted and you will lose that automation. When you open an .xlsm file, Excel will show a security warning asking whether you trust the macros inside. This is normal and is Excel protecting you from potentially harmful code. Click "Enable" if you created the macros or trust the person who sent you the file.
.csv: Plain text for sharing across programs
.csv stands for "comma-separated values." It is a plain-text format that stores only the raw data in your spreadsheet — no colors, no formulas, no charts, no formatting of any kind. When you save as .csv, Excel converts all your formulas to their results, strips away all visual styling, and saves only the numbers and text.
.csv files open in almost any program: Google Sheets, Apple Numbers, LibreOffice, even basic text editors. Use .csv when you need to move data between different programs, when you are uploading information to a website, or when you are sharing a file with someone who does not have Excel. The tradeoff is that you lose everything except the raw data itself.
Other Excel extensions you might encounter
.xlsb is a binary format that Excel uses to store very large spreadsheets more efficiently. It takes up less space than .xlsx but is less compatible with other programs. Most people never need to use .xlsb.
.xltx and .xltm are template files. If you create a spreadsheet that you want to use as a starting point for multiple projects — like a monthly budget template or an invoice template — you save it as .xltx (or .xltm if it contains macros). When you open a template, Excel creates a copy so you do not accidentally overwrite the original.
.ods is the standard format for LibreOffice Calc, which is a free spreadsheet program. Excel can open and save .ods files, but some advanced Excel features may not work correctly in the conversion.
How to change a file's extension in Excel
Open the file in Excel, then click "File" in the top left corner. Select "Save As." A dialog box will appear with a dropdown menu labeled "Save as type." Click that dropdown and choose the format you want. Type a name for your file and click "Save."
Excel will warn you if you are about to lose data by changing formats — for example, if you are saving a file with macros as .xlsx, Excel will tell you the macros will be removed. Read the warning carefully before you proceed. If you change your mind, click "Cancel" and choose a different format.
Frequently Asked Questions
Can I open an .xlsx file in an older version of Excel?
Excel 2003 and earlier cannot open .xlsx files without a compatibility update. If you need to share with someone using very old Excel, save as .xls instead. You can read a free compatibility pack from Microsoft, but it is easier to just save in the older format.
What happens if I change the extension manually without using Save As?
Renaming a file from .xlsx to .xls by editing the filename does not actually convert it — it just confuses your computer about what is inside. Always use "Save As" in Excel to change formats. Your computer will try to open the file with the wrong program and may show an error.
Is .csv the same as Excel?
.csv is not an Excel format — it is a universal plain-text format that any program can read. Excel can open and save .csv files, but .csv cannot store formulas, formatting, or multiple sheets. Use .csv only when you need to move data between programs.
Do I lose my work if I save as a different extension?
You lose only the features that the new format cannot store. Saving as .csv removes formatting and formulas but keeps your data. Saving as .xls removes some advanced features but keeps basic data and formulas. Excel warns you before you lose anything important.
What extension should I use to email a spreadsheet to someone?
Ask them what version of Excel they have. If they have Excel 2007 or newer, send .xlsx. If they do not have Excel at all, .csv is safest because it opens in Google Sheets, Apple Numbers, and most other programs. If the file contains macros, send .xlsm and let them know they may see a security warning.