Guides / We found unreadable content

“Excel found unreadable content”: what the repair prompt really does, and what to do when it isn't enough

Q: Should I click Yes when Excel says it found unreadable content?

Yes — on a copy of the file. Clicking Yes runs Excel's built-in recovery, which is free, fast, and often enough. The risk is that Excel silently discards what it can't parse and then saves the stripped version, so keep the original untouched. After recovery, read the repair log it offers and check your sheets before trusting the result.

Updated August 29, 2026

We found a problem with some content in 'budget.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Unlike the flat refusal (“file format or extension is not valid”), this message is actually good news in disguise: Excel can read your file's container. It opened the archive, started parsing the contents, and hit something malformed. Now it's asking permission to strip out whatever it can't digest.

What's actually broken

An .xlsx is a ZIP archive of XML parts: one XML file per worksheet, a shared table holding every piece of text in the workbook, plus styles, formulas' cached values, and relationship files that wire it all together. “Unreadable content” means the archive itself unzips fine, but at least one part inside is damaged: truncated XML in a worksheet, a corrupt shared string table, a broken drawing or pivot cache, or a relationship pointing at a part that doesn't exist.

The damage is usually local. One torn worksheet part doesn't touch the bytes of the others, which is why partial recovery works so well on this error.

Step one: let Excel try, on a copy

First, copy the file and open the copy. When the prompt appears, click Yes. Excel's recovery is free and genuinely fixes a lot of these. When it finishes it reports what it did, typically Repaired Records or Removed Records lines, with a link to a repair log listing each affected part.

Now audit the result before celebrating: walk every sheet tab, spot-check your important columns, and press Ctrl+End on each sheet to see where the data really stops. Excel's recovery has one blunt habit: anything it can't parse, it silently drops. Sometimes trailing rows, sometimes a whole worksheet's contents, sometimes every text cell at once (when the shared string table is the broken part, text cells across all sheets go blank or turn to junk while numbers survive).

If the recovered copy is missing data

Run Open and Repair with Extract Data. File → Open → Browse, select the original (single click), click the arrow on the Open button → Open and Repair… → Extract Data. This is a different, more aggressive path than the Yes-prompt: it abandons formatting entirely and pulls values and formulas.
Open the original in LibreOffice Calc. Free from libreoffice.org. Its parser tolerates malformed XML that Excel rejects, and it frequently loads rows Excel's repair discarded. If it opens, save a new .xlsx immediately.
Import into Google Sheets. Upload the copy to Google Drive → right-click → Open with → Google Sheets. A third, independent parser. Note that this uploads the file to Google, which is a real consideration for payroll or client data.
Peek inside the archive. Rename a copy from .xlsx to .zip and open it with your file manager or 7-Zip. If it opens, you can see the parts (xl/worksheets/sheet1.xml and friends) and a tool like 7-Zip's Test will name the entries that fail. Even just knowing which sheet is damaged tells you what you're fighting for.
Check for an older clean version. OneDrive/SharePoint Version history, File → Info → Manage Workbook in Excel, email attachments, backups. Restoring yesterday's file is often faster than repairing today's.

The gap this tool fills: rows Excel throws away

Excel's repair works at the level of whole records and parts. When a worksheet's XML breaks at row 4,801, it may discard far more than the one broken row. FileQuiet's repair salvages damaged worksheet XML row by row: it keeps every row that parses, up to the exact point of corruption, rebuilds the shared text table, and re-emits a clean workbook from what survived.

Everything runs in your browser; the workbook is never uploaded anywhere, and the network tab will confirm it. The preview shows your actual recovered sheet tabs and rows before any payment; if there's nothing to show, there's nothing to buy. $12 one-time.

See what's recoverable, free

Honest limits: rows past a destroyed region are only recoverable if their bytes survived. Formulas return as their last calculated values, formatting is mostly lost, and encrypted workbooks can't be repaired.

Frequently asked

Should I click Yes when Excel says it found unreadable content?

Yes, on a copy of the file. Clicking Yes runs Excel's built-in recovery, which is free, fast, and often enough. The risk is that Excel silently discards what it can't parse and then saves the stripped version, so keep the original untouched. After recovery, read the repair log it offers and check your sheets before trusting the result.

Excel says it removed records or removed a part. Is that data gone?

Gone from Excel's repaired copy, but usually not gone from the original file. Excel's recovery drops anything it can't parse cleanly: sometimes whole rows or a whole part like the shared text table. A more tolerant parser, or a row-by-row salvage of the damaged XML, can often recover content that Excel's repair threw away. That's why you keep the original.

Why does the same workbook keep showing this warning?

Something keeps re-damaging it, or the damage was never fully cleaned. Usual suspects: the file lives on a network share or USB stick and saves get interrupted, two people or two sync clients write it at once, or a marginal disk. Repair a copy, save it under a new name to a local drive, and see the guide on why Excel files get corrupted to stop the cycle.

Can I see exactly what Excel removed?

Partly. After a repair, Excel shows a dialog listing repairs and offers a log (an XML file) naming each removed or repaired part, for example a worksheet or the shared string table. It names parts and record types, not cell-by-cell contents. To see what was actually in the damaged region, you need a salvage of the original file rather than Excel's stripped copy.