# Add PDF Data to Existing Excel Sheet Without Breaks

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: PDF to Excel basics
- Canonical: https://fastbankconvert.com/blog/add-pdf-data-to-existing-excel-sheet

> Add PDF data to an existing Excel sheet without breaking formulas: match the columns first, append below the table, and check that totals still add up.
To add PDF data to an existing Excel sheet safely, convert the PDF on a separate sheet first, rearrange its columns to match yours, then paste the rows directly below your table. Before and after, note the row count and the total of the amount column, so you can prove every new row arrived once and nothing old moved.

## Why does pasting PDF data into an existing sheet break formulas?

Pasting PDF data straight into an existing sheet breaks formulas for three reasons: the pasted columns are in a different order, so values land under the wrong headings; the paste overwrites cells that formulas use; or the new rows fall outside the ranges your totals and lookups cover. All three are silent until a number looks wrong.

Picture a running cost sheet with Date in column A, Supplier in B, Amount in C and a VAT formula in D. A converted PDF invoice list has Supplier first, then Invoice number, then Date, then Amount. Paste it at the bottom and suppliers sit under Date, dates under Amount, and the VAT formula multiplies a date serial number. Nothing warns you.

Then there are the formulas themselves. A total written as `=SUM(C2:C200)` stops at row 200. Paste 30 rows at row 190 and the last 20 are left out of the total. A lookup over a fixed range has the same blind spot.

The cure for all three is the same habit: never paste a PDF conversion straight into the sheet you care about. Land it on a scratch sheet, fix it there, and move only clean rows across.

Before you start, make sure the PDF really belongs in a spreadsheet. If it is mostly paragraphs with a few figures, [choosing between Excel and Word for a PDF](/blog/pdf-to-excel-or-word) helps you decide.

## Matching PDF columns to the existing sheet's headings

Matching columns means making the converted data look exactly like your sheet before it goes anywhere near it: same headings, same order, same types. Write down your sheet's columns, find each one in the PDF data, then move, merge, split or add columns on the scratch sheet until they line up.

A mapping table makes this quick to do and easy to repeat next month. Here is an invented example for the cost sheet described above:

| Existing sheet column | Comes from PDF column | Fix needed |
| --- | --- | --- |
| A: Date | Invoice date (third column) | Move to first; check day and month order |
| B: Supplier | Supplier (first column) | None |
| C: Amount | Total incl. tax (fourth column) | Remove currency symbol; make it a number |
| D: VAT | Not in PDF | Leave empty; the sheet's formula fills it |
| E: Invoice no. | Invoice number (second column) | Set to Text to keep leading zeros |

Columns that exist only in the PDF, such as a page reference, should be deleted unless your sheet has a place for them. Columns that exist only in your sheet, such as a calculated VAT, should be left blank in the scratch data so your own formula fills them.

### Types matter as much as order

A date that arrives as text sorts wrong and falls out of date filters. An amount that arrives as text drops out of SUM without an error. After the reshuffle, check each column on the scratch sheet: numbers and dates sit at the right of the cell, text at the left. Fix any column that is wrong before moving on.

If the PDF had logos or product photos you want to keep, those will not come through the conversion. [What happens to images when a PDF goes to Excel](/blog/convert-pdf-to-excel-with-images) explains how to add them separately.

## Appending PDF rows below an Excel table, not beside it

New rows belong directly beneath the last row of your data, with no blank row between. If your data is an Excel table, created with Insert, Table or Ctrl+T, the table grows to include rows pasted right below it, and formulas that refer to the table pick them up automatically.

Turn your existing range into a table first if it is not one. Click inside the data, press Ctrl+T, confirm that it has headers, and choose OK. Then any total written as `=SUM(Table1[Amount])` covers every row, today and after every future append. Fixed ranges like C2:C200 are the main cause of totals that quietly stop counting.

To append:

