'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
What Is the New Excel Format in 2023? (Explained & Solved)
Question details
The user is seeking information about the current standard file formats used by Microsoft Excel in 2023 and how to handle them.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Understanding modern spreadsheet file extensions and ensuring cross-platform compatibility.
- Observed behavior
- Looking to identify the default Excel file formats (such as .xlsx) and learn the proper ways to save or open these files without losing data or formatting.
Before working with modern spreadsheet files, ensure your office software is updated to support the latest XML-based formats (like .xlsx) to avoid compatibility issues.
Identify and Save Files in the Default .xlsx Format
The standard and most secure format for Excel in 2023 is the Office Open XML format (.xlsx). This method ensures you are saving files in the globally accepted standard.
Since Excel 2007, Microsoft has used .xlsx as the default format. This XML-based format compresses data to reduce file size and prevents the inclusion of macros, making it much safer than legacy formats.
Launch Microsoft Excel or a compatible alternative like WPS Spreadsheet and open your working document.
Click on the 'File' or 'Menu' tab located at the top-left corner of the window, then select 'Save As'.
In the 'Save as type' or 'File Format' drop-down menu, choose 'Excel Workbook (*.xlsx)'. Finally, click 'Save' to apply the standard 2023 format.
Use the .xlsm Format for Workbooks with Macros
If your spreadsheet contains automated scripts (VBA macros), you must use the Macro-Enabled Workbook format to ensure they function correctly.
Open and Save All Modern Excel Formats Seamlessly with WPS Office
WPS Spreadsheet provides native, full compatibility with all modern Microsoft Excel formats used in 2023, including .xlsx, .xlsm, and legacy .xls files. You can easily create, view, edit, and save these formats for free without worrying about data loss or formatting issues.
- 1. Download WPS Office: Download and install WPS Office for free from the official WPS website.
- 2. Open the Spreadsheet: Launch WPS Spreadsheet and click on 'Open' to load any modern .xlsx or legacy .xls file.
- 3. Edit Your Data: Use the familiar built-in tools, formulas, and formatting options to edit your document.
- 4. Save in Standard Format: Go to Menu > Save As, and select 'Microsoft Excel Workbook (*.xlsx)' to ensure seamless sharing with MS Excel users.
Frequently Asked Questions
What is the difference between .xls and .xlsx formats?
The .xls format is a legacy binary format used by Excel versions 97 to 2003. The .xlsx format is an XML-based format introduced in 2007 (and remains the standard in 2023). The modern .xlsx format provides smaller file sizes, better recovery of corrupted files, and enhanced security by not supporting executable macros.
Can older versions of Excel open the new .xlsx format?
Versions of Excel prior to 2007 cannot open .xlsx files natively. To open them on older software, users must install the Microsoft Office Compatibility Pack. Alternatively, you can install a modern, free office suite like WPS Office to easily open these files on older computers.
Why can't I save macros in the standard 2023 Excel format?
As a security measure to prevent macro-based viruses from spreading unknowingly, the default .xlsx format is designed to be incapable of storing VBA macro code. To save a workbook with macros, you must intentionally select the 'Excel Macro-Enabled Workbook (*.xlsm)' format.
