# PDF to Spreadsheet: Statements in Google Sheets or Excel

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-16
- Category: Bank statements to Excel and CSV
- Canonical: https://fastbankconvert.com/blog/pdf-to-spreadsheet-google-sheets

> PDF to spreadsheet for your statements: Google Sheets or Excel, the CSV import steps, locale settings that scramble numbers, and what to hide first.
To turn a statement PDF into a spreadsheet, run it through a converter that outputs CSV or XLSX, then open or import that file in Google Sheets or Excel. Do not open the PDF itself in a spreadsheet. Import the converted file, set the separator and locale, and check that dates and amounts read as real values.

## Google Sheets or Excel as the target spreadsheet?

Use Excel if you work alone on your own machine with large files and heavy formulas, and Google Sheets if several people need to open, comment on or edit the same statement data from a browser. Both handle a statement's four basic columns without trouble.

### When Google Sheets fits

Sheets lives in the browser, so there is nothing to install, and a link replaces an email attachment. It suits a shared household budget, a club treasurer and a bookkeeper who wants a client to fill in a "what was this payment?" column. Several people can edit at once, and the version history shows who changed a cell.

### When Excel fits

Excel suits files that stay on your computer, very long lists, pivot tables you build every month and workbooks with macros or Power Query steps. If your accountant already works in Excel, send them an XLSX and skip the conversion in between. The guide to [opening a PDF in Excel with File > Open or import](/blog/open-pdf-in-excel) covers what Excel can read from a PDF directly.

### Switching later is cheap

You are not locked in. Sheets downloads as XLSX or CSV, and Excel opens CSV directly. If you are unsure, convert to CSV, which both read, and decide afterwards. Be careful with the one thing that does not travel well between the two, which is number formatting based on the region setting. That is the subject of the locale section below.

### Which file to download

CSV is plain text with a comma between fields. It is small, opens anywhere and carries no formatting. XLSX is an Excel workbook that can hold formats, several sheets and formulas. FastBankConvert's homepage lists Excel, CSV and JSON downloads, and says you can open the result in Excel or Google Sheets. For Google Sheets, CSV is the easier path because the import dialog lets you set the separator and locale, as the next section shows.

## Importing a converted CSV into a Google Sheets spreadsheet

You import a CSV into Google Sheets with File > Import: upload the file, choose where it goes, choose the separator, and decide whether Sheets should convert text to numbers and dates. The steps below turn a converted statement into a working sheet.

### The steps

1. Convert the statement PDF to CSV and save the file on your computer. A converter built for statements, such as the one described in [what a bank statement converter does with your PDF](/blog/bank-statement-converter), writes one row per transaction.
2. In Google Sheets, open a blank spreadsheet. Go to File, then Import.
3. Choose the Upload tab and drop the CSV there, or browse to it.
4. Under Import location, choose Create new spreadsheet, or Insert new sheet(s) if you want it inside a workbook you already have.
5. Under Separator type, choose Comma. If the preview shows everything in one column, the file uses semicolons or tabs, so pick that separator instead. Detect automatically usually works.
6. Under Convert text to numbers, dates, and formulas, leave the box ticked if you want amounts and dates as real values. Untick it if you need to see the raw text first.
7. Choose Import data.

### The locale setting, called out

Before step 7, check the spreadsheet's locale, because Sheets reads dates and decimals in the file by that locale. It is found under File, then Settings, in the General tab, as Locale. A file with dates like 03/04/2026 reads as March 4 under United States and as 3 April under United Kingdom. Set the locale first, then import. Changing it afterwards does not fix text that Sheets already misread.

### Check the first rows

After import, click an amount cell and a date cell. A real number is right-aligned by default and shows as a number in the formula bar. A real date is also right-aligned. Left-aligned values are text and will not add up. Add a quick test: type =SUM(range) over the amount column and compare the result with the statement's totals.

### Quoted fields and commas in payee names

