How to Open an Excel File That Is Too Large

How-to basics · Updated November 20, 2026

If an Excel file is too large to open, first save a copy to your computer, then try opening it in the desktop version of Excel and use File > Open > Browse > Open and Repair if it fails. If the workbook contains more data than a worksheet can hold, import only the needed data with Power Query or split the source into smaller files. The steps below help you identify which problem you have and choose a safer way to access the contents.

What You’ll Need

  • The original workbook and enough free storage for a separate working copy. Do not overwrite the only copy while trying repairs or conversions.
  • Microsoft Excel for Microsoft 365 on Windows, preferably the 64-bit edition for very large workbooks. If you are using a Mac, see the notes about differences below.
  • The workbook password, if it is encrypted, and permission to access its location if it is stored on a network or cloud drive.
  • For a workbook that will not open, a second way to inspect or import its data may help, such as Power Query or the source system that created the file.

Step-by-Step

  1. Make a working copy and check the file. In File Explorer, copy the workbook to a folder on your computer, such as Documents, and try the copy rather than the original. Check that the copy has finished transferring and that its file size is plausible. A file that is only a few kilobytes when you expect a large workbook may be incomplete. Confirm the extension, such as .xlsx, .xlsb, or .xls, and ask the sender to resend it if the file appears truncated. If it is in a ZIP archive, extract the workbook before opening it.
  2. Check the worksheet size limit. A standard Excel worksheet supports up to 1,048,576 rows and 16,384 columns. An .xlsx or .xlsb file can store a workbook containing multiple sheets, but a single sheet cannot display more than those limits. If the source has more rows than a sheet can hold, repeatedly trying to open it will not make the extra rows appear. Use Power Query to filter or aggregate the records, divide the source into manageable parts, or use a database or other data-analysis tool designed for larger datasets.
  3. Try opening the copy in desktop Excel. Start Excel first, then select File > Open > Browse, choose the copied workbook, and select Open. If Excel displays a warning or asks whether to enable editing, read the message before proceeding. A file received by email or downloaded from the web may open in Protected View. Only select Enable Editing if you trust the source. Opening Excel before selecting the file can also help distinguish an Excel problem from a file-association problem.
  4. Use Open and Repair if Excel reports a problem. In Excel, select File > Open > Browse. In the Open dialog, select the workbook once, select the arrow beside the Open button, and choose Open and Repair. Try Repair first. If repair does not work, repeat the process and choose Extract Data, if offered. Save any recovered content under a new name, then check important formulas, formatting, links, and charts. Repair can recover content but may remove damaged features, so compare the result with the original where possible.
  5. Reduce memory pressure before another attempt. Close other large applications and unnecessary Excel workbooks, then restart Excel and try the copy again. Large workbooks can use substantial memory, especially when they contain many formulas, styles, images, pivot tables, or external links. If you have 32-bit Excel and work with large files regularly, consider installing 64-bit Microsoft 365, if your computer and add-ins support it. Changing to 64-bit Excel does not remove Excel’s row limit and cannot guarantee that every workbook will open.
  6. Import the workbook with Power Query instead of opening every sheet. In Excel for Windows, open a blank workbook and select Data > Get Data > From File > From Workbook. Choose the source workbook. In the Navigator window, select the relevant sheet or table and choose Transform Data to inspect and filter it before loading. Remove unneeded columns, filter rows, or group the records in Power Query. Then choose Home > Close & Load To… and select an appropriate destination. You can load a smaller result to a worksheet, or choose Only Create Connection or add it to the Data Model when you do not need every row displayed on a sheet. Power Query still needs sufficient memory and processing time; importing a huge source is not an instant fix.
  7. For a CSV or text file, import rather than double-click it. In Excel for Windows, use Data > From Text/CSV, choose the file, review the preview, and select Transform Data if you need to choose column types or filter records before loading. This is especially useful for identifiers that begin with zero, long numbers, and date-like text, which Excel might otherwise convert automatically. A CSV holds one table only; it does not preserve workbook sheets, formulas, formatting, charts, or other Excel features. If the CSV has more rows than one worksheet can hold, filter, divide, or analyze it without loading all rows to a sheet.
  8. Save a smaller, separate working version. Once you can access the data, keep the untouched source and save your work with File > Save As under a new name. Remove data you do not need, or save a filtered or summarized result as a new workbook. For future work, use an .xlsx or .xlsb format appropriate to your needs, but do not assume that changing the extension or format will make a file smaller or fix corruption. Confirm that the saved version opens before moving or deleting anything.

Common Mistakes

Assuming there is one universal file-size limit. Excel does not have a single practical file-size threshold that explains every failure. Available memory, Excel’s 32-bit or 64-bit edition, workbook contents, computer resources, and where the file is stored can all matter. A file that opens on one computer may fail on another.

