Copying a table from a PDF and pasting it into Excel usually gives you a mess: everything lands in one column, numbers become text, and rows break in odd places. A PDF to Excel converter does the job properly by working out where the columns are.

Before you start: is the table real text?

Open the PDF and try to select a single number in the table. If you can, the PDF contains real text and will convert well. If the whole page highlights as one picture, it’s a scan. Scanned tables need OCR (text recognition) before any converter can read them.

PDFs downloaded from online banking, accounting software, and anything exported from Excel or Word almost always contain real text.

Converting step by step

  1. Open PDF to Excel and add your PDF.
  2. Choose One sheet per page to keep pages separate, or All on one sheet if your table runs across several pages and you want one continuous list.
  3. Click Convert and open the .xlsx file in Excel, Google Sheets or LibreOffice.

The converter looks at where each piece of text sits, groups text that lines up vertically into columns, and keeps each line of the page as a row. Titles and notes above or below the table go into the first column, so nothing is lost.

Numbers that work in formulas

A common problem with copy and paste is that numbers arrive as text, so SUM gives 0. Convertpdfly turns amounts into real numbers: “Rs 12,500.00” becomes 12500, “-450” becomes -450, and “8%” becomes 0.08. You can total a column or sort by amount straight away.

Some values look like numbers but shouldn’t be treated as numbers. Account numbers, phone numbers and CNIC numbers often start with zero or are very long, and Excel would round or reformat them. These are kept as text so they stay exactly as printed.

Cleaning up the result

Every PDF is laid out differently, so expect to spend a minute or two tidying. Here are the quick fixes:

  • Two columns in one cell. When columns are printed very close together, the PDF can store them as one piece of text. Select the column, choose Data, Text to Columns, pick “Delimited” and split on spaces.
  • Header rows repeated on every page. With “All on one sheet”, page headings appear several times. Turn on a filter (Data, Filter), filter the first column for the heading text, and delete those rows.
  • Extra rows for page numbers and footers. Delete them, or filter them out the same way.
  • Dates as text. Select the column and use Data, Text to Columns, then choose the Date format that matches (for example DMY).

Bank statements

Turning a bank statement into a spreadsheet makes budgeting much easier: you can add a category column, sort by amount, and total what you spent on each thing in a month. Bank statements are often password protected. If yours is, remove the password first with Unlock PDF, using the password the bank gave you.

Because statements contain sensitive financial details, avoid converters that upload your file. Convertpdfly converts in your browser and the file never leaves your device.

When Excel isn’t the right choice

If your PDF is mostly paragraphs with a few small tables, convert it to Word with PDF to Word instead; tables become Word tables. If you only need to copy text, PDF to Text is fastest. And when your spreadsheet is ready to share again, Excel to PDF turns it back into a neat PDF.