# Convert PDF to Excel Using Word's PDF Reflow

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2024-12-15
- Updated: 2024-12-15
- Category: PDF to Excel basics
- Canonical: https://www.fastbankconvert.com/blog/convert-pdf-to-excel-using-word

> Convert PDF to Excel using Word: open the PDF in Word, let it rebuild the tables, then copy them across. What reflow keeps and where it falls apart.
To convert a PDF to Excel using Word, open the PDF in desktop Word, which rebuilds the pages as an editable document, then copy each rebuilt table and paste it into Excel. Clean tables with ruled borders usually come through cell for cell. Dense or borderless layouts often arrive as loose text that you split by hand.

## What does Word do when it opens a PDF?

When Word opens a PDF, it reads the fixed page and writes a new Word document from it, a process Microsoft calls PDF reflow. Microsoft's page on [adding a PDF to an Office file](https://support.microsoft.com/en-us/office/add-a-pdf-to-your-office-file-74819342-8f00-4ab4-bcbe-0f3df15ab0dc) says Word turns paragraphs, lists and tables into editable content, "preserving as much of the layout information as it can."

The PDF itself is not changed. Word makes a separate document, and you can save it as a .docx file or simply copy from it and close it. Think of Word as a translator that sits between the PDF and Excel. It does the hard part, deciding which bits of text form a table, and Excel receives something that already has rows and cells.

The same Microsoft page names Word 2013 and 2016 as having the feature. If you use a newer Word, try it; if Word offers to convert the PDF when you open it, you have it.

Word can only rebuild what the PDF contains as text. A scanned page is a picture, and Word has no table to find there. Try selecting a word in the PDF reader first. If you cannot, this route will not help.

## Steps to convert a PDF to Excel using Word on a desktop

The whole route takes a handful of steps: open the PDF in Word, confirm the conversion, check each table, copy it, and paste it into Excel. On a short report with two or three tables, it takes a few minutes. Most of the time goes into checking, not clicking.

1. **Open Word first**, then choose File, Open and pick the PDF. Opening from inside Word avoids the PDF opening in a reader by habit.
2. **Confirm the message** that Word will convert the PDF into an editable document. A long file can take a while, and Word may look frozen until it finishes.
3. **Turn on gridlines.** Click in a table, then use the Layout tab next to Table Design and select View Gridlines. Now you can see where Word drew the cell edges, including invisible borders.
4. **Find each table.** Scroll through. Note which pages have real tables and which have aligned text that only looks like one.
5. **Select one table** by clicking the small four-way arrow at its top-left corner.
6. **Copy** with Ctrl+C on Windows or Cmd+C on a Mac.
7. **Paste into Excel.** Click the top-left cell where the table should start and paste. Each Word cell lands in its own Excel cell.
8. **Repeat** for each table, pasting below the last one or on a new sheet.
9. **Close the Word document** without saving, unless you want the .docx for later.

Paste each table into its own place first, even if they belong together. Joining them afterwards is easier than untangling two tables pasted on top of each other.

## Word tables versus tab-separated lines after PDF reflow

Word gives you one of two things for each table: a real Word table, with cells you can click into, or lines of text with tab characters between the columns. Click inside it. If the Table Design tab appears on the ribbon, it is a real table. If not, it is text, and it needs a different paste.

A real table is the good case. It pastes into Excel as a grid, and the only work left is checking values.

Tab-separated lines are the second-best case. Paste them into Excel and look at column A. If everything sits in one cell per line, select column A, choose Data, Text to Columns, pick Delimited and tick Tab. Because Word used tabs rather than spaces, a product name like "Steel hinge 75mm" stays in one cell.

A third case also turns up: text boxes. Word sometimes places each block of text in a floating box to match the PDF's look. You cannot select a column of text boxes in one go. When you see boxes with handles around them, the reflow did not find a table, and you are better off with another route.

The table below sums up what reflow tends to keep. It describes typical results; check your own file.

