Docparser: Pull Invoice Data from PDFs into a Spreadsheet

Updated October 18, 2026. Built against the tool’s current screens and checked step by step. How we check this lesson

Many bookkeepers and office managers still retype vendor invoices: open the PDF, copy the vendor, the invoice number, the date and the total into a spreadsheet, check for typos, and do it again for the next one. Docparser (docparser.com) reads your PDFs and pulls the same fields out of each one into rows you can download as one spreadsheet. In this free business-case lesson you use a practice copy built from real Docparser screenshots, captured October 2026 on a free trial, to price the weekly retyping for a made-up accounting firm, make a parser from the Invoices template, check what it found, add the vendor name it missed, and download everything as a CSV. You can download the three made-up sample invoices we used and try the same steps on your own trial. This is my own lesson, not an official Docparser course.

Part of: AI for Accounting & Bookkeeping Firms (step 28 of 28)

Part of: AI for Finance Teams (step 17 of 17)

Part of: AI Apps Worth Knowing (step 42 of 42)

The business case: retyping vendor invoices every week

Picture Jordan, the office manager at Maple Lane Accounting, a made-up firm. Every week the vendor invoices arrive as PDFs: the print shop, the office supply company, the cleaners. Jordan opens each one and retypes the vendor, the invoice number, the date and the total into the bills spreadsheet, then checks for typos before anything is paid.

Here is the arithmetic, using example numbers you should replace with your own. About 120 vendor invoices a month at about 4 minutes each is 8 hours a month. With Docparser, checking the spreadsheet takes about 1 minute an invoice, or 2 hours. At $35 an hour that saves about 6 hours, or about $210 a month, and the totals come straight off the PDF instead of being retyped.

Who this is for, and what you need

Bookkeepers, office managers and finance assistants who key in invoices, bills or statements by hand. To follow along you need nothing: the lesson is a practice copy. To do it for real you need a Docparser account (the free trial is enough) and a few invoices. You can use our three made-up sample invoices, linked above.

A note on screens: these were captured in October 2026 on a free trial. Docparser changes its screens from time to time, so yours may look a little different.

Step 1: make a parser from the Invoices template

A parser is like a folder: it holds one kind of document and the rules for what to pull out of it. On the Getting Started page, click Create Document Parser. Our trial's top bar showed 0/50 Credits Used. Under Featured Parser Templates, click Invoices ("extract key data such as invoice number, due date, etc."). The SmartAI Parser next to it is marked Premium.

Give the parser a name under Name Your Parser, then click Use Template.

Step 2: upload the invoices

On Add Documents, drag your PDFs in or click Browse. It lists PDF, DOCX, DOC, PNG, JPG, TIFF, CSV, TXT, XLS and XML as supported formats. We uploaded the three sample invoices, saw 3 File(s) Uploaded, and clicked Continue to Next Step. The credits bar went to 3/50: one credit per document.

Step 3: check what it pulled out

The Invoices template made eight parsing rules: Invoice Number, Invoice Date, Account Number, PO Number, Phone Number, Email, Line Items and Totals. Open a rule to see its Filtered Result. Invoice Number found GL-2026-0931 on the cleaning invoice. Totals found net 600.00, tax 0.00 and total 600.00, with a confidence of 90. Both matched the PDF.

A window offering free setup assistance popped up the first time we opened a rule. No Thanks closes it. Check two or three results against the PDFs before you trust the whole parser.

Step 4: add the field it missed

The template had no rule for the vendor name. Click Add Parsing Rule, search the rule types for position, and pick Text Fixed Position ("extract text from a permanent location"). Rename the rule from Fixed Text to Vendor Name, because the rule name becomes the column heading. Then drag a box around the vendor name at the top of the invoice, a little wider than the name so longer names still fit, and click Confirm. Ours read Greenleaf Office Cleaning. Click Save Parsing Rule.

In our test the new rule also ran on the three invoices we had already uploaded, and the credits bar stayed at 3/50. Text Fixed Position works when the field sits in the same place on every document. If it moves around, Docparser also offers Text Variable Position, which looks near an anchor word.

Step 5: download the spreadsheet