1. On the scratch sheet, select the cleaned rows only, without the heading row.
2. Copy them.
3. On your sheet, click the first cell of the empty row directly under the table.
4. Use Paste Special, Values, so the scratch sheet's formats and any leftover formulas do not come across.
5. Check that the table's banded formatting now runs to the new last row. If it does, the table expanded.

Pasting beside the table, or below a blank row, leaves the new rows outside it. They look like part of the list, but the table's formulas ignore them.

### Calculated columns fill themselves

If your table has a calculated column, such as the VAT formula, Excel fills it down into the new rows as soon as they join the table. Leave that column blank in what you paste, or your pasted blanks may overwrite the formula in those rows.

## Do the existing sheet's totals still add up after the PDF rows?

You can prove it with two numbers taken before and after: the row count and the amount total. The total after the append should equal the old total plus the PDF's total, and the row count should grow by the number of rows in the PDF. Any difference means a row was lost, doubled or misread.

Here is a worked example with invented figures:

| Check | Rows | Amount total |
| --- | --- | --- |
| Existing sheet before append | 412 | 58,930.40 |
| PDF data on the scratch sheet | 27 | 6,115.75 |
| Expected after append | 439 | 65,046.15 |
| Actual after append | 439 | 65,046.15 |

Use `=ROWS(Table1)` for the count and `=SUM(Table1[Amount])` for the total, and note both before you paste. If the actual figures differ from the expected ones, undo the paste and look at the scratch sheet again.

The PDF's own total is the other half of the check. Compare the scratch-sheet total with the total printed in the PDF before you append anything. If those two disagree, the conversion lost something, and the problem is upstream of your sheet. For scanned PDFs this is common, because text recognition can misread digits; [reading a scanned PDF into Excel with OCR](/blog/ocr-pdf-to-excel) covers what to watch for.

## Duplicate rows when the same PDF is added twice

Adding the same PDF twice is easy to do and hard to spot, especially when statements or invoice lists overlap by a few days. The safeguard is a column that records where each row came from, plus a quick duplicate check before every append.

Add a Source column to your table, such as "Supplier list 2026-09.pdf". Fill it on the scratch sheet before you paste. Later, a filter on Source shows at once whether a file was already added.

For overlapping periods, check for repeated rows directly:

1. Add a helper column that joins the fields that make a row unique, for example `=[@Date]&"|"&[@Supplier]&"|"&[@Amount]`.
2. Use `=COUNTIF([Key],[@Key])` in the next column.
3. Filter for values greater than 1.

Some real duplicates are legitimate, such as two identical coffee purchases on one day. The check flags them for a look; it does not prove they are errors. Decide each one against the PDF.

### Overlapping periods in statements and reports

Overlaps are the usual source of honest duplicates. A report covering 1 to 30 September and a later one covering 25 September to 24 October share six days of rows. Before appending the second, filter the scratch sheet to dates after the last date already in your table, and append only those. Then run the count and total check against the filtered rows, not against the PDF's full total, and write the cut-off date in the Source column so the next person sees why the numbers differ from the printed total.

## Can a query append each new PDF to the existing sheet?

Yes, if you have Excel's PDF import, which is part of Microsoft 365 on Windows. You build a query that reads the PDF, shapes its columns to match your table, and appends the result to your existing data. Next month you point it at the new file and refresh, and the shaping repeats exactly.

The outline: import the PDF with Data, Get Data, From File, From PDF, do all the column fixes from the mapping table in the Power Query editor, then use Append Queries to stack it under a query of your existing table. The column names must match exactly, or the append creates new columns full of blanks.

The PDF import is not available everywhere. On a Mac, [the ways to convert PDF to Excel on a Mac](/blog/convert-pdf-to-excel-mac) explain the alternatives, which then feed the same paste-and-check routine above.

For bank statements, FastBankConvert is being built to return statement rows as Excel or CSV with dates, descriptions, amounts and balances in their own columns, which keeps the mapping step short. It is getting ready to open, and you can join at [Get started](/get-started).