CSV for a simple table
Use a lightweight UTF-8 file when you only need rows and columns.
Download first, then import the reviewed file
How to Convert a Bank Statement to Google Sheets
BSC does not connect to Google Drive or write into a spreadsheet. Convert the PDF, review the downloaded CSV or XLSX against the original statement, then use Google Sheets File and Import controls to bring the file into a sheet.
- CSV or XLSX download
- Manual Google Sheets import
- No Drive access requested
Start with a reviewed conversion
This guide does not create a second upload flow. Use the linked real tool, then return to the instructions.
Choose CSV or Excel
Both downloads come from the same successful conversion but serve different review preferences.
XLSX for formatted review
Use the Transactions worksheet, frozen header and formatted date and amount cells.
JSON stays separate
JSON is machine-readable but is not the normal manual import format for Google Sheets.
Import without losing control
Use a new or clearly identified spreadsheet and inspect the import choices before replacing existing cells.
Keep the original download
Retain an unchanged file so later edits can be compared.
Choose an import location
Create a new sheet or select another explicit option rather than overwriting data accidentally.
Check dates and numbers
Confirm that locale settings did not reinterpret dates, decimals or separators.
How to complete this task safely
- 1
Convert and download
Choose CSV or XLSX after the transaction result passes the required checks.
- 2
Open Google Sheets
Create or open the destination spreadsheet and choose File, then Import.
- 3
Review the imported cells
Compare row count, dates and amounts with the PDF before adding formulas or categories.
Limits and failure boundaries
- BSC does not access Google Drive, create a Google Sheet or synchronize later changes.
- Google Sheets locale settings can change how dates and decimal separators are interpreted.
- A converted statement should be reconciled before it is used for reporting.
Safe usage rule
Keep the original PDF and compare the transaction count, dates, descriptions, amount direction and balances before relying on any converted file. A successful download is not a substitute for your own financial review.
Google Sheets: import Excel dataCurrent Google instructions for importing an Excel file into Sheets.Frequently asked questions
Can BSC export directly to Google Sheets?
No. Download CSV or XLSX, then import the file manually in Google Sheets.
Should I use CSV or XLSX?
CSV is a simple table. XLSX adds workbook formatting. Both describe the same validated conversion result.
Why did a date change after import?
Google Sheets may interpret dates according to the spreadsheet locale. Compare the imported values with the source and adjust the sheet format deliberately.
Does BSC need access to my Google Drive?
No. The only Google account access used by BSC is the existing sign-in flow; the converter does not request Drive access to create or edit Sheets.
Start with a reviewed statement file
Keep the source statement, review the converted rows, and stop whenever the evidence is not clear enough for a safe result.
Bank statement to CSV