gizmobench
BrowseDaily

PDF Table Extractor

Convert a PDF table to CSV or an editable Excel workbook in your browser, without an account, email address or upload. Choose a PDF with selectable text, adjust the column guides, and check each cell against its source on the page before downloading .csv or .xlsx. Blank cells and codes such as 0012 stay in place as text. For scanned pages, create a searchable PDF with OCR first; this extractor does not recognize text in pictures.

sourceno PDF yet

The page appears here, with the region and the column guides over it.

tableno table yet

The table appears here, cell by cell, with blanks, flags and your edits marked.

· or drop one anywhere on the stage

Never uploadedNo accountRead in this tabUp to 50 MB

Table
none yet
Blank cells
none yet
Flagged
none yet
Edited
none yet
    Pages

    Every page read uses the same region and guides, in points on the page as shown.

    Region, in points from the top left of the page
    Column guides, in points from the left

    No guides: the table is one column.

    Rows
    Text across a guide
    Export

    The CSV is UTF-8 with a byte order mark and CRLF line ends, quoted by RFC 4180. A plain number is digits with an optional minus and decimals that read back digit for digit: 240, -36 and 3.25 are; 1,500, 0012 and 1.50 are not, so they stay text.

    The rules this table is read by.

    • Lines: from the top down, text whose baseline sits within 3 pt of a line's first baseline joins that line.
    • Rows: every line is a row.
    • Columns: each piece of text goes to the column holding most of its width, whole. Text that crosses a guide by more than 0.5 pt is flagged.
    • Cells: pieces in one cell join in reading order, with a space where the gap is at least 0.2 text heights. Spaces at the ends are dropped; blanks stay blank, never filled in.
    • Suggest guides: one guide mid-gap wherever no text crosses for at least 0.6 text heights, ignoring lines that hold a single piece of text.
    • Region: text is read when its middle lies inside it.
    • Two columns of positioned textitems at x 72 and x 300 pt, one guide at 200 pt
      A1 "Alder", B1 "12"; A2 "Birch", B2 "7": each lands in its own column, row by row
    • Row 4 has no BinWing nut M6, a gap, then 36
      B4 stays blank, 36 stays in Qty (C4), and row 5 reads Spring clip, B-02, blank, recount, not shifted
    • A scan with no text layera page that is only a picture
      reports no text on the page and extracts nothing: no rows, and no value is guessed
    Accuracy. Reads only the text layer a PDF already has, placing each piece of text by where it sits between the column guides you set: nothing is recognized from images, so a scanned page reports that it has no text. Blank cells stay blank and numbers keep the characters the text layer holds, never filled in or recalculated, while merged or irregular layouts can land in the wrong cell, so every cell links to its source box for checking and your corrections go straight into the CSV and XLSX. PDFs up to 50 MB are read on your device and never uploaded.

    Common questions

    Can it convert a scanned PDF to CSV?
    No. A scanned page is a picture with no text layer, and this tool reads only text layers, so it reports that the page has no text and extracts nothing from it; no value is guessed. Run the scan through OCR first, for example Searchable PDF OCR on this site, then open the searchable copy here.
    Is my PDF uploaded anywhere?
    No. The PDF is read in your browser tab with pdf.js, and the CSV and XLSX are written there too. PDFs up to 50 MB open. Only the reading rules and export choices you set are remembered on this device, never the file, its text or your guides.
    How does it decide which column a piece of text belongs to?
    By the column guides: vertical lines placed in points from the left of the page as shown. Each piece of text goes to the column holding most of its width. Guides are suggested in the middle of every gap that no text crosses for at least 0.6 text heights, ignoring lines that hold a single piece of text such as a title; you can drag them, tap the page to add one, or type exact positions. Text that crosses a guide is flagged for checking or, if you choose Split at spaces, divided at its spaces with the word positions estimated.
    Will numbers like 1,500 or 0012 change?
    No. Each cell holds the characters the PDF's text layer holds, in order: a space goes between two pieces of text set apart on the page, and spaces at the start and end of a cell are dropped. 1,500 stays 1,500 and is quoted in the CSV. The XLSX writes every cell as text unless you choose Plain numbers as numbers, which converts only numbers such as 240 or 3.25 that read back digit for digit, so 1,500 and 0012 stay text. Text that starts like a spreadsheet formula, such as =SUM(A1), gets an apostrophe in the CSV unless you turn that off; a number such as -1,500 never does.
    What happens to an empty cell?
    It stays blank. A row with a missing value keeps its other values in their own columns, so nothing shifts left, and a label printed once for several rows is not copied down. The readout counts the blank cells and the grid marks each one.
    What about cells that wrap onto two lines?
    By default every line of text is its own row. Choose Join wrapped lines and pick a column that has text on the first line of every row, such as a code or a date: a line with nothing in that column is joined to the row above, each cell's text after a space, and the cell's details say how many lines it joins.
    Can I extract a table that runs over several pages?
    Yes. Choose Every page to apply the same region and guides to each page, combining the extracted rows in page order into one CSV or one XLSX sheet. Repeated headers remain rows; they are not detected and removed. Pages without text add nothing and are reported. Different table layouts may need separate exports with different guides. Multiple PDF files are not processed together as a batch.
    Does it work on rotated pages?
    Yes. Text is placed on the page as it is shown, after the page's own rotation, and Auto reads each page in the turn in which most of its text runs left to right, so a landscape table on a turned page comes out in its proper rows and columns. You can also pick the turn yourself.
    How do I convert a PDF table to Excel instead of CSV?
    Choose a PDF with a text layer, select the table region and adjust its column guides. Check the grid and correct any misplaced values, then press .xlsx to download an Excel workbook with one sheet named Table. The .csv button exports the same grid as comma-separated text. Both formats include your applied cell corrections. There is no account or email step.
    How do I copy a PDF table into Excel or Google Sheets and keep the columns?
    Set the region and guides so the preview has the columns you want, then use Copy to copy tab-separated text and paste it into your spreadsheet. For codes with leading zeros, the .xlsx download with XLSX: all as printed text is more reliable than pasting, because a spreadsheet may interpret pasted values as numbers or dates. There is no direct Google Drive connection or automatic spreadsheet import.
    Will it keep the original formatting, formulas and merged cells?
    The output is a grid of cell values, not a recreation of the original spreadsheet. Fonts, borders, images, charts, formulas and merged-cell structure are not recovered. A table with regular columns is easier to extract than a complex layout. Use the source boxes and cell editor to check alignment, empty cells and wrapped lines before using the result.
    Can I convert bank statement tables to CSV?
    If the PDF has a readable text layer, you can use the column guides to extract its printed transaction table and correct cells manually. Scans need OCR first. The tool does not reconcile balances, validate amounts, identify accounting fields or prepare a QuickBooks, Xero or Tally import template. Check every extracted value against the source; a CSV download alone does not establish that an accounting import is correct.
    Can I turn CSV or Excel files into a PDF?
    Use Spreadsheet Converter for the reverse direction. It opens CSV, TSV and XLSX files and can export a paged table PDF from a selected sheet. Its PDF contains cell values with basic table layout; it does not reproduce workbook charts, styles or merged cells. This table extractor only accepts PDF input.
    Can it read a PDF form, a chart or thousands of pages automatically?
    It reads positioned text from PDF pages into a table using your guides. It does not extract form fields by name, infer chart data or identify key fields with AI. The PDF limit is 50 MB, with bounded text and cell counts; any pages that could not be read are reported. There is no guarantee that a 5,000-page file will be fully extracted. Review the page summary and exported rows.

    Reads only the text layer a PDF already has, placing each piece of text by where it sits between the column guides you set: nothing is recognized from images, so a scanned page reports that it has no text. Blank cells stay blank and numbers keep the characters the text layer holds, never filled in or recalculated, while merged or irregular layouts can land in the wrong cell, so every cell links to its source box for checking and your corrections go straight into the CSV and XLSX. PDFs up to 50 MB are read on your device and never uploaded.