'%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)
How to Import Older Excel Files into Microsoft 365
Question details
The user needs to open, import, or convert older legacy Excel file formats so they can be accessed and edited within Microsoft 365.
- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- Attempting to access data stored in older Excel workbooks within the modern Microsoft 365 environment.
- Observed behavior
- While Microsoft 365 natively supports many older formats, unsupported files fail to open directly and require conversion to the modern .xlsx format beforehand.
Check the file extension of your older workbook (e.g., .xls) to determine if it is a standard legacy format, which helps anticipate if Microsoft 365 will open it directly or require conversion.
Open Older Excel Files Directly in Microsoft 365
Use this built-in method if your older Excel file format is still natively supported by the current Microsoft 365 environment.
Microsoft 365 Excel maintains backward compatibility with a wide range of standard older formats, such as standard .xls files. Opening them directly is the fastest way to access your data.
Open the Microsoft Excel desktop application from your Start menu or through the Microsoft 365 app hub.
Click on 'File' in the top-left corner of the ribbon, then select 'Open' from the sidebar menu.
Click 'Browse' to locate the older Excel workbook on your local drive, select the file, and click 'Open' to load it into the application.
Import Excel Data into a Microsoft List
Best for users looking to migrate spreadsheet data directly into a Microsoft List or SharePoint environment.
Convert Unsupported Formats Before Opening
Necessary when Microsoft 365 displays an error stating the file format is unsupported or restricted.
Easily Open and Convert Any Excel File with WPS Office
If you are struggling with unsupported legacy file formats in Microsoft 365, WPS Office offers a powerful, free alternative. It features excellent backward compatibility, allowing you to open older spreadsheets effortlessly and save them in modern formats.
- 1. Install WPS Office: Download and install the free WPS Office suite on your device.
- 2. Open the Legacy File: Launch WPS Spreadsheets, navigate to 'Menu' > 'Open', and select your older Excel file.
- 3. Save as Modern Format: Go to 'Menu' > 'Save As' and select the .xlsx format to ensure full modern compatibility.
Frequently Asked Questions
Why won't Microsoft 365 open my old Excel file?
Microsoft 365 drops native support for certain severely outdated formats (such as Excel 4.0 macros or very early .xls versions) primarily for security reasons. You must convert these files to a modern format before Microsoft 365 will allow you to open them.
How can I batch convert older Excel files to .xlsx?
Microsoft 365 does not include a native batch conversion tool for legacy files. You will need to use third-party conversion software, alternative office suites, or write a custom VBA script in an older version of Excel to process multiple files at once.
Will I lose my macros when converting older Excel files?
If you are converting from an older macro-enabled format to a standard .xlsx file, macros will be stripped. You must save the file as a Macro-Enabled Workbook (.xlsm) to retain VBA scripts, though some legacy Excel 4.0 macros may still be restricted by modern security policies.
