Locate the Article Number, Mailing Date, and Recipient Name on Any Certified Mail Tracking Screenshot
Copying a certified mail tracking page into a spreadsheet — the 22-digit article number, mailing date, delivery date, and recipient line — takes about 3 minutes per piece by hand; this pulls the same fields in 5-10 seconds per screenshot.
5-10s per screenshot · Up to 99% accuracy on printed text
The Proof-of-Delivery Fields on Any Certified Mail Page
A certified mail tracking page is a legal receipt, not a table — and every postal service renders it differently. With Custom Column Extraction, you name fields; the AI locates each by meaning.
USPS 22-digit, Royal Mail 13-character, Japan Post Registered Mail (書留, kakitome) 12-digit — five formats, one concept; the AI writes it as text so Excel never mangles it.
The postmark date — under IRS §7502(c), what makes a filing timely.
"Delivered, Left with Individual," "Remis au destinataire," "配達完了" — one event, different phrasing per service.
Who signed at delivery, from the final scan line.
The address blocks on the mailing record.
A scanned image, not typed text — the AI locates it for verification, not transcription.
This Isn't a Tracking Page — It's a Legal Proof-of-Delivery Document With a Different Layout on Every Postal System
Certified mail exists to create legally admissible proof that a document was sent and received — and that proof lives on a tracking page every postal system renders differently. Template tools fail here; semantic extraction does not.
USPS uses a 22-digit UPU code. Royal Mail Signed For uses 13 characters ending in GB. Japan Post Registered Mail (書留, kakitome) uses 12 digits. Deutsche Post Einschreiben and La Poste Recommandé each have their own. Five formats for one concept — and 20+ digits that Excel silently converts to scientific notation.
For tax filings, the mailing date is the legally decisive timestamp — IRS §7502(c) treats a postmarked certified mail receipt as proof of timely filing. For landlord notices or subpoenas, the delivery date is what proves service. A generic "date" field cannot tell these apart.
The green card (USPS PS Form 3811) carries its own tracking number, distinct from the article number barcode. Legal staff know the pain — as one r/paralegal user put it: "the signature isn't legible or there is no date and I still have to trace through the website."
With Custom Column Extraction, you type the column once and the AI locates the value by what it means — a 22-digit USPS code, a Royal Mail code, or a kakitome 12-digit number are all recognized as article numbers wherever they sit.
Name both, and the AI reads label context to file each date correctly — the acceptance or postmark line into Mailing Date, the "Delivered," "Remis le," or "お届け日" line into Delivery Date. The two legal meanings stay separated in your spreadsheet.
"Delivered, Left with Individual," "Remis au destinataire," and "配達完了" are recognized as the same delivery state. The handwritten signature is located as an image, not transcribed — so you verify it visually instead of trusting a guessed name.
From a Certified Mail Tracking Screenshot to One Proof-of-Delivery Log Row
If you keep records for tenant notices, IRS filings, subpoenas, or compliance letters — here is what happens when you drop certified mail tracking screenshots into the tool.
Upload the tracking screenshot
Drop in a full-resolution screenshot of the tracking page — from USPS.com, Royal Mail, Japan Post, Deutsche Post, or La Poste — that includes the scan timeline and the final delivery event. Screenshots that capture both the acceptance scan and the delivery scan carry both dates you need.
Name the columns you need
Type your headers: Article Number, Mailing Date, Delivery Date, Delivery Status, Recipient Name, Signature Image. The AI maps the labels on the page — "Tracking Number," "Numéro de suivi," "お問い合わせ番号" — to the right column, whatever the layout.
Export to Excel — one row per mailpiece
Each screenshot becomes a row: the 22-digit article number preserved as text (no scientific notation), the mailing and delivery dates in separate date columns, the delivery status in the postal system's original phrasing, and the located signature image ready for visual verification. Batch 30 mixed postal-system screenshots and the output is one clean evidence log.
Where Certified Mail Tracking Extraction Works — and Where It Stops
Honest boundaries matter when the output feeds records that may be reviewed by courts, agencies, or auditors.
- ✓
Full tracking page screenshots with the scan timeline and final delivery event visible.
- ✓
Mixed postal systems in one batch — USPS, Royal Mail, Japan Post, Deutsche Post, and La Poste screenshots under the same column definitions, no per-system setup.
- ✓
Evidence-log building — organizing years of certified mail records into a searchable spreadsheet.
- ⚠
This extracts what the screenshot shows — it is not a postal API. It does not query USPS PTR2 or any postal database, and cannot pull scans that scroll below the fold.
- ⚠
Signature images are located, not transcribed. An illegible handwritten signature cannot become reliable text — the tool finds and highlights it; the official record stays on the return receipt.
- ⚠
Extraction is not legal certification. For disputes, keep the green card (PS Form 3811) and the postal system's own printout as the evidentiary documents.
Frequently Asked Questions
Will the 22-digit certified mail Article Number become scientific notation in Excel?
No. Excel converts numbers longer than 11 digits into scientific notation — a USPS article number like 9400 1100 0000 0000 0000 00 becomes 9.4E+21, which corrupts the record. The AI writes the extracted Article Number as text, so all digits survive in the spreadsheet exactly as printed on the tracking page.
Can I mix USPS, Royal Mail Signed For, and Japan Post 書留 screenshots in one batch?
Yes. Define one set of columns — Article Number, Mailing Date, Delivery Date, Recipient Name — and the AI processes every screenshot with the same definitions. The USPS 22-digit UPU code, the Royal Mail 13-character number, and the Japan Post Registered Mail (書留, kakitome) 12-digit number all land in the same Article Number column. No need to sort screenshots by postal service first.
Can the tool extract the handwritten signature as text?
No — and it deliberately does not guess. The signature on a certified mail record is a scanned image, and handwritten signatures are often illegible, which is exactly why paralegals report having to trace through tracking websites. The AI locates the Signature Image region so you can verify it visually, and captures the typed Recipient Name from the delivery scan line. For the official signature record, keep the return receipt (green card).
My screenshot only shows the top of the page — will the Delivery Date still be extracted?
The AI extracts what is visible in the image. If the delivery scan and its timestamp sit below the visible area, they cannot be recovered from that single screenshot. The Article Number and Mailing Date — which appear at the top of most tracking pages — are extracted reliably from a partial capture. For the complete record, screenshot the full page including the delivery event, or capture two images covering the scroll range.
Is the extracted data accepted as proof of delivery in court or by the IRS?
The tool organizes the same fields that appear on the official tracking record — it does not create or certify the underlying postal record. IRS §7502(c) gives legal weight to the certified mail sender's receipt itself, and USPS keeps signature records for two years. Treat the extracted spreadsheet as a structured index of your records, and keep the postal system's own receipt and tracking printout as the evidentiary documents.
Also from this category: Travel Tickets & Delivery Screenshots Overview — the Hub for tickets, boarding passes, and delivery proof screenshots · Carrier Tracking Page Extraction — package tracking pages from UPS, FedEx, DHL, and USPS · Package Delivery Notification Extraction — delivery proof pulled from courier app and email notifications