Convert XLS to Excel: How to Save as an XLSX Workbook

How-to basics · Updated November 22, 2026

An .xls file is already an Excel workbook; it uses an older Excel file format. To convert it to the modern format in Excel for Microsoft 365 on Windows, open the file, select File > Save As > Browse, choose Excel Workbook (*.xlsx) in Save as type, and select Save.

What an XLS file is—and what conversion means

The .xls extension identifies the Excel 97–2003 Workbook format. It was the standard Excel workbook format before Microsoft introduced the XML-based .xlsx format with Excel 2007. So if someone asks you to convert XLS to Excel, they may mean one of two things: open an existing Excel workbook, or change that workbook from the older .xls format to the newer .xlsx format.

Changing the extension alone does not convert the file. For example, renaming budget.xls to budget.xlsx in File Explorer does not rewrite the workbook’s contents into the new format. It can make the file difficult to open or cause an error. Use Excel’s Save As command or another spreadsheet program’s export command to perform a real conversion.

The newer .xlsx format is based on Office Open XML, a documented file format that stores workbook content in a package of related files. It supports more rows and columns than the old format: an .xls worksheet is limited to 65,536 rows and 256 columns, while an .xlsx worksheet supports 1,048,576 rows and 16,384 columns. A conversion does not create new data, but the newer format removes those old worksheet limits.

Convert an XLS file in Excel for Windows

In Microsoft Excel for Microsoft 365 on Windows, follow these steps:

  1. Open Excel and open the .xls workbook. If Windows asks which app to use, choose Excel.
  2. If the workbook opens in Protected View, review the file’s source before selecting Enable Editing. Files from email or unfamiliar websites deserve extra caution.
  3. Select File > Save As, then select Browse to open the Windows Save As dialog.
  4. Choose a folder and, if useful, enter a different file name so the original stays easy to identify.
  5. Open Save as type and select Excel Workbook (*.xlsx).
  6. Select Save. If Excel displays a compatibility or feature warning, read it and choose the option that preserves the features you need.

Excel normally saves the converted workbook as a separate .xlsx file when you use Save As and choose a new name or folder. Keeping the original .xls is a practical backup until you have checked the new copy. Close and reopen the .xlsx file to confirm that it opens correctly, then review important sheets and calculations.

Convert on a Mac or in a browser

Excel for Microsoft 365 on Mac also supports saving an .xls workbook as .xlsx. Open the workbook, choose File > Save As, select Excel Workbook (.xlsx) as the file format, choose a destination, and save. The dialog’s labels and layout can vary slightly by Excel release, but the key is choosing the .xlsx workbook format rather than changing the filename suffix manually.

Excel for the web has a different workflow because it works with files stored online, such as in OneDrive or SharePoint. If the .xls file is available in OneDrive, open it in Excel for the web and use the available Save a Copy or download options to create a modern workbook copy. The precise commands can depend on the account and how the file was opened. For a file with macros or complex features, use the desktop version of Excel and verify the result there.

If you do not have Excel, LibreOffice Calc can open many .xls workbooks and save a copy in the Excel 2007–365 (.xlsx) format. In Calc, use File > Save As and select the Excel format from the file-type list. When prompted about using the Excel format, confirm that you want to use that format. Because spreadsheet programs can interpret some features differently, inspect the converted file in the application that will be used to work with it.

What may change during conversion

Many ordinary workbooks convert without noticeable changes. Cell values, common formulas, worksheet names, and basic formatting are generally carried over. Still, an older workbook may contain features that do not map perfectly to .xlsx, particularly if it was created in a much older Excel version or relies on specialized add-ins.

Macros are an important exception. The .xlsx format cannot store VBA macro code. If the .xls file contains macros that must remain available, save a copy as Excel Macro-Enabled Workbook (*.xlsm) instead. Do not choose .xlsx for a macro-dependent workbook unless you intend to remove the VBA code. Excel may warn that macro features cannot be saved in a macro-free format.

