Spreadsheets

Get a PDF statement into Google Sheets: the practical routes

How to get a PDF bank statement into Google Sheets: routes that work with Google tools, their honest limits, and a paste-and-split routine to clean it up.

Editorial illustration for Get a PDF statement into Google Sheets: the practical routes

The cleanest way to get a PDF statement into Google Sheets is to avoid the PDF: look for a CSV or Excel download of the same statement on your bank's site or app and open that in Sheets. If only a PDF exists, open it with Google Docs through Drive, or copy the text from a PDF viewer, then paste it into Sheets and split it into columns. Expect to tidy the result by hand.

Which routes actually work?

RouteWorks best whenHonest limit
Download CSV or Excel insteadYour statement page offers itLayout and column names differ by bank, so check your own file
Drive: open the PDF with Google DocsThe PDF is typed text, not a scanTables often turn into loose lines; images and long files can fail
Copy from a PDF viewer, paste into SheetsThe PDF is short and text-basedOne row can land in one cell or break across lines
Excel's Get Data from PDF, then save as CSVYou have a recent Microsoft 365 ExcelMenu names vary by version; upload the CSV to Sheets afterwards

Whichever route you pick, a statement PDF has your account details in it. Think twice before uploading it to a free converter site you found through search, and keep to tools you already trust.

How does the Drive and Docs route go?

  1. Upload the PDF to Google Drive.
  2. Right-click it, choose Open with, then Google Docs. Docs reads the text, using character recognition when the page is an image.
  3. Check the result. If each transaction is on a line of its own, select and copy the lines.
  4. Paste into column A of a new sheet.

If Docs gives you the narration on one line and the amounts on the next, the layout is too scattered for this route. Try the viewer-copy route or ask the bank for a CSV.

What does the paste-and-split routine look like?

Say column A now holds one line per transaction, like this made-up line: 12/08/2025 UPI/SWIGGY ORDER 45821 1,250.00 45,300.00. Remember that your statement will look different, so adapt the pieces.

  • Date in B2: =LEFT(A2,10)
  • Last two amounts in C2 and D2: =REGEXEXTRACT(A2,"([0-9,]+[.][0-9]{2}) +([0-9,]+[.][0-9]{2}) *$"). Sheets spreads the two captured pieces across C2 and D2.
  • Narration in E2: =TRIM(MID(A2,12,LEN(A2)-11-LEN(C2)-LEN(D2)-2))
  • Plain numbers in F2 and G2: =VALUE(SUBSTITUTE(C2,",","")) and =VALUE(SUBSTITUTE(D2,",",""))

The narration formula starts after the date and its space (position 12) and stops before the two amounts; the -2 allows for the two spaces that sit before them. Check a few rows by eye, because every bank lays its lines out differently.

How do I tell debits from credits?

Many PDFs print one amount column and a balance. If the balance after a row is lower than the row above, the row is money out; higher, money in. With a running balance in G, use =IF(G3<G2,"Debit","Credit") in H3 and read it against a few lines of the original. A made-up check: the row above shows a balance of ₹46,550 and this row shows ₹45,300, so the balance fell by ₹1,250 and H shows Debit.

Why do I see odd characters or merged rows?

When a sheet stops being the right tool

Cleaning a PDF every month is a lot of effort for a table you only wanted to categorise. SpendixAI accepts statements as PDF, CSV or Excel, lets you pick the account first, and shows the rows for review before saving. It flags possible duplicate imports as well. A PDF with an unusual layout may not parse perfectly, which is why the review step exists. Keep the sheet for the analysis you enjoy and let the import handle the typing.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports