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?
| Route | Works best when | Honest limit |
|---|---|---|
| Download CSV or Excel instead | Your statement page offers it | Layout and column names differ by bank, so check your own file |
| Drive: open the PDF with Google Docs | The PDF is typed text, not a scan | Tables often turn into loose lines; images and long files can fail |
| Copy from a PDF viewer, paste into Sheets | The PDF is short and text-based | One row can land in one cell or break across lines |
| Excel's Get Data from PDF, then save as CSV | You have a recent Microsoft 365 Excel | Menu 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?
- Upload the PDF to Google Drive.
- Right-click it, choose Open with, then Google Docs. Docs reads the text, using character recognition when the page is an image.
- Check the result. If each transaction is on a line of its own, select and copy the lines.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


