One link, all your Metrc data.
T3 Super Reports
Harvests joined with their packages, synced to your spreadsheet
Export entire Metrc datasets in a single request. Spreadsheet Sync keeps Google Sheets and Excel automatically up to date. Perfect for compliance, inventory, and sales reporting.
Super Reports
T3 Super Reports let you export entire Metrc datasets in a single request, instead of paging through hundreds of individual API calls. Each report returns a clean, flat table that is ready for analysis, auditing, or spreadsheet import.
Available Reports
Reports are available across every major Metrc data type:
Packages
Track active, inactive, in-transit, and on-hold package inventory across your facility.
Transferred Packages
Monitor packages that have moved between licenses or facilities in your supply chain.
Items
Export your complete product catalog with strain, category, and item-level metadata.
Harvests
Report on active, inactive, and on-hold harvest batches with associated plant and yield data.
Plants
Separate reports for vegetative, flowering, mother, and inactive plants across growth stages.
Plant Batches
Track germination and cloning batches in active, on-hold, and inactive states.
Sales
Monitor active and completed retail transactions with customer and line-item details.
Tags
Export available, used, and voided Metrc tags for inventory tracking and compliance.
Strains
Access your complete strain database with cannabinoid profiles and other characteristics.
Locations
Report on active facility rooms and storage areas where inventory resides.
Transfers
Track incoming, outgoing, rejected, and hub transfers between licensed entities.
Transfer Manifests
Combine transfer, package, and transporter details in one row per package.
Standard vs. Super Reports
Standard reports return one row per record with high row limits and fast performance, making them ideal for large exports.
Super reports use an include parameter to attach related data—such as lab results, harvest sources, or plant counts—so you never have to manually join data together.
Spreadsheet Sync
Spreadsheet Sync turns any T3 Report into a live spreadsheet formula. Generate a secret key, build a Sync Link with your report path and license number, then paste it into your spreadsheet:
=IMPORTDATA("https://api.trackandtrace.tools/...")Google Sheets uses IMPORTDATA() and Excel uses Power Query. Once connected, the spreadsheet stays up to date with Metrc, refreshing automatically at least once per hour—no manual exports required.
Next Steps
- Read the Reports and Spreadsheet Sync documentation to see every available report endpoint.
- Most reports require a T3+ subscription. If you don't have one, you can sign up here.