Click Prepare for Export. The first time, a Documents are Uploading window asks for your industry, company size, company name, a mobile number and expected volume. The box agreeing to text messages was already ticked in ours, so untick it if you do not want texts.

Then open Exports, then Downloads, and pick Comma Separated Values (CSV). Name the download, open Advanced Configuration and change the Delimiter from Colon to Comma, then Save. Docparser shows a download link that stays the same, so next week you click it again for fresh data. Our file had one row per line item, with the vendor, invoice number, date and totals repeated on each row, and every value matched the PDFs.

Sending rows to Google Sheets or Excel automatically

Under Exports, Integrations lists Google Spreadsheet, Microsoft Excel and other destinations that receive new rows as documents are parsed. Each one asks you to connect an account, so the lesson stops at showing where it is and uses the download instead. Docparser's pricing page lists the Google Sheets export on every plan.

Mistakes to avoid

• Trusting the parser before checking a few rows against the PDFs.
• Leaving the rule name as Fixed Text. It becomes your column heading.
• Drawing the fixed-position box exactly around one vendor name, so a longer name gets cut off.
• Keeping the Colon delimiter, so the whole row lands in one spreadsheet column.
• Skipping your approval step. Docparser reads the invoice; it does not decide whether the bill should be paid.

Links

• Docparser: the document data extraction app this lesson teaches.
• Docparser pricing: current plans. The page lists a 14-day free trial with no credit card, then Starter at $39 a month for 100 credits, Professional at $74 for 250 and Business at $159 for 1,000, billed monthly. One credit is one document of up to 5 pages (read 18 October 2026).
• Docparser in the AI tools directory: where it sits among the other data and spreadsheet tools.
• Sample invoice: Brightside Print Shop (.pdf): a made-up vendor invoice, safe to upload to your own Docparser trial.
• Sample invoice: Paperclip Office Supply Co. (.pdf): a made-up vendor invoice with four line items and sales tax.
• Sample invoice: Greenleaf Office Cleaning (.pdf): a made-up vendor invoice with no sales tax.
• What the samples should give you (.csv): the vendor, invoice number, dates and totals on each sample, to check your download against.
• Our Docparser download (.csv): the real CSV our trial produced from the three samples, one row per line item.

Step by step: Docparser: Pull Invoice Data from PDFs into a Spreadsheet

All 36 steps of the interactive module, in order. In the module you watch each one, then do it yourself in a practice copy that checks your work.

1. Retyping invoices every week

1. See the weekly pile. Jordan is the office manager at Maple Lane Accounting, a made-up firm. Every week the vendor invoices arrive as PDFs, and Jordan retypes the vendor, the invoice number, the date and the total into the bills spreadsheet. Click this week's invoices.

   Meet Jordan. Jordan runs the office at a small accounting firm. Every week, the vendor invoices come in as PDFs. And every week, Jordan retypes them into a spreadsheet.

2. Put a price on it. Jordan handles about 120 vendor invoices a month. Retyping takes about 4 minutes each, or 8 hours a month. With Docparser it is about 1 minute each to check, or 2 hours a month. At $35 an hour that saves about 6 hours, or about $210 a month, and there are no typos in the totals. These are example numbers, so swap in your own. Click the time saved.

   Let's put a price on that. About a hundred and twenty invoices a month. Four minutes each by hand. One minute each to check, with Docparser. That's about six hours back every month. These are example numbers. Use your own.

3. Meet Docparser. Docparser (docparser.com) reads your PDFs and pulls the same fields out of each one into rows you can download as a spreadsheet. The screens that follow are real screenshots from a Docparser free trial, captured October 2026, using three made-up invoices you can download from this lesson. Click the Docparser card.

   This is Docparser. It reads your PDFs, and pulls the same fields out of each one. These are real screens from a free trial.

2. Make a parser from the Invoices template

4. Check your credits. This is the Getting Started page. The top bar shows 0/50 Credits Used. Our free trial came with 50 credits, and each document you parse uses one. Click the credits bar.

   Here's the start page. Our trial came with fifty credits. Each document you parse uses one.