If a payee name contains a comma, a correct CSV wraps it in quotes. Sheets handles that, but some tools do not, and the columns then shift. If the amount column looks wrong in a few rows, read about [commas in payee names and other CSV quoting traps](/blog/bank-statement-to-csv#commas-in-payee-names-and-other-csv-quoting-traps).

## Can Google Sheets turn a PDF into a spreadsheet by itself?

Not reliably. Google Drive can open a PDF with Google Docs and attempt to read its text, but the result is a document, not a spreadsheet. Columns collapse into lines of text, and a transaction table usually needs to be rebuilt by hand.

### What the Drive trick does

You upload the PDF to Google Drive, right-click it and choose Open with, then Google Docs. Docs creates a document containing the text it found, with the page images or layout kept where it can. A digital statement comes out as a document with each cell as its own paragraph or a rough table. Scanned pages are read with text recognition and are less exact.

### Why it falls short for statements

A statement is a table where position carries meaning: a number's column tells you whether it is a debit, a credit or a balance. In the Docs version that position is mostly gone. Copying the text into Sheets then puts the values into one column, and you must split dates, descriptions and amounts yourself. For a one-page list that may be fine. For 40 transactions a month, it takes longer than converting the statement properly.

### Other built-in routes

Excel has its own import for PDF tables, described in the guide to [opening a PDF in Excel](/blog/open-pdf-in-excel). Sheets has no equivalent built in. For a statement, a converter that outputs CSV or XLSX is the shorter path, and then you import as above.

### A fair test

If you want to try the Drive route, use a sample page and not your real statement. Open it with Docs, copy a few rows into Sheets and see whether you can split them with Data > Split text to columns. If the descriptions contain spaces, the split will cut them apart, which shows the problem quickly.

## Locale settings that scramble spreadsheet dates and decimals

A locale tells a spreadsheet which decimal mark, thousands separator and date order to expect. When the file and the locale disagree, you see 1.250,00 where you expected 1,250.00, or days and months swapped. Fix it by setting the right locale before you import, not by editing cells.

### Decimal commas

Many countries write one thousand two hundred fifty as 1.250,00, with a dot for thousands and a comma for decimals. If a CSV written one way is read under the other locale, 1,250.00 may import as text, or 1.250 may import as 1.25. A cell that will not sum is the sign. If only some rows are affected, the file likely mixes formats.

### Day and month order

A date such as 04/05/2026 is ambiguous. Under a United States locale it is April 5. Under most others it is 4 May. The trap is that days above 12 break the pattern: 25/03/2026 cannot be read as month 25, so those rows import as text while the ambiguous ones import as the wrong date. A column with a mixture of real dates and left-aligned text is the sign. The safest dates in a CSV are written year first, as 2026-05-04, which both read the same way.

### An example of what goes wrong

| In the file | Locale read | Result |
| --- | --- | --- |
| 04/05/2026 | United States | April 5, 2026 |
| 04/05/2026 | United Kingdom | May 4, 2026 |
| 25/03/2026 | United States | Text, not a date |
| 1.250,00 | United States | Text, not a number |
| 1,250.00 | Germany | Text, or a wrong value |

These rows are examples to show the pattern, not output from a real statement.

### How to fix it

In Google Sheets, set File > Settings > Locale, then import again. In Excel, do not double-click the CSV. Use Data > From Text/CSV, which lets you choose the delimiter and, in the preview, fix how dates and numbers are detected. If a converted file keeps landing wrongly, the post on [making converted numbers editable](/blog/pdf-to-excel-editable) covers how to repair amounts stored as text.

## Sharing a statement spreadsheet without account numbers

Before you share a statement spreadsheet, remove what the recipient does not need: the full account number, the account holder's address, and any column of personal reference numbers. Check the file's other sheets and the document properties as well, not only the visible cells.

### What to remove first

Statements print an account number, sometimes in full, in the header and sometimes inside transaction descriptions. They also print the holder's name and address, and a reference number on some transfers. Search the sheet for the last four digits and for the first digits of the account number to find every place. In Sheets, use Edit > Find and replace. In Excel, use Ctrl+F.

### Hiding is not removing

Hidden rows, hidden columns and filtered-out rows stay in the file and in any copy. Anyone can unhide them. If a value must not leave, delete it. A chart or a pivot table can also hold a copy of the data after you delete the source rows, so check those too.

### Share the narrowest version

Make a copy of the sheet with only the columns the other person needs: usually date, description and amount. Paste the values into a new workbook rather than deleting from the original, so you keep the full version for yourself. In Google Sheets, share by link with Viewer access, not Editor, unless the person must change cells, and avoid "anyone with the link" for financial data. Choose named people instead.

### Where the converted file goes first

Treat the file before you share it as sensitive. FastBankConvert's FAQ says uploads are encrypted in transit and that trial files are deleted after your download, and on a paid plan you choose whether to keep files in your history. Whatever tool you use, read its privacy terms, and keep a plain local copy of the clean version. To try the converter on your own statement when it opens, start at [Get started](/get-started).