Excel shows this warning when the contents of a file are not the format its extension claims, and many banks' downloads named .xls are really HTML or plain text. If you downloaded the file yourself from your own bank, opening it anyway is usually safe. Check that it looks like a table, then use Save As to turn it into a real XLSX.
Why do some statement downloads trigger this warning?
The extension is only a label. A bank's website can create a table of transactions as web-page code and name the file with an .xls ending, so that Excel launches when you open it. Excel looks inside, sees web-page code instead of a spreadsheet, and warns you that the label and the contents disagree. The same warning also appears for genuinely suspicious files, which is why it should not be ignored.
How do you check what the file really is?
- Right-click the file and choose Open with, then Notepad.
- If you see readable tags such as table, tr and td, or lines of text separated by tabs or commas, the file is HTML or text with the wrong extension.
- If the first two characters are PK, the file is actually an XLSX that has been renamed.
- If you see only unreadable symbols with no tags, it may be a real old-style .xls, and the warning may mean damage.
A file that looks like none of these, or that came as an email or chat attachment you did not expect, should not be opened at all.
When is it safe to click Yes?
| Situation | Sensible action |
|---|---|
| You logged in to your bank yourself and just downloaded the statement | Open it anyway, then convert and save it right away |
| An attachment from someone you did not expect | Do not open it. Delete it, or confirm with the sender another way |
| An old download from a shared computer | Do not open it. Download a fresh statement |
| The file will not show readable data in Notepad | Download again, or ask your bank to resend it |
How do you turn it into a proper XLSX?
- Click Yes to open the file. It may open in Protected View, so click Enable Editing for a file you trust.
- Confirm the data looks like a table, with the header row at the top and the dates down the left.
- Choose File > Save As, set Save as type to Excel Workbook (*.xlsx), and give it a clear name.
- Close the workbook, reopen the new XLSX and confirm that no warning appears this time.
If the cells look jumbled, rename a copy of the file to end in .html instead of .xls and open that copy in your browser. A browser can display the table, and you can copy the rows into a new workbook.
Can you avoid the warning in future?
Look at what else your bank's download page offers. If it provides CSV, XLSX or PDF as well as the .xls option, a genuine CSV or XLSX will open without any warning. If .xls is the only choice, convert it once as described above and keep working from your XLSX. The warning then appears only for the next raw download, not for your own saved copy.
Keep the raw .xls file in a folder of originals. If a total ever looks wrong, you can open it again in Notepad and compare.
Check the numbers once
Pages built as HTML often store amounts as text. Select the amount column and look at the status bar: if it shows Count but no Sum, the numbers are text. Use Data > Text to Columns and click Finish on the first step to convert them, then compare the total with the statement summary.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