5. Create a document parser. A parser is like a folder: you upload one kind of document to it, and it holds the rules for what to pull out. Click Create Document Parser.

   A parser is like a folder for one kind of document.

6. Pick the Invoices template. Docparser shows Featured Parser Templates. Invoices says it will "extract key data such as invoice number, due date, etc." (SmartAI Parser is marked Premium, so we skip it.) Click Invoices.

   Pick the invoices template. It already knows how to find invoice numbers, dates and totals.

7. Name the parser. A box opens under Name Your Parser. It starts as "My Invoice Parser 1". Give it a name you will recognise. Ours is Stepthrough tests - Vendor Invoices. Click the name box.

   Give the parser a name you'll recognise.

8. Use the template. Click Use Template. Docparser makes the parser and its starter rules.

3. Upload the vendor PDFs

9. Add your invoices. You land on Add Documents. It takes PDF, DOCX, DOC, PNG, JPG, TIFF, CSV, TXT, XLS and XML. You can also start with one of its own sample invoices, but we use our three made-up vendor PDFs. Drag them in, or click Browse.

   Now add the invoices. We use three made up vendor PDFs. You can download them from this lesson.

10. Continue. It says 3 File(s) Uploaded: the print shop, the office supply company and the cleaning company. Click Continue to Next Step.

    Three files uploaded. Continue.

4. Check what it pulled out

11. See the rules it made. The Invoices template made eight Data Parsing Rules: Invoice Number, Invoice Date, Account Number, PO Number, Phone Number, Email, Line Items and Totals. The credits bar now says 3/50: one credit per invoice. Click the rule list.

    The template made eight rules. Invoice number, date, totals, and more. And the credits went from zero to three. One per invoice.

12. Open the Invoice Number rule. A rule is one field you want. Let's check what each rule found on a real invoice. Click Invoice Number.

    Let's check what each rule found.

13. Close the help offer. A window offers free setup assistance from the Docparser team. That is handy for tricky layouts, but we don't need it today. Click No Thanks.

    A help window pops up. Close it for now.

14. Check the invoice number. Under Filtered Result, Automatically Find Invoice Number found GL-2026-0931 on the cleaning company invoice. That matches the PDF. Click the result.

    It found the invoice number. And it matches the PDF.

15. Open the Totals rule. The total is the number that matters most. Click Totals.

    That's the number that matters most.

16. Check the totals. It found net 600.00, tax 0.00 and total 600.00, with a confidence of 90. The invoice says $600.00 with no tax, so it is right. Always check a few against the PDFs before you trust it. Click the totals row.

    Net, tax and total. Six hundred dollars, no tax. That's right. Still, check a few against the PDFs before you trust it.

5. Add the vendor name

17. Add a rule for the vendor. Notice what is missing: there is no rule for the vendor name, and Jordan needs it. We'll add one. Click Add Parsing Rule.

    But something's missing. There's no vendor name. Let's add a rule.

18. Search the rule types. You see Pick a Rule Type to Create a New Parsing Rule. Our vendor name sits in the same spot at the top of every invoice. Click Search by Keywords and type position.

    Search the rule types for position.

19. Pick Text Fixed Position. Text Fixed Position will "extract text from a permanent location". That fits a name printed in the same place on each invoice. Click Text Fixed Position.

    Pick text fixed position. It reads text from the same spot on every page.

20. Name the rule. The new rule is called Fixed Text. That name becomes the column heading in your spreadsheet, so make it clear. Click the name and type Vendor Name.

    Name the rule vendor name. That becomes the column heading.

21. Draw a box around the vendor. The top bar says Draw a rectangle around the fixed position where the text is located. Drag a box around Greenleaf Office Cleaning. Make it wider than the name, so a longer vendor name still fits. Click the vendor name.

    Now draw a box around the vendor name. Make it a bit wider, so longer names still fit.

22. Confirm the box. Your box is drawn and the rule is now called Vendor Name. Click Confirm.

    Confirm the box.

23. Check the vendor name. It reads Greenleaf Office Cleaning. Click the result.

    It reads the vendor name. Perfect.

