---
title: "Bank statement PDF to Excel, or straight to a budget"
description: "Bank statement PDF to Excel: why the copy-and-paste route breaks, and how Era reads a statement from any bank into a manual account, ready to ask about."
publishedAt: "2026-11-05"
updatedAt: "2026-11-12"
canonicalUrl: "https://tinwell.dev/articles/bank-statement-pdf-to-excel/"
---

Turning a bank statement PDF into Excel is possible, and it is also the start of an afternoon: the columns drift, the descriptions wrap onto two lines and the running balance lands in the wrong place. If the spreadsheet is only a means to see where your money went, Era skips it. Upload the statement from any bank in any country, and Era reads it into structured transactions in a manual account, beside your connected ones. [Create your free Era account](/sign-in) to try it on the statement you have open.

## How do you convert a bank statement PDF to Excel?

The quickest first try is Excel itself: its Data tab can import tables from a PDF (Get Data, From File, From PDF). Microsoft's own documentation says multi-line rows are not always identified properly and may need cleaning up, so check the result against the statement's closing balance, because a transaction in the wrong column quietly changes every total after it.

When the PDF is a scan or a photo, or the layout is unusual, expect to tidy by hand or to look for another tool. That is the point at which many people decide they do not want a spreadsheet so much as an answer.

## Why does a statement PDF turn into a mess in a spreadsheet?

A statement is laid out to be read on a page, not to be sorted. Descriptions run over several lines, dates appear in the bank's own format, debits and credits may share a column, and every page repeats headers and a running balance that are not transactions at all.

A spreadsheet treats all of that as cells, so a person has to decide which rows are real. A tool that understands what a statement is, with its period, its opening and closing balance and its lines of transactions, can make those decisions for you.

## What does Era do with a bank statement PDF?

Era reads the statement and turns it into structured transactions, with dates, amounts and descriptions, in a manual account that you choose or that Era creates from the bank name and the last digits. You see the rows it read, accept them, and they join your spending and cash flow like any others.

Because the account sits next to your connected accounts, one question covers everything: "Use Era. What did I spend on groceries across all my accounts last quarter?" Overlapping statements do not double your numbers, since rows already in the account are left out. [How to add manual accounts and set up your budget](/articles/how-to-add-manual-accounts-and-set-up-your-budget/) covers the account side in more detail.

## How is Era different from a PDF-to-Excel converter?

A converter, such as Adobe's online PDF to Excel tool, turns the tables in a PDF into rows and columns in an editable XLSX file, and its job ends there. Era carries on: it reads the statement into transactions in a manual account, beside your connected ones, where your spending, your cash flow and your assistant's answers already work.

| | Excel's PDF import | Adobe's online converter | Era |
|---|---|---|---|
| What it produces | The tables it finds in the PDF, loaded into a worksheet | An editable XLSX file of the PDF's tables and other content | Structured transactions with dates, amounts and descriptions |
| Where it ends | A worksheet you check and clean yourself | A file you download and then edit | A manual account beside your connected ones |
| After the import | Formulas and pivot tables are yours to build | Formulas and pivot tables are yours to build | Spending and cash flow across every account, and questions to your assistant |

If a spreadsheet file is all you want, either converter is the shorter road for one clean statement, and Adobe's runs in any web browser. The difference shows once there are twelve statements and several accounts.

## Does it work for any bank, in any country?

Yes. Era reads a statement from any bank, whether or not Era connects to that bank, and it recognizes the language the statement is written in. That includes a credit union with no connection, an account you opened abroad and the old savings account you only look at once a year.

For people who live between countries, this is the part that tends to matter. Your US accounts can connect, your home-country account arrives as a statement, and the household sees one picture. Era connects accounts across the US, the UK, Canada, France, Germany, Spain, and 40+ countries in all, and the statement route covers the rest.

## Is it safe to upload bank statements?

Era stores the statement in your own Document Library, and nothing is visible to anyone else until you choose to share it. When you work through an assistant such as Claude or ChatGPT, the assistant passes an upload link and the file goes straight into your library, so the assistant never handles the file's contents.

Data is encrypted at rest and in transit, and no provider trains on the data supplied to it. You can delete a statement whenever you like, and the transactions imported from it can be rejected or restored as a batch. [Is it safe to give AI your financial data](/articles/is-it-safe-to-give-ai-your-financial-data/) goes through each safeguard.

## Can Era read a year of statements at once?

Yes. Choose a batch of statements, a year's worth for example, and Era shows you the price of reading them before it starts, so nothing is read until you agree. Each statement lands in the right manual account, and a history that would take a weekend to retype is there in an afternoon.

Single statements work the same way, and every value Era reads keeps the page it came from. What Era can read, and how it keeps the source beside each figure, is set out in [what AI can read in your financial documents](/articles/what-ai-can-read-in-your-financial-documents/).

## What if you still want a spreadsheet?

Ask for one. Once the transactions are in Era, your assistant can build a table of whatever you need, such as spending by category, a month against the last, or every payment to one merchant, in a form you can paste into Excel or Sheets. The difference is that the table comes from clean transactions rather than from a PDF.

For tax time, [organize tax documents with AI](/articles/organize-tax-documents-with-ai/) shows how the same library holds the forms and the statements together.

## How do you turn a statement into transactions in Era?

Upload the statement PDF to your Document Library, choose the manual account it belongs to or let Era create one, and check the rows Era read before you accept them. The whole thing takes a few minutes for a single statement, and your assistant can start the upload for you.

1. Sign up at [era.app](/sign-in) and open your Document Library.
2. Upload the statement PDF, or ask your assistant to hand you an upload link.
3. Choose the manual account for it, or let Era create one.
4. Check the rows Era read, accept them, and ask your first question.

If you share money with a partner or housemates, start from the Household template in a shared space, place the statement there and everyone, including each member's assistant, sees the same figures. [How to share financial documents with family](/articles/how-to-share-financial-documents-with-family/) shows how the pieces fit.

[Add to Claude Official](https://claude.ai/directory/era-context) [Add to ChatGPT & Codex Official](https://chatgpt.com/plugins/plugin_asdk_app_6a1e0440ecc081918f60d334729eb03c)

## Sources

- [Microsoft Learn: PDF connector for Power Query](https://learn.microsoft.com/en-us/power-query/connectors/pdf) for the table import and the note on multi-line rows, read on November 12, 2026.
- [Adobe Acrobat: Convert PDF to Excel](https://www.adobe.com/acrobat/online/pdf-to-excel.html) for the online converter, read on November 12, 2026.

## Related reading

- [Ask AI about your bank statement](/articles/ask-ai-about-your-bank-statement/)
- [Keep receipts and invoices organized with AI](/articles/keep-receipts-and-invoices-organized-with-ai/)
