Average Excel File Size: What to Expect and Why It Varies

There is no single meaningful average Excel file size: a simple workbook may be only a few dozen kilobytes, while a workbook with extensive data, images, PivotTable caches, or a data model can reach hundreds of megabytes. As a practical—not statistical—guide, many straightforward workbooks fall somewhere from tens of kilobytes to a few megabytes; what the file contains matters far more than the number of sheets alone.

Why there is no universal average

Microsoft does not define a standard or official average size for Excel workbooks. The term covers very different files: a blank template with styled cells, a few pages of calculations, a million-row data extract, and a financial model with images and embedded data are all Excel files, but they have little in common in storage needs.

File size also depends on how a workbook was built and saved. Two workbooks showing the same visible values can differ in size because one has more formatting, saved source data, embedded objects, or a less compact file format. A size figure without context is therefore a weak way to judge whether a workbook is unusually large.

Practical size ranges and examples

These ranges are useful for setting expectations, not formal averages or limits. They assume an ordinary modern Excel workbook saved as XLSX; images, data models, and other features can change the result substantially.

Under 100 KB: A small tracker, form, or short calculation sheet with little formatting can fit in this range. A workbook with several sheets can still be small if it contains few populated cells.
About 100 KB to a few MB: Many everyday workbooks with lists, formulas, tables, charts, and normal formatting fit here. A workbook with several thousand rows may remain compact if the data is mostly text and numbers.
Several MB to tens of MB: Larger reports, extensive conditional formatting, many charts, imported data, or numerous images can push a workbook into this range. Size alone does not prove that something is wrong.
Hundreds of MB or more: Large datasets, saved PivotTable source data, an Excel Data Model, or many high-resolution images may account for this. At this scale, opening, saving, sharing, and memory use deserve attention.

For example, a monthly budget with a few hundred entries and formulas might be a fraction of a megabyte. A workbook containing years of transaction records, a PivotTable cache, and product photographs could be many times larger—even if its visible report occupies just a few sheets.

What makes an Excel workbook larger

In an XLSX workbook, sheets and much of the workbook’s structure are stored as XML inside a compressed package. This means repeated values and markup can compress well, but the amount and type of content still matter. The main contributors include:

Data volume: More populated cells generally mean more stored content. Long text fields take more space than short codes or numbers, and many populated columns increase the total further.
Formatting: Fonts, fills, borders, number formats, and conditional-formatting rules add workbook metadata. Applying formatting to whole rows or columns, or to a very large unused range, can create unnecessary overhead.
Images and objects: Photographs, screenshots, logos, shapes, and embedded files can outweigh the spreadsheet data. A workbook can look simple while containing large image files.
PivotTables and imported data: A PivotTable may retain cached source data so it can display results without immediately rebuilding from the source. Power Query imports and the Excel Data Model may also store substantial data.
Formulas and calculations: Formulas occupy space, but a large visible result is not necessarily caused by formulas alone. Repeated formulas are often less costly than images or a bulky data cache; volatile or complex formulas may affect recalculation time more than file size.
Workbook history and unused content: Old styles, deleted-looking but still-used ranges, hidden sheets, comments, and leftover objects can remain in a workbook and contribute to size.

How XLSX, XLSB, XLS, and CSV compare

The extension helps explain the file’s capabilities, but it does not predict size exactly. XLSX is the standard modern workbook format and is compressed. XLSB is Excel’s binary workbook format; for some workbooks it can produce a smaller file or open and save faster, but the result varies. It supports many Excel workbook features, but compatibility with other spreadsheet software and business systems should be checked before adopting it.

The older XLS format has legacy worksheet limits: 65,536 rows and 256 columns per sheet, compared with 1,048,576 rows and 16,384 columns in modern Excel worksheets. XLS may be needed for an older system, but it is not a general-purpose way to shrink a modern workbook.

CSV is plain text containing values from one sheet, not a full Excel workbook. Saving to CSV discards workbook features such as formulas as formulas, formatting, charts, and multiple sheets; formulas are represented by their displayed or saved values. Keep a separate XLSX copy if those features matter. CSV can be much smaller for a simple data table, but it is not an interchangeable replacement for a workbook.

How to check the file size

On Windows, save the workbook and check its file in File Explorer. The Size column or the file’s Properties window shows the stored file size. If the workbook is open, save it first so the number reflects the latest changes. Excel for the web files are stored in OneDrive or SharePoint, where the file details show the stored size.

