Get PDF tables into real Excel cells

A price list you need as numbers, not pictures

Marta runs purchasing for a small catering firm. Every January her main supplier emails a 14 page PDF price list, catalog_2026.pdf, with one table per product group: codes, pack sizes, unit prices. Her job is to compare 200 of those prices with last year and flag any rise above 5 percent. Retyping the numbers would take a full day and invite typos, and copying from the PDF pastes the columns as one jumbled block.

Her list is a good candidate for conversion. It was exported from a computer, so every price is selectable text sitting in neat rows. She opens the PDF to Excel tool, picks the 14 tables, and downloads a workbook with 14 sheets named after the source pages. The numbers arrive as text she can turn into values, sort, and run through her comparison formulas. Total time: about twenty minutes, most of it checking.

Before you start, run the same two checks on your own file. Try selecting one sentence with your mouse: if the words highlight, the page has the text layer the detector needs. Then look at how the table is built: straight rows with aligned columns convert cleanly, while merged headings, rotated pages, and tables drawn as artwork need manual repair afterward. Those are normal, and the sections below cover them.

What makes it into the workbook

A PDF stores words at fixed positions on a page, not spreadsheet cells. The tool looks for text that lines up into repeated rows and columns, then writes what it finds into sheets. This table sets expectations before you press the button.

Pull the tables out in your browser

1. Open PDF to Excel and choose the PDF, or drop the file onto the page. The file stays in this browser tab; nothing is uploaded.
2. Wait while the tool reads the pages and groups aligned text into tables. A summary tells you how many tables it found and on how many pages.
3. Review the list of detected tables. Every one is selected by default, so deselect anything you do not need, such as a table of contents or a footer that lined up by accident.
4. Press Convert to Excel. Each selected table becomes its own visible worksheet inside one XLSX file, with every value stored as text.
5. Compare the receipt: the source PDF page sits next to the first worksheet, with an outline marking the text used for that sheet. Check rows and columns against the original before you trust the numbers.
6. Behind the scenes the workbook is reopened and its sheet names, rows, and cells must match the detected tables, with no macros, formulas, external links, or hidden sheets. Press Download Excel for the verified file.

Name the download so you know its source, for example catalog_2026_tables.xlsx, and keep the PDF next to it. When a number looks odd later, you will want the original page within reach.

Table slips and how to fix them

• Numbers arrive as text and will not sum. Every cell is stored as text on purpose, so totals fail until you convert the column. Select it in Excel, switch the format to Number, and retype or re-enter any value that keeps its leading spaces.
• A heading spans two columns in one cell. A merged title cannot belong to one column cleanly, so it lands in a single cell. Cut it apart by hand and check the columns under it against the PDF page.
• Two tables merged into one sheet. Tables stacked close together can look like one block of alignment. Split the sheet rows in Excel, or convert again with a trimmed PDF that holds only one table per page.
• Dates and decimals look wrong. A PDF writes what it shows, so 02/03/2026 and 1.234,56 arrive exactly as printed. Tell Excel which locale the source used before converting the columns, or the values will shift.
• The tool found no tables at all. Either the pages are scanned images with no text layer, or the layout never aligned into rows. If selecting text fails, the file needs OCR first; if the table uses artwork lines with scattered labels, retyping may be faster.
• The workbook is too wide to read. Wide catalog tables land as wide sheets. Freeze the top row in Excel and hide columns you do not need rather than deleting them, so a later check still has the full data.

When a converter is the wrong move

Some tables convert so badly that another route wins. A scanned price list photographed at an angle needs OCR and cleanup first, and if only six numbers matter, retyping them takes less time than repairing a whole sheet. Ask the sender for the original spreadsheet too: a supplier who exported the PDF usually still has the XLSX, and that file keeps formulas, sheet names, and formatting no converter can rebuild.

When you need plain data for a script or a database import rather than a workbook, PDF to CSV uses the same detection but saves CSV files instead. When the PDF holds running text with only an occasional table, PDF to Markdown keeps the structure of the prose, and the PDF to Word guide explains the editable document route. If the reader only needs to see the pages inside a spreadsheet, attaching the PDF to the workbook skips conversion entirely.