How to extract revenue from PDFs to Excel with AI (no code)

Use =PDF in Google Sheets to draft a revenue record from a company report. Extract the amount, currency, unit and reporting period together, check them against the PDF, then export verified values to Excel.

Start with one public company report. This guide is for reported company revenue, not adding up private invoices. The prompt below is a template to review on your own document, not a tested accuracy guarantee.

Which methods can I use to extract revenue from PDFs?

For one short report, manual copy/paste may be enough. AI can help locate the relevant figure, but you still need to verify what it represents.

How do I set up a no‑code workflow to pull revenue from PDFs into Sheets?

Prepare an accessible report, make one extraction request per PDF, and verify the result before copying it into reporting columns.

Step 1: How do I prepare my PDFs safely?

Use a public PDF link from the company's report page where available. The formula needs an accessible file URL; your personal Drive access does not automatically grant the formula access.

1. Choose a public company report, or a document you are explicitly authorized to share with the processing service.
2. Paste its accessible PDF URL into A2. Start with one document before filling down.
3. If you use Google Drive, follow the access setup only after checking the document's sharing permissions and sensitivity.

Do not make confidential statements or invoices public just to get the formula working. “Anyone with the link” lets anyone holding that link access the file without signing in. If your document cannot be shared that way, stop and use an approved handling method; do not assume an upload URL is private.

Access setup: How to make files accessible in Google Drive. Formula syntax: AI for Sheets formula reference.

Step 2: How should I set up my columns in Google Sheets?

Keep the AI draft separate from the fields you have checked. Use these headers in row 1:

Put this formula in B2:

=PDF("Extract the latest actual reported total company revenue from this company report, not a forecast, profit, funding amount, market size or segment-only figure. Use the most recent reporting period end date, and state whether it is annual, quarterly or another period. Return only one JSON object with these keys: company, revenue_as_printed, scale, currency, period, page, evidence, status. Keep all fields tied to the same revenue item. Preserve the printed amount and any thousands or millions scale; do not convert currency or silently multiply the amount. Include the source page and a short supporting quote. Use status FOUND only when the record is unambiguous. If there are conflicting companies, figures, ranges or unclear units/currency/periods, use REVIEW and explain the uncertainty in evidence instead of choosing or inventing a value. If no company revenue is found, use NOT_FOUND. Leave unavailable fields as empty strings. Do not invent page references.", A2)

The result is a draft JSON record in one cell, not an automatically verified table. It may still be incomplete or incorrectly formatted. If it contains an error or unreadable output, leave the verified fields empty and mark the row Review.

Step 3: How do I check that the revenue value is the right one?

Open the PDF and check the revenue line and its table headings. Only then manually copy the confirmed fields into C2:H2 and set your review status in I2.

• Company and scope: check the company total, not a subsidiary or segment unless that is explicitly your task.
• Period: keep annual, quarterly and year-to-date figures distinct. Do not treat a forecast as the latest actual result.
• Amount and scale: keep the printed number with its unit. For example, 1.2 million means 1,200,000 units; this is an illustrative conversion, not a result from a tested report.
• Currency: use the currency established by the report. Do not guess from a bare dollar sign or convert currencies silently.
• Ranges or missing data: preserve the uncertainty and mark Review or Not found. Do not turn missing revenue into zero.
• Evidence: check that the quoted text and page actually support this same record. The AI's FOUND status does not mean you have verified it.

After a few rows are checked, fill the formula down only for the documents you intend to process. Each new AI formula may use credits. Keep unverified rows out of totals, and do not sum different currencies, scales or overlapping reporting periods.

Step 4: How do I export the results to Excel or CSV?

Export a stable snapshot after your review, not a workbook that depends on the add-on running inside Excel.

1. Keep your working sheet intact and make an export copy.
2. In that copy, select the populated table, copy it, then use Edit → Paste special → Values only on the same selection.
3. Check that the former AI-result cells now contain text or values rather than =PDF formulas. Keep the source URLs, units, periods and review statuses.
4. Use File → Download → Microsoft Excel (.xlsx) or Comma-separated values (.csv). CSV exports the current sheet.
5. Open the downloaded file and check a few rows. CSV does not preserve spreadsheet formatting, so check how numbers and dates were imported.

Sources: https://support.google.com/drive/answer/2494822 and https://simplemetrics.xyz/help/formula-reference/.

Ready to try it? Get started on the Google Workspace Marketplace and check one public report before processing a batch.