Extract Tables from PDF to CSV (Excel)
Bank statements, supplier invoices, financial disclosures, and research papers lock structured rows inside fixed PDF coordinates. Copying and pasting them into Excel or Google Sheets usually collapses every column into a single unreadable cell.
Haven PDF reconstructs rows and columns directly from the PDF text coordinate grid (Y-baseline clustering and X-column ordering) inside your browser and exports a UTF-8 BOM CSV file that opens cleanly in Microsoft Excel, LibreOffice Calc, and Google Sheets — without uploading a single byte of your financial data to a server.
Drag & drop or browse · Your files are never uploaded
How to
- Drop your PDF into Haven PDF. Your document opens immediately in browser memory — nothing is uploaded.
- Run OCR if the PDF is a scan (optional). If text is not selectable, click OCR in the toolbar first.
- Click Download → Extract Table (.csv). Open the Download menu in the top-right corner and choose Extract Table (.csv).
- Open in Excel or Google Sheets. The downloaded UTF-8 CSV file opens with rows and columns separated into cells.
How coordinate-based table reconstruction works locally
Unlike a plain text dump, PDF content streams position each cell using explicit (X, Y) coordinates. Haven PDF groups text spans that share the same horizontal baseline (within 3 pt tolerance) into rows, sorts spans left-to-right by their X coordinate into columns, and writes RFC 4180-escaped CSV cells with a UTF-8 BOM header so Excel preserves currency symbols and accented characters.
| Method | Column preservation | Privacy (Bank statements / Invoices) | Cost |
|---|---|---|---|
| Copy & Paste from PDF viewer | Breaks — columns merge into one line | Local | Free |
| Cloud PDF-to-Excel converters | Good | Uploaded to third-party servers | Often paywalled after 1 file |
| Haven PDF (Extract Table CSV) | Coordinate-sorted rows & columns | 100% local in browser RAM (0 bytes uploaded) | Free & unlimited |
What if the PDF is a scanned image?
If your invoice or statement came from a physical scanner and you cannot select text with your cursor, run the built-in OCR tool first (supports 30+ languages locally via WebAssembly). Once the invisible text layer is placed over the scan, download the Table CSV from the Download menu.
Frequently asked questions
- Is it safe to convert bank statements and tax tables here?
- Yes. Haven PDF runs entirely client-side inside your browser tab. Your bank statement never leaves your computer or phone.
- Why does Excel show garbled characters with some CSV files?
- Excel on Windows expects a UTF-8 Byte Order Mark (BOM) to detect Unicode characters automatically. Haven PDF prepends the UTF-8 BOM () so Turkish, German, French, Arabic, and currency characters open cleanly.
- Does it export all pages or just selected pages?
- If you select specific pages in the left thumbnail sidebar, only those pages are exported to CSV; otherwise all pages in the document are included.