24. Save the rule. Click Save Parsing Rule. In our test the new rule was used on all three invoices we had already uploaded, and the credits bar stayed at 3/50.

    Save the rule. It ran on all three invoices we already had.

6. Download the spreadsheet

25. Prepare for export. The button now says All Parsing Rules Saved. Click Prepare for Export.

    Now let's get the data out. Prepare for export.

26. Answer a few questions. The first time, a Documents are Uploading... window asks about your industry, company size and expected volume, and for a mobile number. The box for text messages was already ticked in ours, so untick it if you don't want texts. Fill it in and click Submit.

    The first time, it asks a few questions about your company. Untick text messages if you don't want them. Then submit.

27. Open Downloads. In the parser menu, open Exports, then Downloads. You see Create New Download Link. Click Downloads.
28. Pick CSV. It packs the data from all your documents into one Excel, CSV, JSON or XML file. A CSV opens in Excel or Google Sheets. Click Comma Separated Values (CSV).

    Pick CSV. It opens in any spreadsheet.

29. Name the download. Type a name. Ours is Weekly vendor invoices. Include Data From is set to Last 100 Files. Click the Name box.

    Give the download a name.

30. Use commas. Open Advanced Configuration. In ours the Delimiter was set to Colon. Change it to Comma so a spreadsheet splits the columns. Click Delimiter.

    Change the delimiter to comma, so the columns split properly.

31. Save the download. Click Save.

    Save it.

32. Download the file. It says Your download configuration Weekly vendor invoices was created successfully, with a link under the name. The link stays the same, so next week you click it again for fresh data. Click the link to download the CSV.

    Here's your download link. Next week, click the same link again.

33. Check the spreadsheet. Our file had one row per line item, with the vendor, invoice number, date and totals repeated on each row. All three vendors, numbers, dates and totals matched the PDFs. Click the Totals Total column.

    And here's the spreadsheet. Every vendor, invoice number, date and total. All of them matched the PDFs.

7. What it saves, and doing it for real

34. See where it can send data. Under Exports, Integrations lists Google Spreadsheet, Microsoft Excel and more, to send new rows automatically. That needs you to connect an account, so we stop here and use the download. Click Google Spreadsheet to see where it lives.

    Docparser can also send rows straight to Google Sheets or Excel. That means connecting an account, so we'll just show you where it is.

35. What this saves you. In our example Jordan goes from about 4 minutes each, or 8 hours a month to about 1 minute each to check, or 2 hours a month, saving about 6 hours, or about $210 a month. Click What this saves you.

    So here's what this saves you. Hours of retyping every month, and no more typos in the totals.

36. Do it for real. Start a free trial at docparser.com (14 days, no credit card, says its pricing page). Download our three sample invoices from this lesson, or use your own, and follow the same steps. Then check a few rows against the PDFs before you trust it. Click Do it for real.

    Ready to try it? Start a free trial at docparser dot com. Use our sample invoices, or your own. And check a few rows before you trust it.

Screenshots

Frequently asked questions

Is this an official Docparser course?

No. This is my own lesson. Docparser is a separate, third-party product, and the screens are real screenshots from a free trial captured October 2026.

What does Docparser cost?

Its pricing page lists a 14-day free trial with no credit card. After that, Starter is $39 a month for 100 credits, Professional $74 for 250 and Business $159 for 1,000, billed monthly, with lower prices billed yearly. One credit is one document of up to 5 pages (read 18 October 2026). Our trial showed 50 credits.

Can Docparser find the vendor name on an invoice?

Not with the Invoices template alone in our test: it had rules for the invoice number, date, totals and more, but not the vendor. We added a Text Fixed Position rule around the name, and it read all three vendors correctly.

Can I get the data into Excel or Google Sheets?

Yes. The simplest way is Exports, then Downloads, which makes an Excel, CSV, JSON or XML file. Under Integrations it can also send rows to Google Sheets or Excel automatically once you connect an account.

Does it work on scanned invoices?

Docparser says it has a built-in OCR engine for scanned documents. We only tested typed PDFs, so try a few of your own scans on the trial first.

Start this module free

Terms in this lesson

Plain-English definitions, each with an example from a free lesson.

The full AI glossary

Browse related tutorials