How to convert a PDF report to Excel without retyping it

Your system prints the report as a PDF. Your boss wants it in Excel. Here are five ways to get it there, what each one is good for, and which to use when the same report comes back every week.

Updated October 18, 2026 · 8-minute read

Before you start: can you select the text?

Open the PDF and try to highlight a few words with your mouse. If the text highlights, the PDF has real text in it, and every method below can work. Most reports printed or exported from business software (ERP, accounting, inventory, sales, work orders) are like this.

If nothing highlights, the PDF is a scan or a photo of paper. There's no text to read, only a picture of text, so it has to go through OCR (text recognition) first. Expect to check the numbers by hand afterward: OCR misreads digits often enough to matter in a financial report.

1. Copy and paste

Good for: a one-page table you need once.

1. Select the table in your PDF viewer and copy it.
2. Paste into Excel. If everything lands in one column, select that column and use Data > Text to Columns, splitting on spaces or a fixed width.

Where it breaks: anything longer than a page. You also get the page headers, page numbers and column titles again on every page, notes that wrapped onto a second line become extra rows, and names with spaces in them split across columns. On a 10-page report, the cleanup takes longer than retyping.

2. Open the PDF in Word, then copy the table

Good for: a few pages, once, when copy and paste scrambles the columns.

1. In Word, use File > Open and pick the PDF. Word converts it into an editable document (it warns you the layout may change).
2. If Word recognized the report as a table, click inside it, select the whole table, copy it and paste it into Excel.

Where it breaks: Word guesses where the table is. Columns can shift, and each page often becomes its own table, so the repeated headers and subtotals still have to come out by hand.

3. Excel's Get Data from PDF (Power Query)

Good for: clean, regular tables, and people comfortable with Power Query.

Excel for Microsoft 365 on Windows can read tables straight out of a PDF. At the time of writing, this connector isn't available in Excel for Mac.

1. Go to Data > Get Data > From File > From PDF and pick your file.
2. The Navigator lists what Excel found: Table items (tables it detected) and Page items (everything on a page). Click each one to preview it. By default, similar tables on consecutive pages are combined into one table.
3. Choose the one that looks right and click Transform Data to clean it in Power Query, or Load to drop it straight into a sheet.
4. In Power Query, use Use First Row as Headers, remove the rows you don't want, and set the column types. Then Close & Load.

Next week: save the new PDF over the old one (same name, same folder) and use Data > Refresh All. The query reruns on the new file.

Where it breaks: real-world reports. Repeated header rows, page totals sitting between the data, and notes that wrap onto a second line all come through as junk rows, and a slightly different page layout can make Excel detect the table differently and break the query. Our Power Query cleanup guide walks through the fixes for each one.

4. Adobe Acrobat: Export PDF to Excel

Good for: people who already pay for Acrobat and need a quick conversion.

1. Open the PDF in Acrobat and choose Export a PDF (or File > Export To).
2. Pick Spreadsheet > Microsoft Excel Workbook and save.

Where it breaks: it copies the page as it looks. You get a faithful copy of the PDF, headers, page numbers, subtotals and all, in Excel. It's a conversion, not the report you were asked for, so the reshaping (filters, tabs, totals, highlights) is still yours to do every time.

5. A tool built for your report

Good for: the report that comes back every week, and needs reshaping, not just converting.

If you rebuild the same report on a schedule (open orders, aging, sales by item, open work orders), the real job isn't converting a PDF. It's turning that PDF into the workbook people actually read, with only the rows that matter, split the way they want and the problems highlighted.

That's what Wheelbarrow does. You drop in the PDF (or the Excel or CSV export), describe the report in plain words, for example "only orders on hold, a tab for each region, red after 5 days", and see it built from your own file before you pay. You keep a small tool that runs on your PC, even offline. Next week, drop in the new PDF and the finished workbook comes out in seconds. It reads every page, skips the repeated headers and footers, and joins wrapped notes back into the right row.

Which method should you use?

Converting a report once? Start with copy and paste or Word. Rebuilding the same report every week? That's the hour worth getting back.

More from Wheelbarrow