automation

USPTO TMExport

Official USPTO ODP REST & TSDR pipeline extracting trademark filings into 45-column Excel datasets.

Python 3.10+RequestsOpenPyXLPyInstaller
Illustrative interface concept
The context

What needed to work better?

High-performance desktop data pipeline leveraging official USPTO Open Data Portal (ODP) bulk daily XML products and TSDR APIs to extract and enrich trademark filings into legal-grade Excel workbooks with zero browser automation.

The engineering

Connecting the right pieces.

Official REST API Engineering: Replaced fragile web scraping with official USPTO ODP bulk daily XML products and TSDR APIs.

Real-Time Serial Walking: Proactively discovers same-day trademark filings via serial walking before official bulk XML release.

Custom 45-Column Exporter: Automatically enriches applicant entity, attorney, primary email, phone, and trademark status.

Standalone Windows Binary: Packaged as a portable single-file executable with an interactive console menu and offset resuming.

The delivery

What went into the build.

Python Data Pipeline
Standalone Windows Executable
45-Column Excel Exporter
API Rate-Limiter Engine
Let’s make your next move

Your business.
A better system.

Share your requirements and we’ll discuss a practical scope, approach, and next steps.

Start a conversation
There’s more to explore.Back to all projects