Skip to content

How to

Tell it what to pull, in plain words

Every supplier lays out invoices differently. When you add a PDF to Mammoth, pick Custom and type the fields you want. Each invoice becomes one row, in the same columns.

96 seconds, real app, made-up invoices. Follow along with the same two: Northfield Coffee Roasters (PDF) and Kestrel Freight (PDF). Download the video (MP4)

The steps

  1. 1

    Upload the PDF

    In Data, choose New dataset and upload your PDF. It shows as Needs attention. Choose Extract Data and the Review data import window opens with the file on the left.

  2. 2

    Choose Custom

    Under What to import, Only tables would bring in the line items but not the invoice number, dates and total around them. Choose Custom.

    The What to import options Only tables, All content and Custom, with Custom selected and an empty instruction box under it
  3. 3

    Say what you want, in plain words

    Type the fields you want, named the way you want the columns called. The video uses: One row per invoice: supplier, invoice number, invoice date, due date, PO number, total due. Then choose Extract.

    Custom selected, with the instruction typed in the box: one row per invoice with supplier, invoice number, invoice date, due date, PO number and total due
  4. 4

    Check the row

    Mammoth reads the page using your instruction and shows the result next to the PDF. Check each value against the page, down to the total due.

    The invoice's Total due of £1,196.28 on the left, and the extracted row on the right with due date 13 Nov 2026, PO number CT-7731 and total due £1196.28
  5. 5

    Save it

    Choose Looks right, name the dataset, then choose Create dataset. Your instruction is saved with the dataset as its recipe.

  6. 6

    Add the next invoice

    Open the dataset, choose Add data and upload the next PDF, even one from another supplier with a different layout. The recipe runs on it and adds a row in the same columns, ready to clean, join to other data or chart.

    Explore showing two rows, Northfield Coffee Roasters and Kestrel Freight Co., each with invoice number, invoice date, due date, PO number and total due

Write instructions that work

Name each field the way you want the column called, and add the format when it matters.

  • Invoice number, vendor name, invoice date (MM/DD/YYYY) and total amount (numeric)
  • All line items: product name, quantity, unit price and line total
  • Only the summary table on page 1

A vague instruction such as “get the data” leaves Mammoth guessing which fields matter.

If it doesn’t look right

A field is empty or wrong
Click the pencil next to your instruction, make it more specific, and extract again. You don't need to upload the file again.
It's a scan or a phone photo
Mammoth reads scans and images too, but text-based PDFs give the most reliable results. Use a clear, straight image.
You get more than you asked for
Narrow the instruction to a page or a section, as in the last example above.

Next month’s invoice

When you save the dataset you choose how it refreshes. With Manual, upload next month’s file and the same instruction runs over it. If the new file looks different, Mammoth pauses and asks you before changing your data. Refreshing when a new file arrives in a folder depends on your plan.
Every option in the PDF extraction docs

Try it on your own invoices.

Pull fields from invoices, statements and receipts the same way: name the fields, check the row, save it.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free