Trying to force too many rows onto a worksheet. The worksheet row limit is fixed. If the source exceeds it, use Power Query to reduce or summarize the data, split it into parts, or use a database. A worksheet that shows only the first million-plus rows is not a complete import.

Converting to CSV without checking what will be lost. CSV does not retain formulas as formulas, formatting, multiple sheets, or workbook features. It may also change how dates, long numbers, or leading zeros are interpreted when opened. Keep the original file and review imported values before relying on them.

Saving over the only copy or repeatedly interrupting a load. Repair and recovery can discard damaged content, while closing Excel during a slow import may leave an incomplete result. Work from a copy, wait for progress to finish when possible, and save recovered data to a new file.

Tips

For recurring large-data work, prefer an import-and-transform workflow over opening every source workbook manually. In Power Query, remove unused columns early and filter records before loading. This reduces what Excel has to display and can make the resulting workbook easier to maintain. Keep a record of the filters or transformation steps so you can repeat the process when a fresh export arrives.

Use 64-bit Excel for large workbooks when compatible with your setup, and keep Microsoft 365 updated. Save the source on a local drive while diagnosing a slow network or cloud location, and ensure there is enough free disk space for temporary files and the output workbook. Avoid opening many large files at once. If the workbook contains external connections, links, macros, or sensitive data, check its source and security prompts before enabling content.

On Mac, the worksheet row and column limits are the same. Power Query features and menu availability can vary by Excel for Mac version and update channel. Look for Data > Get Data or the available text/CSV import option; if the workbook-import choices described above are absent, update Excel or perform the import in Excel for Windows. Excel for the web may not offer the same repair and import options as desktop Excel, so use the desktop app for recovery tasks.

Troubleshooting

Excel says the file format or extension is not valid: Check that the extension matches the actual file type and that the download or copy completed. Do not simply rename a file from .csv to .xlsx; changing the name does not convert its contents. Ask the sender for a fresh copy, or use Open and Repair on a working copy if the file is a genuine Excel workbook.

Excel appears frozen or takes a long time: Large files may need time to calculate formulas, update links, or load data. Check whether Excel is still using system resources and allow it to finish before force-closing it. If it repeatedly fails, restart the computer, close other applications, copy the file locally, and try Power Query to bring in a smaller selection. If the workbook contains external links, do not update them unless you trust their sources and need current linked values.

The workbook opens but some data is missing: Check whether the source exceeded the worksheet row limit, whether filters are active, and whether the imported query intentionally selected only certain sheets or rows. Review the Power Query steps and the Navigator selection. Compare the source record count with the loaded result; if more records are required than a worksheet can hold, keep the full dataset in a connection or Data Model, split it, or use a database.

Open and Repair cannot recover it: Try another copy or request the file again. If the source is in OneDrive or SharePoint, check version history for an earlier intact version. If you can access a prior version, save it separately and compare it with the damaged file. For business-critical data, ask the file owner or your IT support team before using third-party recovery tools, especially if the workbook contains confidential information.

Power Query also fails: Confirm that you selected the correct file and that Excel can access its folder. Try importing one sheet or table at a time, remove unnecessary data at the source, and check available memory and disk space. If the file is encrypted or password-protected, Power Query may not be able to read it directly; open it in Excel with the required password or request an unprotected data export from an authorized owner.

Frequently Asked Questions

What is the maximum size of an Excel file?
There is no single file-size figure that guarantees a workbook will open on every computer. Memory, Excel edition, workbook content, storage, and system resources affect what is practical. The per-worksheet limit is 1,048,576 rows by 16,384 columns.

Will 64-bit Excel open any large workbook?
No. It can use more memory than 32-bit Excel in many situations, which may help with large workbooks, but it does not remove worksheet limits or fix a damaged file. Add-ins and other software should also be compatible with 64-bit Office.

Can I open a workbook with more than 1,048,576 rows?
Not all those rows on one worksheet. Use Power Query to filter or summarize the source, load data to the Data Model where suitable, split it into smaller parts, or use a database. Choose the method based on whether you need to inspect, analyze, or edit every record.

Does saving as .xlsb make a large file open?
Not necessarily. The binary workbook format can reduce file size or improve performance in some cases, but it cannot repair a corrupt workbook, overcome worksheet limits, or guarantee that a computer has enough memory. Save to a new file only after you can open the source, and retain the original.

Can I open a very large Excel file in a browser?
Sometimes, but browser-based Excel does not provide every desktop recovery and import feature, and large files can still be slow or unsupported in a particular environment. For troubleshooting, use Excel for Microsoft 365 on Windows when available. Follow your organization’s storage and access rules for cloud files.

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.