PDF to CSV

Bank statements, supplier price lists, sales reports and timetables usually arrive as PDFs, and the data inside is exactly what you need in a spreadsheet or an accounting tool. Retyping it is slow and error-prone. CSV is the most universal format for tables: every spreadsheet, database and accounting program can import it. This tool turns the tables on each PDF page into CSV, with options for the details that usually cause trouble.

How tables are found

A PDF has no real table cells, only text placed at positions. The tool looks at where text starts on each line: positions shared by many lines become columns, and each piece of text goes into the column it starts in. Columns that end up empty everywhere are removed. The preview shows the first rows of the first page with text, so you can judge the result before downloading.

Clean tables with clear column alignment, such as most statements and reports, convert well. Tables where one cell spans several lines produce extra rows, and merged header cells may land in one column; tidy those in the spreadsheet afterwards.

Choosing the separator

• Comma (,) is the default in English-speaking countries and for most software.
• Semicolon (;) is what Excel expects in countries that write decimals with a comma, such as Germany, France, Spain, Italy, Brazil and many others. With commas there, Excel puts every row into a single column.
• Tab creates a .tsv file, the safest choice when cell text itself contains commas and semicolons.

Multi-page statements

A 12-page bank statement usually repeats the column titles on every page. Choose One CSV for all pages and keep Skip header rows repeated on later pages on: the titles appear once and all transactions follow. Start each row with its page number helps when you need to find a line in the original. If you only need some pages, type a range such as 2-11 to skip a cover page and a summary.

Cleaning numbers

Off by default, because numbers are written differently around the world. Turn Clean numbers on when amounts look like 1,234.50 and you want real numbers: thousands separators and currency symbols are removed, and accounting negatives like (45.00) become -45. Keep it off for European formats (1.234,50) and for codes where leading zeros matter.

Opening the file in Excel

Double-click works when the separator matches your region. Otherwise use Data → From Text/CSV and choose the separator there. The Excel-friendly encoding option adds a byte-order mark so accents and currency symbols display correctly. In Google Sheets, use File → Import.

Statements stay on your computer

Financial statements are among the most sensitive documents people convert. The text positions are read by your browser and the CSV is written on your device; nothing is uploaded, logged or kept.

When there is no text

Scanned statements are images. The tool warns when pages have no text; make them searchable with OCR PDF and convert the result. For a spreadsheet with one sheet per page and numbers as numbers, use PDF to Excel. To turn the CSV into an Excel file later, use CSV to Excel, or into JSON with CSV to JSON.