Other details worth checking include:

  • Formulas and calculated results: Most familiar formulas carry over, but formulas that depend on old features, add-ins, or external data may need attention.
  • Charts and formatting: Review chart labels, conditional formatting, page breaks, print areas, and unusual fonts if the workbook is used for reports.
  • External links and connections: A workbook can refer to other files or data sources. Conversion does not guarantee that those sources will still be reachable.
  • Legacy features: Some older tools or embedded objects may behave differently or may not be supported in the same way in newer Excel.

Conversion does not automatically make incorrect data correct, and it does not usually turn formulas into plain values just because the extension changes. The main concern is whether a specific feature in the original format is supported and preserved. Excel’s warning messages and the workbook’s own results are more useful than assuming every file will behave identically.

How to check the converted workbook

Do a quick check before replacing or sharing the original. Start with the sheets that matter most, especially any summary or dashboard pages. Compare a few key totals with the source file, verify that formulas display results rather than errors, and check that filters, charts, and print layouts still work as expected.

For a workbook used in a process or report, also consider these checks:

  • Confirm the new file ends in .xlsx, and that its type is Excel Workbook rather than Excel 97–2003 Workbook.
  • Check the last rows and columns containing data, particularly if the old workbook was close to its .xls size limits.
  • Look for warning indicators or formula errors such as #REF! on important sheets.
  • Refresh connected data only if you trust the source and have permission to access it.
  • Ask the person receiving the file to confirm they can open and use the copy, especially if they need macros or external connections.

For a simple personal workbook, these checks may take only a minute. For a recurring business report, preserve the original and validate key outputs before treating the converted copy as the new working file.

Choosing XLSX, XLSM, or another format

Use .xlsx for a typical workbook that contains data, formulas, formatting, and charts but no VBA macros. It is the usual choice for current Excel workbooks and avoids the old .xls worksheet limits. Use .xlsm when you need to keep VBA macros in a macro-enabled workbook. Excel may show security warnings when a macro-enabled file is opened; only enable macros from sources you trust.

Keep .xls when compatibility with a genuinely old spreadsheet program or device is required and that program cannot read .xlsx. That choice preserves the older file type and its lower worksheet limits. If the workbook includes macros, confirm the recipient’s software supports them too; choosing an extension alone cannot make incompatible code work.

Other formats serve different purposes. CSV is useful for exchanging plain tabular data, but it generally stores one sheet at a time and does not preserve workbook features such as formulas as formulas, formatting, charts, or macros. PDF is intended for viewing or printing, not continued spreadsheet editing. Choose one of these only when its limitations fit the task.

Safety and privacy when converting online

Online conversion websites can be convenient, but uploading a workbook sends its contents to a third party. A spreadsheet may include personal details, payroll, customer information, hidden sheets, or confidential formulas even when those items are not immediately visible. For sensitive files, prefer Excel or another approved offline application and follow your organization’s data-handling rules.

Be cautious of sites that ask you to install an unfamiliar program, browser extension, or macro to convert a file. A standard .xls-to-.xlsx conversion does not require enabling macros or sharing account passwords. If a file came from an unexpected message, verify the sender and scan it according to your normal security practices before opening it.

Frequently Asked Questions

Is XLS already an Excel file?
Yes. .xls is an older Microsoft Excel workbook format. Converting it to .xlsx changes the workbook’s file format; it does not change a non-Excel file into an Excel file.

Can I convert XLS to XLSX without Excel?
Yes. LibreOffice Calc can open many .xls files and save them as .xlsx. Check the resulting workbook in the software the recipient will use, since complex features can be interpreted differently.

Will changing .xls to .xlsx in the filename convert it?
No. Renaming only changes the displayed extension, not the file’s internal format. Open the workbook in a spreadsheet application and use its Save As or export command.

Will converting XLS to XLSX keep macros?
No. .xlsx cannot store VBA macro code. Save a macro-enabled workbook as .xlsm if its macros need to be preserved, and only enable macros from sources you trust.

Does converting XLS to XLSX remove formulas?
Ordinary supported formulas generally remain formulas. However, formulas that rely on unsupported features, add-ins, or external connections may need checking, so review important results after saving.

Which format should I send to someone?
For a normal modern Excel workbook, send .xlsx. Use .xlsm only when the recipient needs VBA macros, and use .xls only when their software specifically requires the older format.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.