How to convert a PDF to CSV
Choose the PDF, or drop it on the box. Its pages are read on this device and every table becomes rows and columns at once: the preview shows them as a spreadsheet will, and under it the first lines of the CSV file as it will be saved. Choose the separator, then Download CSV. Copy for Google Sheets pastes the rows straight into a sheet, and the same rows can be saved as an Excel file.
Plain numbers for importing
Accounting software, databases and scripts expect an amount written one way: digits, a point before the decimals and a minus sign in front. So the CSV writes -1,450.00 from a statement as -1450.00, (45.00) as -45.00 and $9.99 as 9.99, keeping the decimals the PDF shows. Dates, account numbers and other text stay exactly as the PDF writes them. Choose As the PDF writes them to keep the thousands separators and currency signs.
Comma, semicolon or tab
Most programs expect a CSV file separated by commas. Excel set to a language that writes decimals with a comma, such as German or French, opens a file in columns only when it is separated by semicolons, and a program that asks for TSV wants tabs. A cell that holds the separator or a quote is put in quotes, so the columns stay in line. The file is UTF-8 with a byte order mark, so Excel shows accented letters correctly, and text that starts with =, +, - or @ gets an apostrophe in front, so a spreadsheet does not run it as a formula.
Statements over several pages
The column headings and the bank’s name repeated at the top of each page are left out, so the rows of a long statement follow on as one table, and a description that wraps onto a second line is joined to its row. Untick either if your file needs them, or type the pages that hold the table, such as 2-5.
What it cannot read
One PDF of up to 200 MB at a time, without a password. Only text stored as text is read: a scanned page is a picture and needs OCR, which this tool does not do, and it says so rather than giving you an empty file. Columns come from where the text sits, so a table needs no lines between its cells; merged cells and text turned on its side do not come across.
The CSV file is made in your browser from your PDF. Nothing is uploaded.