# PDF table to Excel: fix the rows before you export

> See an invoice extraction that missed the item rows, repair the five-column table, and check the downloaded XLSX or CSV.

[Read this guide in Edit PDF Pages](https://editpdfpages.com/guides/pdf-table-to-excel/)

Content updated: 2026-10-12. Example checked 12 October 2026 in Chrome 155 on macOS.

This invoice appears to be an easy conversion: three items, five columns and a total of 55.00. The extractor finds the total but misses every item. Here is how to catch that incomplete result and repair this small table before downloading it.

Open the fictional [invoice](https://editpdfpages.com/guides/examples/invoice-table.pdf) in the [PDF workspace](https://editpdfpages.com/). Choose **Extract table**, leave **Extract from** on **Current page**, then choose **Extract table** inside the dialog.

## What the first extraction returned

The preview contains **four rows and two columns**: Subtotal, Tax, TOTAL USD and a footer. The extractor selected the totals block instead of the item table. Exporting now would save those four rows, without the three invoice items.

![Initial extraction shows only Subtotal, Tax, TOTAL USD and a footer, with no item rows](https://editpdfpages.com/guides/images/pdf-table-to-excel-before.png)

The total is present; all three item rows are missing.

For this short invoice, entering the missing rows is manageable. On a long invoice, the same result could mean substantial transcription. Inspect the preview before deciding whether extraction will save you work.

## Rebuild the six rows

1. Remove the footer with the × button at the end of its row.
2. Use **Column** three times to make five columns.
3. Use **Row** three times to make six rows.
4. Click the cells and replace their contents with the values below. Include the headings as the first row; leave delivery quantity and unit price blank.

| Item | Description | Qty | Unit price | Amount |
| --- | --- | --- | --- | --- |
| 01 | Notebook set | 2 | 12.00 | 24.00 |
| 02 | Archival sleeves for A4 project notes | 3 | 8.00 | 24.00 |
| 03 | Delivery |  |  | 7.00 |
|  | Tax |  |  | 0.00 |
|  | TOTAL USD |  |  | 55.00 |

## Check the description, blanks and total

The two printed lines of **Archival sleeves for A4 project notes** belong in one cell. Keep the empty delivery cells empty; a blank quantity does not mean zero. Then compare each amount and the 55.00 total with the invoice. A matching total cannot tell you whether an amount ended up beside the right description.

These checks apply to other tables too. Extraction follows text positions, so wrapped descriptions can become extra rows and blank cells can shift neighboring values into the wrong column.

## Save the repaired table

Choose **Export Excel** for XLSX or **Export CSV** for a plain table. Open the result in your spreadsheet app and check the columns and values before sorting or adding formulas. Edit PDF Pages edits cell values; it does not calculate spreadsheet formulas.

**Download the sheet before leaving or changing the PDF.** Table edits are temporary. They are not included in a **.folio** project, autosave or undo history.

If no readable text is found, [run English OCR](https://editpdfpages.com/guides/make-scanned-pdf-searchable/) first and compare recognized numbers with the image. Pages with redactions or replacement edits are excluded entirely from extraction, so concealed source values do not pass into the sheet. Added notes are not source table data either.

## Worked example

![Manually corrected six-row invoice table with five columns, full item descriptions and a total of 55.00](https://editpdfpages.com/guides/images/pdf-table-to-excel.png)

The missing item rows were entered from the fictional invoice. The downloaded XLSX contains the joined description and numeric 55.00 total; the initial extraction alone was incomplete.

## Related guides

- [Bank statement PDF to Excel: check dates, amounts, and missing rows](https://editpdfpages.com/guides/bank-statement-to-excel/)
- [How to make a scanned PDF searchable](https://editpdfpages.com/guides/make-scanned-pdf-searchable/)

These guides were prepared with AI assistance and checked using fictional documents. Examples contain no real customer or account data. See each guide's example for the workflow and its limits.