# Free Spreadsheet Software for Bank Statement Data - Author: CheapBankConvert (https://cheapbankconvert.com) - Published: 2026-10-17 - Category: Free tools you already own - Canonical: https://cheapbankconvert.com/blog/free-spreadsheet-software-for-bank-statements > Free spreadsheet software compared for bank statement work: what each opens, imports and exports, and where each one falls short of paid Excel. Four kinds of free spreadsheet software handle bank statement data well: Google Sheets, Excel for the web, LibreOffice Calc and Apple Numbers. All four open the CSV or Excel export your bank offers, sort and total it, and save it back out. None of them turns a PDF statement into rows on its own, and that gap decides most choices. ## Which free spreadsheet software can open a bank statement file? Every major free spreadsheet app opens the two files banks hand out for download: a CSV, which is plain text with commas between the columns, and an Excel workbook. If your bank lets you export transactions as CSV, any of the four free apps will show them as rows in a few seconds. The difference is in where each app runs and what it needs from you. - **Google Sheets** runs in a browser and needs a Google account. Google's help page on [importing data sets into Google Sheets](https://support.google.com/docs/answer/40608) lists the formats it accepts through File, Import: .xls, .xlsx and the macro and template variants, .ods, and the text formats .csv, .txt, .tsv and .tab. PDF is not on that list. - **Excel for the web** also runs in a browser. Microsoft's page on [free Microsoft 365 for the web](https://www.microsoft.com/en-us/microsoft-365/free-office-online-for-the-web) says a free Microsoft account gets the web versions of Word, Excel and PowerPoint with 5 GB of OneDrive storage, and that files must be saved in OneDrive to share and edit them together. - **LibreOffice Calc** is a desktop program you download and install on Windows, Mac or Linux. It needs no account at all and keeps files on your own disk. - **Apple Numbers** comes free with every Mac, iPhone and iPad. It opens CSV and Excel files and keeps its own .numbers format for anything you save. For statement work, the "no account" point matters more than it looks. A browser app stores your transaction history on someone else's server by default. A desktop app keeps it where you put it. Both are reasonable choices, but make the choice on purpose. ## Free spreadsheet software compared for statement imports and exports The table below compares the four free apps on the jobs a statement actually needs. The "PDF handling" column is the one most people care about, and it is the weakest column for every app. The row for Excel for the web describes the free tier only. | App | Cost | Opens bank CSV and XLSX | PDF handling | Saves as | Runs where | | --- | --- | --- | --- | --- | --- | | Google Sheets | $0 with a Google account | Yes, through File, Import | Not an import format | XLSX, ODS, CSV, PDF and others | Browser | | Excel for the web | $0 with a Microsoft account | Yes, from OneDrive | None for a file on your computer | XLSX, CSV, PDF | Browser | | LibreOffice Calc | $0, open source | Yes, including ODS | Opens PDFs in Draw, not as a table | ODS, XLSX, CSV and others | Windows, Mac, Linux | | Apple Numbers | $0 on Apple devices | Yes | Copy and paste from Preview only | Numbers, XLSX, CSV, PDF | Mac, iPhone, iPad | ### A worked example with an export Here is an example to make the table concrete. Say your bank lets you download three months of checking activity as a CSV, and the file holds 214 rows with five columns: date, description, amount, type and balance. The numbers are made up for illustration. 1. In Google Sheets or Excel for the web, you import the file and get 214 rows. A SUM of the amount column gives the net change for the quarter. 2. In LibreOffice Calc, a Text Import window asks for the separator and the format of each column before the rows appear. Set the date column to the order your bank uses, such as MM/DD/YY, and the dates arrive as real dates. 3. In Numbers, the file opens directly. Numbers guesses each column's type, so check that the amounts are right-aligned, which means they were read as numbers. All four finish this job in under five minutes. The free tools are close to equal when you start from a CSV. They separate only when you start from a PDF. ## Does free spreadsheet software read a PDF statement at all? Free spreadsheet software does not convert a PDF statement into rows by itself. Google Sheets will not import a PDF, LibreOffice opens one as a drawing, and Numbers can only take what you paste into it. The PDF has to become text in columns first, by a tool or by copy and paste. This is where most people hit the wall. Many banks offer only a PDF for older months, and some never offer a CSV at all. A PDF stores characters at positions on a page. It has no idea that a number sits in an "amount" column. A spreadsheet needs exactly that idea. There are three ways around it with free tools: - **Copy and paste.** Select the table text in a PDF reader, paste it into the spreadsheet, then split the columns. It works on a text PDF from online banking and fails on a scan, which has no text to select. - **A PDF import in desktop Excel.** Desktop Excel in Microsoft 365 for Windows has a Get Data, From PDF command that reads tables directly. The ways to bring a PDF into Excel, and which one to pick, are compared in [how to put a PDF into Excel](/blog/how-to-put-a-pdf-into-excel). - **A Google Docs detour.** Opening the PDF in Google Docs turns it into an editable document, and a table there can be copied into Sheets. The layout often breaks on the way. A PDF conversion step is the price of starting from a PDF. You pay it in minutes with a free tool, or in money with a converter. ## Where Google Sheets, LibreOffice Calc and Numbers fall short of paid Excel The free spreadsheet apps fall short of paid desktop Excel in three places that matter for statements: a built-in PDF import, a saved and refreshable cleanup recipe, and the comfort of the file format your accountant expects. Everyday sorting, filtering, SUMIF totals and charts work fine in all of them. ### No saved import recipe Desktop Excel records an import as a query, a list of cleanup steps you can rerun on next month's file. Google Sheets, Numbers and Calc have no direct match. You can write formulas that do the same cleanup, but you rebuild or copy them for each new file. For one statement a year, this costs nothing. For twelve, it adds up. ### Rough edges with bigger files A year of transactions is a few thousand rows, which is small for any spreadsheet. The strain comes from formulas, not rows. A sheet with a running balance check on every line, plus category lookups, recalculates on every edit. Browser apps feel that first, especially on an older laptop. ### Format friction Your accountant or bookkeeper most likely works in Excel. Every free app can save as .xlsx, but Numbers and Calc sometimes change fonts, column widths or a formula on the way out. Send a CSV when you only need to hand over data, and an .xlsx when the formulas have to survive. ### What paid Excel costs to fix this If these gaps start costing you time, compare the plans before you buy. [The cheapest Microsoft 365 plan that includes Excel](/blog/cheapest-microsoft-365-plan-for-excel) compares the subscriptions, and [Excel without a subscription](/blog/excel-without-subscription) covers the one-time purchase route and what it leaves out. ## Free spreadsheet CSV mistake: re-saving a bank export and losing its dates The most common free spreadsheet mistake with a bank export is opening the CSV, changing nothing important, and saving it again as CSV. The app rewrites every date and amount in its own display format, and the file your budgeting app or accountant expects quietly changes shape. Here is how it goes wrong, using an example row from a bank CSV: - In the original file: `2026-03-14,COFFEE ROASTERS #22,-4.75,DEBIT,1212.40` - After opening in a spreadsheet set to US dates and saving again: `3/14/2026,COFFEE ROASTERS #22,-4.75,DEBIT,"1,212.40"` Two things changed. The date switched from year-month-day to month/day/year, and the balance gained a thousands separator inside quotes. A budgeting app that expects the first format may reject the file, or read the day and month the wrong way round. A leading zero on a check number can also disappear, so check 0451 becomes 451. ### How to avoid it - Keep the bank's original CSV untouched in its own folder. Work on a copy. - When you must save a CSV, check the first five lines in a plain text editor before you send it. - In LibreOffice Calc, the Text Import window lets you mark a column as Text, which preserves check numbers and account numbers exactly. - Save your working copy as .xlsx, .ods or .numbers, and export a fresh CSV only for the app that needs one. This matters most when the statement is evidence. If you are rebuilding expenses from bank lines because the paper receipts are gone, keep the original files intact. [Using your bank statement when receipts are lost](/blog/lost-receipts-for-taxes) explains what the statement can prove on its own and what it cannot. ## When is free spreadsheet software enough for a year of statements? Free spreadsheet software is enough for a year of statements when your bank offers CSV exports, or when you have only a handful of short PDFs. It stops being enough when you face twelve or more PDF statements with no export option, because the copy-and-split step repeats for every page of every file. Use these questions to decide: - **Can you download CSV for every month you need?** Then any free app handles the year. Import each month, stack them on one sheet, and you are done. - **Are your statements PDFs of one or two pages?** Copy and paste is manageable. Budget ten to fifteen minutes per short statement, as an estimate. - **Are they long PDFs, or a stack of twelve?** Time yourself on one page first. Multiply by the page count to see the real cost before you commit an evening. - **Are some of them scans?** No free spreadsheet app reads a scan. You need OCR first, and OCR adds its own checking. For the PDF case, the per-file price is the number to compare with your time. [CheapBankConvert](/get-started) is preparing to launch a pay-per-statement converter that produces CSV and Excel files from text-based PDFs, with early prices from $2.99 for a statement of up to 10 pages and a free preview of the first 2 pages. The free apps above then take over for the sorting, totals and budgeting, which is the part they do well. A sensible split for most people is simple. Use the free app you already know for everything after the rows exist. Spend effort or money only on getting the rows out of the PDF in the first place.