A converted Excel file not opening is usually blocked, misnamed or incomplete, not truly damaged. Check for a Protected View bar first, then the file's extension against its contents, then whether the download finished. Only after those does Open and Repair make sense, and reconverting the PDF is often faster than repairing the workbook.
Why is a converted Excel file not opening?
A converted Excel file fails to open for one of five reasons: Excel opened it read-only and is waiting for you, Windows or a mail filter blocked it as a download, its name claims one format while it holds another, the download stopped part way, or the workbook really is damaged. Check them in that order.
The order matters because the first checks take seconds and the last can take an hour. None of the first three involve anything wrong with the data.
The table below maps what you see to the likely cause. Treat it as a starting point, not a diagnosis, since different versions of Excel word their messages differently.
| What you see | Likely cause | First fix |
|---|---|---|
| The file opens, but a yellow or red bar says editing is off | Protected View | Enable Editing, if you trust the source |
| Nothing happens, or the file opens and closes at once | Blocked download | Unblock the file in its properties, or save it to a normal folder |
| A warning that the format and extension do not match | Wrong extension | Rename to match the contents, or open from inside Excel |
| "We found a problem with some content" | Damaged or incomplete file | Download again, then try Open and Repair |
| The sheet opens with one column of commas, or odd characters | CSV or encoding mismatch | Import with Data, From Text/CSV |
| The file size is 0 KB or far smaller than expected | Download did not finish | Download again |
Start with the file size. Right-click the file and open its properties. A workbook of 0 KB, or one far smaller than a few pages of data should be, never finished downloading, and nothing inside Excel will fix it.
Protected View bars on a downloaded workbook
Protected View is a read-only mode Excel uses for files from risky places. A file from the internet, from an email attachment or from an unsafe folder opens with a yellow bar across the top, and you can read it but not edit it. Choose Enable Editing on the bar to work on the file.
Microsoft's page on Protected View lists the triggers: files from the internet, files in locations treated as unsafe such as the temporary internet folder, attachments from senders your policy marks as unsafe, and files that fail Office's file validation check. Every converted file you download meets the first condition.
A red bar is different. It means Excel wants you to be more careful, and the way past it is File, then Edit Anyway. Microsoft's advice there is to do that only when you trust both the source and the content.
People often read Protected View as "the file is broken" because formulas look frozen, the ribbon is greyed out, and typing does nothing. The file is fine. It is waiting for permission.
A file that opens in Protected View and then crashes or shows an error once you enable editing is a different problem. Skip ahead to the repair section.
Downloaded workbooks blocked by Windows or a mail filter
Windows marks files that came from the internet, and some setups refuse to open marked files at all. On Windows, right-click the file, choose Properties, and look for an Unblock checkbox at the bottom of the General tab. Tick it, choose OK, and open the file again.
The checkbox appears only on files Windows has marked. If you do not see it, the block is not coming from Windows.
Mail and security software can block files too. A company mail filter may strip or quarantine workbook attachments, so what arrives is a stub or a warning message saved with an .xlsx name. Opening it fails because there is no workbook inside. Ask the sender to share the file another way, or download it directly from the converter instead of forwarding it by email.
Workplace computers sometimes block files from the internet by policy, and that cannot be changed from your own account. Saving the file to a folder your IT team trusts, or asking them how converted files should be handled, is the route there.
Wrong extension on a converted file: CSV, XLS or XLSX
Excel uses the extension, the part of the name after the dot, to decide how to read a file. A file named .xlsx must be a real XLSX workbook inside. When a CSV or an HTML page is saved with an .xls or .xlsx name, Excel warns that the format and extension do not match, or refuses outright.
This happens more than you might expect with converted files:
- CSV renamed to XLSX. Someone renames the file to make it "an Excel file". The contents are still plain text, and Excel cannot open text as a zipped workbook.
- Web page saved as XLS. Some older tools export an HTML table and name it .xls. Excel opens it with a warning, and the formatting may be odd.
- Error page saved as XLSX. If a download link expired, the server may send an error page that the browser saves under the expected file name.
To check what a file really is, open it in a plain text editor such as Notepad. A real XLSX begins with the letters "PK", because the format is a zip archive. A CSV shows rows of values separated by commas. An HTML page starts with tags in angle brackets. Rename the file to match what you see, or open it from Excel with File, Open, and pick the matching file type.
Never rename a PDF to .xlsx and expect a spreadsheet. Changing the name does not change the contents. If all you have is a PDF that was printed from a spreadsheet, converting that PDF back to Excel explains what can and cannot come back.
Can a damaged converted workbook be repaired?
A damaged workbook can sometimes be repaired with Excel's Open and Repair. Choose File, Open, select the file, click the arrow next to the Open button, and pick Open and Repair. Excel first tries to repair the structure, and if that fails, offers to extract the data alone, dropping formulas and formatting.
For a converted statement, extracting the data is often all you need. The file came from a conversion, so there were few formulas to lose. Values, dates and descriptions are what matter, and those are what extraction keeps.
Before you repair, rule out the cheaper explanation. Download the file again and compare the size of the two copies. If the new copy opens, the first download was cut short, perhaps by a dropped connection or a laptop going to sleep. Repair would have been guessing at missing data.
If repair fails, try opening the file in another program, such as Google Sheets or LibreOffice. They read the workbook format with different code and sometimes open files Excel rejects. Save the result as a fresh XLSX.
Very large files can look damaged when they are only slow. A workbook that hangs for minutes, or opens with "not responding" in the title bar, may simply be too heavy for the machine; shrinking a converted Excel file that is too large covers that case.
Converted files that open blank or full of odd characters
A file that opens without an error but shows nothing useful has usually been read in the wrong way. A CSV that lands with every value crammed into column A was split on the wrong separator. Accented letters that turn into strings like "é" were read with the wrong text encoding. Neither means the data is lost.
For both, import the file instead of double-clicking it:
- Open a blank workbook.
- Choose Data, then From Text/CSV, and pick the file.
- In the preview, set File Origin to UTF-8 if the characters look wrong.
- Set Delimiter to the character the file actually uses, such as comma or semicolon.
- Choose Load, or Transform Data to set column types first.
A sheet that looks empty may also be scrolled away from the data, or have its rows hidden. Press Ctrl+Home to jump to cell A1, and check the sheet tabs at the bottom, since a converter may have put the data on a second sheet.
Once the file opens and the columns are right, look at the values themselves. Percentages, rates and amounts sometimes come through scaled or stored as text; fixing percentages after a PDF to Excel conversion handles the most common version of that.
When to reconvert the PDF instead of repairing the workbook
Reconvert when you still have the source PDF and repair has not worked within a few minutes. A fresh conversion produces a clean file in less time than further rescue attempts, and it does not leave you wondering what the repair silently dropped. Keep the damaged copy until the new one checks out.
Repair is the better choice only when the workbook holds work you cannot redo quickly, such as categories you added by hand or notes on each transaction. In that case, extract the data with Open and Repair, then copy your added columns into a fresh conversion, matched row by row on date and amount.
If the source is a scan, improve it before you reconvert. A crooked page gives text recognition a harder time and produces messy output, which is one reason the first file may have come out strange. Straightening a scanned PDF before conversion shows how.
FastBankConvert is getting ready to open. It is built so the spreadsheet is ready to download as soon as the conversion finishes, in Excel, CSV or JSON, and you can ask to be told when trial conversions start through Get started.