Google Docs and Google Sheets work as a free PDF to spreadsheet converter, but in two stages. Drive opens the PDF in Docs and reads its text, then you copy the table into Sheets. Statement columns often arrive merged, so plan on splitting them with a single menu command.
Is Google Sheets a free PDF to spreadsheet converter?
Google Sheets cannot open a PDF on its own, so on its own it is not a converter. Google Docs can read a PDF, and Sheets can then take the text you copy. Together they form a free route that needs only a Google account and a text PDF.
Drive does the reading. When you upload a PDF and choose to open it with Google Docs, Drive converts the file into an editable document. Google's help page on converting images and PDFs to text says Drive runs text recognition on the file and keeps formatting such as bold, italics and line breaks. The same page says lists, tables, columns and footnotes are not likely to be detected.
That last line explains most of what goes wrong with bank statements, because a statement is a table. The words come through. The grid mostly does not.
What the free route does well
It handles a short, clean statement, a one-page invoice or a list with plain spacing. It costs nothing, needs no install and works on a Chromebook, a Mac or a Windows PC with only a browser.
Where it falls short
It struggles with long statements, wrapped descriptions and pages with logos or shaded boxes. Google also lists limits on the source file. The help page asks for text that is at least 10 pixels high, pages that are right side up and a file of 2 MB or smaller. Treat those as the conditions for good results, and check the page for the current wording before you rely on them.
Converting a PDF to a spreadsheet through Google Docs
The Google route has six steps: upload to Drive, open with Google Docs, copy the table, paste into Sheets, split the text into columns and export the file. The whole run takes about ten minutes for a short statement. The steps below use an example file called statement.pdf.
- Go to Google Drive and click New, then File upload. Choose statement.pdf.
- Right-click the uploaded file and choose Open with, then Google Docs.
- Wait while Docs converts the file.
- Select the transaction lines in the document, from the first dated line to the last one, and copy them.
- Open a new Google Sheet and paste into cell A1.
- Select column A, open the Data menu and choose Split text to columns. Pick a separator, or choose Detect automatically.
- Check the result against the PDF, fix what is wrong, then choose File, Download, and Microsoft Excel (.xlsx) or Comma Separated Values (.csv).
What the document looks like in Docs
For a text-based statement, Docs shows the lines in order, with each transaction as one line of text or as a small table if Google detected one. For a scanned statement, every character comes from text recognition, so read a few amounts against the PDF before you copy.
Saving the finished sheet
The Download menu in Sheets offers both formats. Choose XLSX if you will keep working in Excel, and CSV if you will upload the file to a budgeting app. A CSV holds only the sheet you have open, so open the sheet with your data before you download.
A quick sanity check before you export
Count the transaction lines in Sheets and compare with the statement. Add the amount column and compare with the printed totals. Do both checks before you export. A file that exports cleanly can still be missing a line from a page break.
Google spreadsheet route mistake: statement columns merged into one
The most common mistake on this route is that every statement line lands in column A as one long string, so the date, description and amount share a single cell. The cause is that Docs did not detect the table, so the paste has no column boundaries to follow.
A pasted line looks like this, using an example:
03/14 SQ *FLOUR SUPPLY CO 03/13 412.80 9,318.27
To a human, that line is a date, a description, an amount and a balance. To Sheets, it is one piece of text. Sorting by amount fails, summing the column gives zero, and filtering by date does nothing.
Why the pasted text has no tab marks
When Docs finds a table, the copy carries tab marks between cells, and Sheets places each cell in its own column. When Docs finds only text, the copy carries spaces. Spaces are also inside the description, so a plain split on spaces cuts "SQ *FLOUR SUPPLY CO" into four pieces and leaves the amount in a different column on each row.
A second mistake: the amount tied to the wrong line
Statements that print a description on two lines produce a second line with no date and no amount. In Docs these are two lines of text. After the paste they are two rows, and the second row is just words. If you sum the amount column, the sum is still right, because those rows have no amount. If you sort by date, the orphan rows jump to the top or the bottom. Fix them first: join each orphan row back into the description above it.
Spotting the problem fast
Look at column A. If every cell is long and the other columns are empty, you have the merge problem. If column A holds dates and column B holds text, Google detected the table, and you are in the better case.
Can LibreOffice turn a PDF into a free spreadsheet?
LibreOffice can open a PDF, but it opens it in Draw, its drawing program, and not in Calc, its spreadsheet. Draw shows each line of text as a separate box, so a statement imports as a page of loose text boxes and not a table. It is an alternative, not a shortcut.
For a desktop option that never uploads your file to a web service, LibreOffice has one real benefit: the PDF stays on your computer. That matters for a bank statement, because the file holds your name, address and account number.
How to try it
Open LibreOffice, choose File, Open and select the PDF. It loads in Draw. Select all the text boxes, copy and paste into a new Calc sheet. The paste often puts each line in its own row, with the same single-column problem as the Google route. The cleanup is the same, so the next section applies to both.
When LibreOffice is worth it
Use it when you want to keep the file off the web, and the PDF has a plain layout. If you want a tool built for the job, open source PDF to Excel converters such as Tabula read tables directly and avoid the text-box step. For Mac users without Excel, copying a statement into Numbers is the closest match.
Spreadsheet cleanup: splitting date, description and amount
Cleanup means turning one long string per row into separate date, description and amount columns. In Sheets, Split text to columns does most of the work when the separator is consistent, and a few formulas handle the rest. Do the split on a copy of column A, so the original stays as a fallback.
Step one: split with a separator
Select column A, choose Data, then Split text to columns. If the pasted text has tab marks, pick Tab. If it has two or more spaces between fields, choose Custom and type two spaces. The description may still contain single spaces, which is what you want, because a two-space separator keeps it whole.
Step two: when the separator fails
If neither works, pull the pieces apart with formulas. Using the example line from above in cell A2:
- The date is the first five characters:
=LEFT(A2,5) - The balance is the last word:
=INDEX(SPLIT(A2," "),COUNTA(SPLIT(A2," "))) - The amount is the second to last word:
=INDEX(SPLIT(A2," "),COUNTA(SPLIT(A2," "))-1) - The description is what remains between them.
These formulas assume a layout like the example. Test them on five rows before you fill them down, because a statement with no balance column shifts every position.
Step three: turn text into numbers
Pasted amounts such as 9,318.27 may be text. Use =VALUE(SUBSTITUTE(C2,",","")) to convert them. For debits and credits, decide on one sign convention. Many people keep deposits positive and withdrawals negative, so a plain sum gives the change in the balance.
Step four: check against the statement
Add the converted amounts and compare with the change between the opening and closing balance. If the two differ, a line is missing or double counted. Find it before you export.
What it costs in time
On a ten-line example, all of this is quick. On a statement with 140 lines, it takes real time, and a wrapped description can break any formula. If your cleanup is climbing past what a conversion costs, CheapBankConvert offers a one-time price per statement and a free preview of the first 2 pages, with no subscription. It is not open yet, so Get started to be told when it opens. For a delimited result without Sheets at all, converting a PDF to CSV for free is the related route.