How to Turn a PDF Invoice List into a Spreadsheet

A supplier sent you a statement of account. Or your sales system made a report of open invoices. Either way, it's a PDF, and you need it in a spreadsheet. Then you can add it up, sort it by date and see what is still unpaid.

This guide shows a free way to do it by hand, and a quick way with Sheetsnap, which turns PDF tables into Excel.

Before you start

Open the PDF and try to highlight one invoice number.

If it highlights, the PDF has real text. You're good to go.
If you can only draw a box, the page is a scan. Ask the sender for the PDF their computer made, or for an Excel file.

Also check your own system first. Many accounting and sales programs can export the same list straight to Excel or CSV. Look for Export or Download next to the report.

The free way: copy and paste

This works for a short list.

Open the PDF and drag across the table to highlight it.
Copy it with Ctrl + C (Windows) or Command + C (Mac).
Open Excel, click cell A1 and paste with Ctrl + V or Command + V.
If each row lands in one cell, select the column. Click Data, then Text to Columns. Pick Delimited, tick Space, and click Finish.

The catch: customer names with spaces get split into extra columns. Long lists over many pages also bring headers and page numbers along. You'll need to tidy those by hand.

On Windows with Microsoft 365, you can also try Data, then Get Data, then From File, then From PDF.

The quick way: Sheetsnap

Sheetsnap finds each table in the PDF and keeps the columns in place.

Go to tools.ltd/sheetsnap.
Click Choose a PDF, or drag your invoice list into the box.
Press Make my Excel file.
Download the file and open it in Excel or Google Sheets.

Each table gets its own sheet. The numbers are copied as they are in the PDF, not guessed. Your file never leaves your device. The tables are read right in your browser, and nothing is uploaded.

Make the list useful

Once your invoices are in Excel, a few simple steps help a lot.

Make it a table. Click any cell in the list and press Ctrl + T (or Command + T on a Mac). Click OK. Now each column has a filter button.
Sort by date. Click the filter button on the date column and pick Sort Oldest to Newest. The oldest invoices come to the top.
Add up the total. Click the cell under the amount column and press Alt + = on Windows, or click AutoSum on the Home tab.
Show only unpaid ones. If there is a status column, click its filter button and tick only Unpaid or Open.
Check the total. If the PDF shows a total, make sure your sheet's total matches it.

Matching payments to your bank

To see which invoices have been paid, compare the list with your bank statement. MyBankToExcel turns a bank statement PDF into Excel too. Then you can put both lists side by side.

Frequently asked questions

What kind of invoice list does this work for?

Any PDF with a table of invoices or bills, like a statement of account from a supplier, a list of open invoices, or a sales report. The PDF needs real text, not a scan.

Can it read many separate invoice PDFs at once?

Sheetsnap reads the tables in one PDF at a time. It works best on a PDF that already lists many invoices in a table.

How do I add up only the unpaid invoices?

Use SUMIF. For example, =SUMIF(E:E,"Unpaid",D:D) adds the amounts in column D where column E says Unpaid. Change the letters to match your sheet.

Is my file uploaded?

No. Sheetsnap reads the tables right in your browser. Your file never leaves your device.