| PDF layout | Typical result in Word |
| --- | --- |
| Table with ruled borders | Real Word table, cells intact |
| Borderless columns aligned by spaces | Tab-separated lines or text boxes |
| Merged heading over several columns | Merged Word cell, which becomes a merged Excel cell |
| Table running over a page break | Two tables, header repeated on the second |
| Footnote markers in cells | Kept as text, such as "12.40*" |
| Logos and images | Pictures in the document, not in table cells |

## Does pasting a Word table into Excel keep numbers as numbers?

Usually, yes. Excel reads each pasted cell and turns plain figures like 1,240.50 into numbers. Trouble starts with anything that is not a plain figure: an amount with a footnote star, a code with leading zeros, a date in a format your Excel does not expect, or a merged cell from a heading.

Check four things straight after the paste:

- **Alignment.** Numbers sit at the right of a cell by default, text at the left. A left-aligned amount is text.
- **Leading zeros.** A product code like 00412 becomes 412. If codes matter, format the target column as Text before you paste. Price lists suffer most from this, and [keeping product codes intact from a PDF price list](/blog/convert-pdf-price-list-to-excel) covers the fixes.
- **Dates.** A date like 03/07/2026 may be read as 7 March or 3 July depending on your system's region. Compare one row with the PDF.
- **Merged cells.** A heading merged across three columns arrives merged in Excel, and merged cells break sorting. Select the range and choose Merge & Center again to unmerge it.

Times are a special trap. A schedule cell reading "9:00–17:30" stays as text, because Excel cannot read a range as one time. [Converting a PDF schedule or roster](/blog/convert-pdf-schedule-to-excel) explains how to split those into start and end times.

### Keep Source Formatting or Match Destination?

When you paste, Excel offers paste options. Keep Source Formatting brings Word's fonts and borders. Match Destination Formatting brings the values in your sheet's style. For data work, choose Match Destination, which leaves you with plain cells you can format yourself.

## PDF layouts that Word reflow mangles

Word reflow is a layout guess, and some PDFs defeat it. Statements with narrow columns, forms with labels and boxes, and pages with two tables side by side tend to come back scrambled. If the first table you check is wrong in more than a couple of places, stop: fixing reflow output by hand is slower than another route.

Signs the guess went wrong:

- A date and a description share one cell, or a description is split across two.
- Rows from two side-by-side tables are interleaved.
- Numbers in a column are offset by one row from their labels.
- A page shows dozens of text boxes instead of a table.
- A rotated page, such as a landscape table in a portrait file, comes back with its text in the wrong order.

Microsoft's own page notes that conversion "works best with PDFs that are mostly text." That is a fair hint that dense, grid-heavy files are not its strength. For those, a dedicated converter or Excel's PDF import in Microsoft 365 usually does better. Bank statements are a typical example: FastBankConvert is getting ready to open as a converter built for them, and [Get started](/get-started) is where to join.

### Do not edit numbers in Word

It is tempting to fix a wrong figure in the Word document before copying. Make the fix in Excel instead, after the paste, with the PDF open beside you. Edits in Word are easy to lose when you close it without saving. A fix in Excel also leaves a trace you can check later, for example in a note beside the cell saying which page of the PDF it came from.

## Word for the web as a PDF reflow route

Word for the web, the browser version that comes with a Microsoft account, can also open a PDF and convert it. Microsoft's page says the converted document "may not look exactly like the original," with line and page breaks in different places. Tables can still come through, and you copy them into Excel the same way.

This route helps when desktop Word is not installed, or on a computer where you cannot install anything. Open the PDF in Word for the web, accept the conversion to an editable document, and wait for it to finish. Then copy tables into Excel for the web or a desktop Excel.

On a Mac, desktop Word and the Mac's own tools are both options, and [the Mac routes from PDF to Excel](/blog/convert-pdf-to-excel-mac) compare them. On a phone, Word for the web in the browser is the route to try, and saving the result can be fiddly. If the converted file or the Excel download never appears, [phone browsers that do not download files](/blog/phone-browser-not-downloading-files) lists the usual causes.