On a Mac, locate the saved workbook in Finder and choose File > Get Info to see its size. Excel for Mac also saves to the selected location, so check the saved file rather than relying on how much memory Excel appears to use while the workbook is open.

Compare like with like: note the file extension, whether the workbook is saved locally or in cloud storage, and whether you are looking at bytes, kilobytes, or megabytes. A kilobyte (KB) is roughly a thousand bytes in everyday file-size displays, while a megabyte (MB) is roughly a thousand kilobytes; exact reporting can use binary units instead. A small difference in displayed size is not necessarily meaningful.

File size is not the same as workbook performance

A large file may open and calculate acceptably on a suitable computer, while a smaller workbook can feel slow because it has complex formulas, excessive conditional formatting, links to unavailable sources, or inefficient calculation patterns. File size measures stored content, not how much memory Excel needs while the workbook is open or how long a calculation takes.

Excel’s worksheet capacity is also not a recommended target. A sheet can contain up to 1,048,576 rows and 16,384 columns, but approaching those limits can make a workbook difficult to manage and may strain available memory or processing time. The useful question is not simply whether the file is large, but whether its size is appropriate for its purpose and whether it behaves reliably.

Ways to reduce an oversized workbook

Make a copy before removing content or changing formats, particularly if the workbook is used for reporting or contains data that cannot easily be recreated. Then investigate the largest likely contributors rather than deleting items at random.

Check images and objects. Remove duplicates or unnecessary images. In desktop Excel for Windows, select a picture and use Picture Format > Compress Pictures to reduce image size. Review the compression options before applying them; lower image quality may not suit print or presentation use.
Limit formatting to the used range. Avoid applying a style to entire columns or huge unused blocks without a reason. Remove unneeded formatting from genuinely unused cells, and review conditional-formatting rules for ranges that extend far beyond the data.
Review imported data and PivotTables. If a PivotTable does not need its source records stored in the workbook, check its data-retention settings and test refresh behavior before changing them. For Power Query, consider whether the query needs to load to a worksheet, the Data Model, or both.
Remove only content you understand. Check hidden sheets, named items, comments, and embedded objects before deleting them. Old-looking content may support formulas, charts, or reports elsewhere in the workbook.
Test a different format if appropriate. Save a copy as XLSB and compare its size and behavior if users and connected systems support it. Do not use CSV if multiple sheets, formulas, formatting, or charts must be preserved.

After each change, save the copy, reopen it, and verify key formulas, charts, PivotTables, and refresh processes. A smaller file is not an improvement if it has lost information or no longer works as intended.

When a large file may be a problem

Investigate if the workbook has grown suddenly without a corresponding increase in data, takes much longer to open or save, or behaves differently after routine edits. A sudden jump can point to an accidental formatting operation across a huge range, pasted images, duplicated data, or a growing cache. Compare the current file with a known-good earlier version and inspect what changed.

Large workbooks can also be awkward to email, sync, or open on lower-powered devices. If several people need the same data, consider whether a database, a data service, or a set of smaller purpose-specific workbooks is more suitable. That decision depends on how the data is maintained and shared; splitting a workbook without a plan can create multiple conflicting versions.

Frequently Asked Questions

What is the average Excel file size?
There is no reliable universal average, because workbooks range from tiny templates to data-heavy models. As a practical guide, a straightforward workbook is often in the tens of kilobytes to a few megabytes, while images, caches, and large datasets can make it much bigger.

Is a 10 MB Excel file large?
Not automatically. Ten megabytes may be reasonable for a workbook with many images, imported records, or PivotTable data, but it could be unexpectedly large for a simple list. Check the contents and how the workbook performs before deciding it needs to be reduced.

Why is my Excel file so large with only a few sheets?
Sheet count is not the main driver. Look for high-resolution pictures, formatting applied to unused cells, saved PivotTable or model data, hidden content, or embedded objects. A few sheets can hold a great deal of stored data.

Does XLSB always make an Excel file smaller?
No. XLSB can be smaller for some workbooks, but there is no guarantee; savings depend on the workbook’s contents. Compare copies and confirm that the people and systems using the file support the format.

Will saving as CSV reduce the size?
It may reduce the size of a simple table because CSV stores plain text values, but it saves only one sheet and removes workbook features such as formatting, charts, and formulas as editable formulas. Preserve an Excel copy when those features matter.

Does a large Excel file mean it is using the same amount of RAM?
No. File size is the amount stored on disk; memory use while Excel is open depends on workbook structure, calculations, data, and Excel’s processing needs. The two figures can differ substantially.

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.