Why Did My Excel Workbook Shrink From 33 MB to 8 MB?
Question details
The user wants to understand why an Excel workbook became smaller after editing in Google Drive and whether any content is missing.
- Product
- Microsoft Excel and Google Drive
- Device & OS
- not provided
- Scenario
- An Excel workbook was uploaded to Google Drive and edited, then its file size was compared with the original.
- Observed behavior
- The workbook shrank from 33 MB to 8 MB, while its data and formulas appear to remain present.
Locate the original workbook or an earlier version and the edited file. Check whether the edited file is still an Excel workbook or has been converted to Google Sheets before comparing their sizes.
Check the workbook format and compare its contents
Use this check to determine whether a format change or differences in workbook content could explain the smaller file.
An Excel Binary Workbook (.xlsb) can be significantly smaller than an .xlsx or .xlsm workbook without removing cell data. Changes to compression, unused formatting, conditional formatting, or embedded objects can also affect file size.
In Google Drive, select the edited file and open File information or Details to check its type. For a downloaded Excel file, check its extension, such as .xlsx, .xlsm, or .xlsb.
Open the original and edited workbooks in Excel. Compare sheet tabs, including any hidden sheets, and check important data ranges and formulas.
Compare charts, images, conditional formatting, and any macros used by the original workbook. In Excel, select Home > Conditional Formatting to inspect formatting rules on relevant sheets.
In Excel, press Ctrl+End on a relevant sheet to see the last cell Excel considers used. A change in formatting across unused rows or columns may affect the workbook's size.

Compare with an earlier Drive or Google Sheets version
Use version history to inspect or recover an earlier copy if the edited workbook differs from the original.
Review Excel workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and reviewing spreadsheets. Its Excel format compatibility helps you move existing workbooks into WPS Spreadsheet, though it does not fix Google Drive conversion or version-history issues.

Frequently Asked Questions
Does a smaller Excel file mean data was deleted?
Not necessarily. A change in format, compression, formatting, or embedded objects can reduce file size. Open both versions and compare important sheets, formulas, charts, and other features.
How can I tell whether the workbook is an XLSB file?
Check the downloaded file's extension. An Excel Binary Workbook ends in .xlsb; an Excel workbook may instead end in .xlsx or .xlsm. You can also check its file type in Google Drive's file details.
Can editing an Excel workbook in Google Sheets change its features?
Yes. If the file was converted to Google Sheets, some Excel-specific features may behave differently or may not transfer. Compare the original and edited versions, especially macros, charts, and conditional formatting.
Where can I find an earlier version of the file?
In Google Drive, right-click an Excel file and select Manage versions. For a Google Sheets file, open File > Version history > See version history. Earlier versions are available only if they were retained.




