How to Convert PDF to Excel: Pull Tables Out of Statements, Price Lists and Reports Without Retyping

A supplier sends a price list as a PDF. Your bank statement only downloads as a PDF. A college or office report has a table of marks or sales figures that you need to sort, total or compare. You try copying the table out of the PDF and pasting it into Excel, and everything lands in one column, or the numbers come across as text that will not add up.

Retyping is slow and it is where mistakes creep in. A better route is to convert the PDF to an Excel file, then spend a few minutes checking the result. This guide shows how to do that, which PDFs convert well, and the common mistakes to avoid. It is written for small business owners, students and sellers who just want the numbers in a spreadsheet.

Why copy and paste scrambles PDF tables

A PDF does not really store a "table". It stores pieces of text and where each piece sits on the page. What looks like a neat grid to you is, inside the file, a list of words with positions. When you copy and paste, most apps throw the positions away, so the grid collapses.

A PDF to Excel converter works the other way round: it reads the position of every piece of text, groups pieces that sit on the same line into a row, and lines up pieces that start at the same horizontal position into columns. That is why clearly laid-out tables convert well and messy ones need more cleanup.

Step-by-step: convert a PDF to Excel

You can use the free PDF to Excel converter from PKD Ventures. Here is the routine:

1. Check that your PDF has selectable text. Open it and try to highlight a few words with your mouse. If you can select them, it is a text-based PDF and it will convert. If the whole page behaves like one picture, it is a scan (more on that below).
2. Add the PDF to the tool. The converter handles PDFs of up to 300 pages. If yours is longer, split it first and convert only the pages that hold the table.
3. Choose how the sheets are laid out. There is one option: One sheet per PDF page. With it ticked (the default), page 1 goes to a sheet called "Page 1", page 2 to "Page 2", and so on. Untick it and everything goes into a single sheet called "PDF data", with a blank row between pages.
4. Click "Convert to Excel". You will see progress as each page is read.
5. Download the .xlsx file. The result message tells you how many sheets and cells were created, along with a reminder to check the layout.
6. Open it in Excel, Google Sheets or LibreOffice and review it. Do not skip this step. The checklist below takes a few minutes and saves a lot of trouble later.

Which layout option should you pick?

One sheet per page is the safer choice when:

• Each page has a different table (for example, a summary on page 1 and details on page 2).
• You want to compare the Excel output against the PDF page by page.
• The column positions change from page to page.

A single sheet is handier when:

• The same table simply continues across many pages, like a long bank statement or a price list.
• You plan to sort or filter the whole lot in one go.

If you use a single sheet, remember that repeated header rows from each page and the blank separator rows will also be in the data. Filter or delete them before you total anything.

What happens to numbers

Values that look like plain numbers are stored as real numbers in the spreadsheet, not as text. That includes numbers with thousands separators, such as 1,234.50 or Indian-style 1,23,456, and negative numbers like -12. This means you can use SUM, sort from smallest to largest and build charts straight away.

A few things are deliberately kept as text:

• Codes with a leading zero, such as a PIN code, an item code like 00452 or an account number starting with 0. Keeping them as text stops the leading zeros from vanishing.
• Very long digit strings (more than 15 digits), such as some account or card-style numbers, because a spreadsheet would round them if they were stored as numbers.
• Anything with symbols or letters mixed in, such as ₹1,200, 45% or 12 kg. These come across as text, so if you need to calculate with them, use Excel's Find and Replace to remove the symbol, then convert the column to numbers.

Tips for cleaner results

• Start from the original PDF, not a photo or a printout. A PDF exported from accounting software, a bank portal or a billing app usually has clean, selectable text and converts best.
• Convert only the pages you need. If the table is on pages 4 to 9 of a long report, extract or split those pages first. You will get a smaller, tidier workbook.
• Keep the PDF open next to the spreadsheet while you check. Compare a few rows from the top, middle and bottom of each page.
• Check the totals. If the PDF shows a total, add up the same column in Excel with SUM and compare. A match is the quickest proof that nothing went missing or shifted.
• Use Excel's tools for the final polish. Freeze the header row, set column widths, apply a number format and add filters once the data is in place.
• Need a plain data file afterwards? If you are importing the data into another system, convert the finished workbook to CSV with the XLSX to CSV converter.

Common mistakes to avoid

1. Trying to convert a scanned PDF. A scan is just an image of a page, so there is no text for the converter to read. You will get a message saying no selectable text was found. For scans, run OCR (text recognition) first. The PDF to Word converter can read scanned PDFs with OCR and give you editable text, which you can then tidy into a table.

2. Expecting perfect structure from complex tables. The converter rebuilds rows and columns from where the text sits, so some layouts need cleanup:

• Merged cells and headings that span several columns.
• Cells where the text wraps onto two or more lines. Each line can become its own row.
• Rotated or vertical text.
• Right-aligned number columns, where values of different lengths start at slightly different positions and can drift into a neighbouring column.

None of these are deal-breakers. They just mean you should plan for a quick review rather than assume the file is ready to use.

3. Not checking for shifted cells. On a line, if two pieces of text would land in the same column, the second one moves one column to the right rather than overwriting the first. That keeps every value, but it can push part of a row out of line. Scan each column for values that look out of place, like a date in the amount column.

4. Forgetting about header and footer text. Page headers, footers, page numbers and notes are text too, so they come across as rows. Delete them before sorting or totalling.

5. Retyping when you could fix in bulk. If a whole column came across as text because of a currency symbol, do not retype it. Use Find and Replace to strip the symbol, then use Excel's "Convert to Number" option on the column.

Wrapping up

Converting a PDF to Excel is not magic, but for clearly laid-out, text-based tables it turns an hour of retyping into a few minutes of checking. Convert, compare a few rows against the original, check the totals and you are ready to sort, filter and analyse.

The PDF to Excel converter is one of the free tools on PKD Ventures, alongside converters for PDF, image, audio and video files. If you find yourself converting the same reports every week, that is usually a sign the process itself could be automated, which is the kind of custom software we build.