How to
Tell it what to pull, in plain words
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
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
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.

- 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.

- 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.

- 5
Save it
Choose Looks right, name the dataset, then choose Create dataset. Your instruction is saved with the dataset as its recipe.
- 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.

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
More how-tos
- Put two files on one dashboardJoin sales to targets on the store they share and chart them side by side.
- Describe the change, skip the formulaSplit a name column into first and last by saying so, then check the preview.
- Next month's file, same stepsAdd next month's file and every cleaning step runs again; a changed layout stops to ask.
- Next month's statement, zero reworkRead a PDF statement once; next month's goes through the saved recipe into the same columns.
- Share it with the whole team, no seats to buyPublish a dashboard and send the link; viewers are free on every plan.
- Every table in your PDF, joined into oneTables that share columns come back as one dataset, even across pages.
- Describe a dashboard, get one built from your dataPick one of the dashboards Mammoth suggests from your columns, or describe your own.
- Drop in your messiest spreadsheetStacked headers, merged cells and subtotals, turned into a clean table you check first.
- Let viewers ask their own questionsThe Q&A page answers viewers' follow-ups from the data, with the source and a CSV.
- Scans and phone photos work tooMammoth reads documents with no text layer, such as scanned PDFs and photos of receipts.
- Add next month, and your dashboard followsUpload the new month to the same dataset and every chart picks it up. Works on Free.
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