How to use
- sales.pdfPages with tables
Add a PDF (one file)
- sales.pdfDrag lines to fix them
Check the frame and column lines
- sales.xlsxsales.csv
Save as Excel or CSV
Drop a PDF or click “Choose file”. “Try a sample” works too.
The preview shows table frames and column lines on the page. Uncheck any table you do not want to export.
If a column line is in the wrong place, drag it (or focus it and use the arrow keys). The result updates at once.
Choose whether numbers, amounts and dates become numbers, and whether to join the tables into one sheet or use a sheet per page.
Pick Excel or CSV, create the file and save it.
What it does
Tables estimated from text positions
Rows come from the height and vertical position of the text; columns from horizontal positions and the gaps between words. Ruling lines are not read, so tables without lines work as long as the text lines up.
Column lines you can fix
Drag the column lines on the preview, or focus one and use the arrow keys. The result changes at once. Choose which tables to export.
Numbers, amounts and dates as values
¥, commas, ▲ △ and negatives in brackets become numbers. yyyy/mm/dd dates become dates. Numbers with a leading zero (007) and phone numbers stay as text.
Export that does not run formulas
Text that starts with = + - or @ gets a leading ’ so a spreadsheet does not run it as a formula. Signed numbers such as -100 stay numbers.
One table across pages
When the last table of a page and the first table of the next page have their columns in the same place, they are joined into one table.
No upload
Reading the PDF, estimating the tables and writing the file all happen in your browser. The heavy work runs in a separate thread.
Use cases
- Total the amounts of an invoice’s line items in Excel
- Turn a list sent as PDF into a table you can sort and filter
- Join a statement that runs over several pages into one table
- Load the numbers of a report table as CSV without retyping them
Supported formats
Input
Output
Capability matrix
| Feature | Support | Notes |
|---|---|---|
| Tables in PDFs with text (ruled or unruled) | Partial | Estimated from text positions. Accuracy depends on how the PDF was made |
| Reading ruling lines (drawn lines) to set columns | Not supported | Ruling lines are not read. Column lines can be fixed on screen |
| Numbers, amounts and dates as values | Supported | Turn it off to write the text as it was read |
| Manual adjustment of column boundaries | Supported | Drag the column line, or use the arrow keys |
| Choosing which tables to export | Supported | — |
| Joining tables across pages | Partial | Joined only when the columns line up. A header repeated on the next page is included as a row |
| Merged cells and multi-line cells | Partial | Approximate. A merged cell goes into one cell; the merge itself is not kept |
| Numbers that use a period as the thousands separator (1.234 meaning 1234) | Not supported | Not judged. A period is read as a decimal point |
| Formatting, colours, fonts and borders | Not supported | Only the values are written |
| Formulas | Not supported | The calculated values are written; no formulas are created |
| Scanned pages (no text) | Not supported | No OCR here. Add text with OCR first |
| Tables embedded as images | Not supported | Text inside an image cannot be read |
| Vertical writing | Not supported | Built for horizontal tables |
| Password-protected PDFs | Not supported | Remove the protection first |
Limits & notes
- Up to 100 MB and 300 pages per file. A page range makes it faster.
- Also works on phones and tablets, but a PC is more reliable for adjusting columns and checking the Excel file.
- About 600,000 text items per analysis, and up to 200,000 cells in the export.
- Rows are set by vertical and columns by horizontal position, so slanted or shifted text is approximate.
Privacy & safety
Reading the PDF, estimating the tables and writing the file all happen inside your browser. Neither the PDF nor the extracted content is sent to a server.
FAQ
How do I convert a PDF table to Excel?
Can a scanned PDF table be converted?
Does it work on tables without ruling lines?
Do ¥ signs, commas and negatives become numbers?
Will the CSV show garbled characters?
How is this different from turning PDF pages into images?
Related tools
PDF Extract
Take the text, images, links, attachments, form values and bookmarks embedded in a PDF, for the pages you choose. Images stay as embedded (JPEG untouched). Your PDF never leaves your device.
Excel Cleanup
Tick what to fix and clean up spaces, character widths, dates and numbers across a whole Excel or CSV file at once. Changed cells are highlighted, and you can save as Excel or CSV.
CSV Studio
Open CSV files that are slow or garbled in Excel and view, search and edit them right away in your browser. Combine, split and save as CSV (UTF-8 with BOM, Shift_JIS), Excel or JSON on one screen.
Images to PDF
Drop images, put them in order and get one PDF. Choose page size, orientation and margins; phone photos are rotated correctly. Images are converted on your device and never uploaded.
Compress PDF
Drop a PDF to cut its size. Only photos and scans are recompressed, so text and graphics stay crisp. Your PDF is processed on your device and never uploaded.
PDF Editor
Lay text (Japanese included), shapes, arrows, a highlighter, freehand drawing and images on top of a PDF, and fill in its form fields. Text, shapes, highlights and freehand strokes are written as PDF vectors and real text, never as pictures; an added image is embedded as an image. Rewriting the original text and true redaction are not possible.
Last updated: