Convert 1099 PDF to Excel on Mac (2026 tax-prep guide)

It’s late March. The accountant emailed: “send me everything in one spreadsheet by Friday.” The desktop folder is ~/Documents/Taxes/2025/1099s/. Inside, there are eighteen PDFs: nine 1099-NECs from various clients who paid through Stripe, ACH, or wire; three 1099-MISCs from a board-advisor role and a royalty payer and a state grant; two 1099-Ks from PayPal and Stripe that overlap partially with the NECs; three 1099-INTs from brokerage and bank accounts; one 1099-DIV from the index fund. Eighteen forms, six different layouts, one Schedule C that needs total non-employee compensation in box 1 — net of the 1099-K overlap with the NEC reporting.

The Mac is, for this specific job, the right tool. The keyboard makes spot-checking eighteen forms fast. The 27-inch display shows the form PDF and the extracted row side by side. And ignitai reads all eighteen 1099 PDFs on-device — the form files themselves are never uploaded — and writes one consolidated XLSX, sending only the recognized text to its private pipeline.

This guide is the workflow that gets you from “a folder of 1099 PDFs from a dozen different payers” to “one Excel workbook on its way to the CPA” without re-typing a payer EIN, without uploading the entire 2025 income picture to a web converter, and without paying for the consumer tax-prep software’s $80 “import documents” tier that only handles three of the eighteen forms anyway.

Why Mac (not iPad, not iPhone) for 1099 consolidation

1099 consolidation is an annual job that happens under deadline, with multiple form types, feeding a single accountant handoff. Three reasons the Mac is the right device:

Tax-prep work is desk work. 1099 season is February through April. Forms arrive scattered: some by email, some photographed from mail, some downloaded from a payer’s portal. They land on the Mac because the Mac is where the rest of the tax documentation lives — receipts, deductions, prior-year returns, the Schedule C draft. Consolidating in one pass on the Mac is the only workflow that survives the April pressure.
Per-form layouts demand the big screen. A 1099-NEC has effectively one box. A 1099-MISC has eighteen numbered boxes across two columns. A 1099-K has Box 1a (gross), 1b (card not present), 2 (merchant category code), and a per-month grid. Spot-checking that the extraction read Box 7 on the MISC correctly — not Box 8 — wants the PDF and the spreadsheet side by side.
Excel for Mac is the accountant’s format. Every CPA in the US opens .xlsx. Sending .numbers forces a manual export, and a CSV attachment invites a mangled import on the other end. XLSX opens with every field in its own column — the universal handoff.

Why 1099 extraction is harder than receipts or invoices

A receipt batch is forgiving — get the date, vendor, and total right and the row is useful. A 1099 batch is the opposite: every box has IRS-defined semantics, and the wrong amount in the wrong box on Schedule C is a misfile. The failure modes:

Six form layouts in one folder. A 1099-NEC, a 1099-MISC, a 1099-K, a 1099-INT, a 1099-DIV, and a 1099-B all live in the same folder for a freelancer with side investments. Each has different boxes, different total fields, different IRS reporting destinations. A batch tool that only handles one form type means six passes and six spreadsheets to merge by hand.
Payer and payee TIN both matter. Every 1099 has the payer’s TIN (their EIN) and the payee’s TIN (your SSN or your LLC’s EIN). The CPA reconciles against IRS records using payer EIN; you reconcile your records using your TIN. Both fields have to come through intact.
1099-K overlap with 1099-NEC. A payment platform like Stripe issues a 1099-K for the gross processed; the client who used Stripe to pay you might also issue a 1099-NEC for the same compensation. Reporting both as separate income on Schedule C double-counts. The consolidation has to flag overlap candidates — same payer, same period, same approximate amount — so the human reviewer can mark which to exclude.
Box numbering changed between years. The IRS reshuffles 1099-MISC and 1099-NEC box layouts every few years. The 1099-NEC was split out of 1099-MISC in 2020; 1099-K thresholds changed in 2023 and 2024. An extractor that treats every form as the current year’s template will misread older corrected forms.

A tool that handles the 1099-NEC case but trips on the 1099-K box grid is the gap most users fall into. The whole point of the consolidation is one workbook covering every form type, with the right amounts in the right columns, ready to import into the CPA’s worksheet.

Method 1: ignitai folder batch on macOS (the main path)

ignitai handles a 1099 batch the same way it handles an invoice batch — drop the forms in one motion, write the prompt once, get one consolidated workbook. The Mac flow:

Stage the folder. Create ~/Documents/Taxes/2025/1099s/. Drop every 1099 PDF into it. If a form arrived by mail and got photographed with the iPhone, that HEIC or JPEG works too — image files run as their own batch via the Photos picker (or convert them to PDF first); a Mac drag takes the PDFs. ignitai reads scanned tax forms about as well as native PDFs. Rename files to a convention that makes the folder easy to audit later: 1099-NEC-acme-corp.pdf, 1099-K-stripe.pdf, 1099-INT-fidelity.pdf — the payer_name column in the output is what you’ll match against these names.
Open ignitai. Select the forms and drag them onto the window. Each form is read on-device — the PDFs themselves are never uploaded — and only the recognized text is sent to ignitai’s private hosted pipeline to build the workbook.
Describe what to extract, in plain English. For a freelancer’s annual 1099 consolidation:

“For each 1099 form, return one row per populated numbered box with: form_type (one of: 1099-NEC, 1099-MISC, 1099-K, 1099-INT, 1099-DIV, 1099-B, 1099-R, 1099-G, 1099-OID, 1099-SA, 1099-S — the exact variant), tax_year, payer_name, payer_tin, recipient_tin, account_number (if present), corrected (true/false based on the ‘Corrected’ checkbox), box_number, box_label (the IRS label printed on the form, e.g. ‘Nonemployee compensation’ for 1099-NEC Box 1), and box_amount. If a state filing block is populated, return state, state_payer_id, state_income, and state_tax_withheld as additional box rows.”

ignitai keeps the prompt in Previous Prompts — next year it’s one tap to reuse.
Pick XLSX as the output format. The output is one long-format sheet: one row per populated box, with the form-level fields — payer, TIN, form type, corrected status — repeated on every row. That shape scales across form types, and a pivot table in Excel turns it into the Schedule C roll-up.
Hit Convert. A folder of eighteen 1099s processes in a few minutes, with live progress — pages read, parts uploaded — across the batch.
Spot-check in Excel for Mac. Open the output 2025-1099s.xlsx. Expect roughly sixty box rows for eighteen forms, depending on form mix, each carrying its payer and form type. Run the five reconciliation checks below before sending to the CPA.

End to end on a year’s worth of 1099 forms: under thirty minutes of human time, most of it the spot-check phase.

Why long-format rows (not one wide flat table)

For bank-statement imports into QuickBooks the right output is a flat transaction table. For 1099 consolidation, the data is fundamentally one-to-many — each form has one header (payer, recipient, year) and many populated boxes. Each run produces exactly one table, so the shape that works is long-format: one row per populated box, header fields repeated on every row. Three reasons:

Different forms have different box counts. A 1099-NEC has one numeric box; a 1099-MISC has up to eighteen; a 1099-K has a per-month grid plus annual totals. Flattening all forms into one wide table creates an eighty-column file with most cells empty, or loses data. Long-format box rows are the only shape that scales.
Pivot-table totals for Schedule C. Add a summary tab in Excel yourself and SUMIFS against the box rows filtered to form_type = 1099-NEC AND box_number = 1 — the Schedule C box-1 total appears instantly. The CPA gets the line ready to type, with the box rows as the audit trail behind it.
The corrected-form audit trail. If a payer reissues a 1099 with the “Corrected” checkbox marked, both the original and the corrected form land in the folder. The corrected column makes it possible to filter and supersede; without it the form-level status is lost.

If your CPA wants one flat row per form instead, run the batch again with a wide-format prompt (one box per column) — two runs, two clean files.

Method 2: IRS Get Transcript (and why it’s not enough alone)

The IRS lets you download a Wage and Income Transcript from irs.gov/individuals/get-transcript. It lists every 1099 the IRS received for your TIN, with payer name and amount. Two reasons it’s a useful cross-check but not a replacement:

Transcripts lag. A 1099 issued in late January often doesn’t show on the transcript until June or July, well after the April filing deadline. For April tax prep, the transcripts often cover only a fraction of the forms you need to file. The PDFs in your folder are the source of truth.
The transcript is summary-only. It shows payer name, TIN, and gross amount. It does not break out 1099-MISC boxes (rent vs royalties vs prizes), does not give you state income for the state return, does not surface the corrected-form chain. For the actual Schedule C and state filing, the PDFs hold the structured detail.

Pull the Wage and Income Transcript anyway as a final reconciliation step — after the consolidation is done, compare your forms sheet against the transcript line by line. Anything on the transcript but missing from your folder is a 1099 a payer issued without sending you a copy, and the IRS will expect to see it on the return.

Method 3: TurboTax / H&R Block document import

TurboTax Premium, H&R Block, and other consumer tax-prep tools advertise “import your 1099s.” Direct import works only for a small list of payers — brokerages (Fidelity, Schwab, E*TRADE), some banks for 1099-INT, and a handful of payroll-card platforms. Stripe-issued 1099-Ks, board-advisor 1099-MISCs from small companies, ad-hoc grants — those don’t have an import path; you type them in by hand. Even where direct import works, it uses your brokerage credentials to pull data through the tax-prep vendor’s servers, where the return is then stored. ignitai produces the spreadsheet that feeds the consumer tax-prep tool’s interview screen; it doesn’t replace the tax-prep tool itself.

Method 4: web “PDF to Excel” converters (and why never for 1099s)

The cardinal rule of tax-form privacy: a 1099 PDF contains a TIN, in plain text, that uniquely identifies you to the IRS. Uploading it to a free-tier web converter — whose terms typically allow processing or retaining submissions — is a category of mistake unto itself. Web converters also have no form-type awareness; the 1099-K monthly grid comes through as a tangle of unlabeled columns and the post-processing to recover box meaning is the slow part. Free-tier file caps (three to five per month) don’t survive a real 1099 batch either. For a sample 1099 from an IRS instructions PDF, fine. For your actual 2025 income forms, no.

The five reconciliation checks for the 1099 batch

Once the XLSX is written, five checks separate “I have a file” from “I have a Schedule C input I can trust”:

Form count vs folder count. Count the distinct payer + form-type combinations in the sheet (a quick pivot does it) against the PDFs in the source folder, minus any corrected pairs (where the corrected version supersedes the original). If you started with eighteen PDFs and only seventeen forms show up, one didn’t extract — usually a scan with low contrast that needs a re-pass.
TIN format sanity. Every TIN should match one of two formats: XX-XXXXXXX (EIN) or XXX-XX-XXXX (SSN). If a payer_tin came through as letters or a partial string, the extraction misread the field — common when the box was handwritten over a printed template. Hand-correct.
Box-1 totals per form type. Pivot the box rows by form_type, summing box_amount filtered to the relevant box (Box 1 for 1099-NEC, Box 1a for 1099-K, Box 1 for 1099-INT). The totals should match your own bookkeeping records’ income figures within rounding. Big divergence means either a missed form or a misread amount.
1099-K overlap resolution. Filter to form_type = 1099-K and box_number = 1a, and compare each gross amount against the sum of 1099-NEC Box 1 rows from clients who paid through that platform. A near-match within a few percent is likely the same income reported twice. Add an excluded_due_to_overlap column in Excel and mark the duplicate so the Schedule C box-1 calculation excludes the overlap.
State-income reconciliation. Filter the box rows to state-related entries. Group by state. Each state where you owe a state return should have a coherent total. A missing state row on a form that lists state filing means the extractor didn’t pick up the state block — manual fix.

Skip these five and the Schedule C is wrong in subtle ways — a missed 1099-NEC under-reports income (and the IRS notices when their transcript arrives), a 1099-K overlap over-reports income (and you overpay tax), a misread Box 4 federal withholding under-claims credits.

A worked example: freelance consultant filing for 2025

A single-member LLC consultant with nine 1099-NECs from direct clients, three 1099-MISCs (royalty, sublet rent, competition prize), one 1099-K from Stripe, two 1099-INTs, one 1099-DIV, and two 1099-Bs. Eighteen forms. Mac flow:

Open ~/Documents/Taxes/2025/1099s/. Eighteen PDFs, clean names.
Select the forms and drag them into ignitai. The batch processes in a few minutes.
Reuse the annual 1099 prompt from Previous Prompts. Pick XLSX. Convert.
Open 2025-1099s.xlsx. 64 box rows across the eighteen forms, payer and form type on each.
Run the five reconciliation checks. One 1099-MISC came through with payer_tin as 99-99-9999 because of an older template’s TIN placement — hand-fix. The Stripe 1099-K Box 1a nearly matches the sum of four 1099-NEC rows from Stripe-routed clients — confirm the overlap, mark those rows excluded_due_to_overlap.
Build a summary tab in Excel. Schedule C Box 1: sum of 1099-NEC Box 1 + non-excluded 1099-K Box 1a + 1099-MISC Box 1 from the sublet. Schedule B interest: sum of 1099-INT Box 1. Schedule B dividends: sum of 1099-DIV Box 1a. Schedule D: sum of 1099-B Box 1d minus Box 1e.
Email to the CPA. Total time: about forty-five minutes.

Compare to typing every box into a CPA-supplied intake spreadsheet by hand: a Sunday afternoon plus an inevitable round of corrections when the CPA spots a transposed TIN.

When the Mac 1099 batch isn’t the right tool

Honest edge cases:

One W-2 and three 1099s, total. Don’t fire up the batch for four documents. Type them into TurboTax’s interview or hand them to the CPA. The batch path earns its keep at ten-plus forms.
K-1s, not 1099s. Schedule K-1 from a partnership or S-corp is a different document with different boxes. The batch prompt above won’t handle K-1s; use a separate run with a K-1-specific prompt, or pass K-1s straight to the CPA as PDFs.
Corrected forms after filing. If a payer issues a corrected 1099 after April, the right answer is an amended return (1040-X), not a re-run of the consolidation. Keep the corrected PDF for next year’s audit trail.
High-volume traders with hundreds of 1099-B rows. A 1099-B from an active trading account can run twenty pages. Use the brokerage’s own CSV export instead — every major broker offers one. Reserve the PDF batch for the consolidated 1099-B summary, not line-level transactions.

Bottom line

For a Mac user staring down a folder of fifteen or more 1099 PDFs from various payers that need to become one Excel workbook for the CPA: stage them in a folder, select them all and drag them into ignitai, reuse the prompt from Previous Prompts, pick XLSX, run the five reconciliation checks. For three or four forms and a willing afternoon, manual entry into the tax-prep tool’s interview works. For the W-2-only filer, none of this applies — type it into TurboTax and be done.

The same app handles the Mac invoice batch for the client-side accounts-payable view, the Mac credit card consolidation for the deductible-spending review, bank statement extraction for the income-side reconciliation, and the generic Mac batch path for anything else the CPA asks for. Presets sync via iCloud, so the 1099 prompt written once on Mac is the same one available next year — and the Schedule C box-1 calculation runs the same way on every year’s batch.

Get ignitai on the App Store — free download, $19.99/mo unlocks unlimited extractions after the 3-day trial.

FAQ

How do I convert 1099 PDFs to Excel on Mac?

Collect every 1099 in one folder, select them all, drag them into ignitai, describe the fields you want as columns (payer, form type, box amounts), pick XLSX, and hit Convert. Every form lands in a single Schedule C-ready sheet, one row per populated box with the payer and form type on each row.

Can I mix 1099-NEC, 1099-MISC, 1099-K, and 1099-INT in one batch?

Yes — that is the point of the prompt-based approach. Because you describe fields rather than positions, different form types in different layouts land in consistent columns, with a form-type column separating them for the Schedule C roll-up.

Is it safe to convert 1099s with an AI tool?

A 1099 carries your SSN or EIN, so avoid web converters that require uploading it. ignitai reads each form on-device — the PDFs are never uploaded — and sends only the recognized text to its private hosted pipeline to build the workbook.