Search results
Results From The WOW.Com Content Network
The following file formats are no longer supported in Excel 2016, Excel 2013, Excel 2010, Excel Starter, and Excel 2007. You cannot open or save files in these file formats. Format
Most of the time, you’ll probably want to save your workbooks in the current file format (.xlsx). But sometimes, you might need to save a workbook in another file format, like the file format of an earlier version of Excel, a text file, or a PDF or XPS file.
In Microsoft Excel, workbooks are saved as Excel Workbooks (.xlsx) by default. You can change the default file format to any other file format that is supported in Excel. For example, if you frequently create macros in a workbook, you may want to automatically save a new workbook as an Excel Macro-Enabled Workbook (.xlsm).
Learn about the various file formats that are supported in Microsoft 365 including .docx, .xlsx, .pptx, and OpenDocument format.
See a list of supported file formats and descriptions for Excel for Mac workbooks.
Recover a corrupted workbook manually when Excel can't start File Recovery mode automatically and learn about saving backup and recovery files to prevent losing your work.
There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu. There are two commonly used text file formats:
When you open a file in Excel, you get an message that the file name extension doesn't match the actual file format. For example, the file has an .xlsx file name extension but it's really a text file and should have a .txt file name extension.
You might want to save your file in another format so that you, or somebody else, can open the file in a different program or older version. For example, you might want to save your Word document as a Rich Text File (RTF) or your Excel workbook as a Comma-Separated Values (CSV) file.
You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.