Exports
Table exports, Excel workbooks, panel downloads, the 1,000-row cap and monthly export limits.
Table exports
Click Export in the toolbar of any registry table (in Directory view it sits in the page header).
What gets exported
Your current filters, search and sort, applied server-side. Not just the page you are looking at, and not the whole table -- exactly the result set your filters and search define, in the current sort order, up to the row cap. If a cohort is active on the table, its filters apply too.
Formats
| Format | Notes |
|---|---|
| CSV | Comma-separated, one header row, UTF-8 |
| JSON | The same records as a single JSON array |
| HubSpot CSV | Listed as coming soon |
| Salesforce CSV | Listed as coming soon |
Lead lists already export HubSpot and Salesforce files. See Lead Lists.
Field selection
The dialog lists every column in the table with a checkbox and shows how many are selected. Select All, Unselect All, or pick individually. Only the ticked fields are written to the file. With every field ticked, the file carries every field of the record, including some that are not shown as table columns. The header row uses the dataset's own short field names, which can differ from the column titles in the table.
Row cap
Table exports are capped at 1,000 rows per file on every plan. The dialog states what you are about to download: "Exporting N matching records", or "Exporting the first 1,000 of N matching records" when your filters match more. Narrow your filters to export a specific slice.
Download Sample
Download Sample saves the first 5 rows in your chosen format and fields, so you can check the shape of the file first. Samples do not count toward your monthly exports and still work after the limit is reached.
When an export is refused
- No rows match your filters: nothing is downloaded.
- The data service fails part way: the export is stopped as incomplete rather than cut short, and it is not counted. Try again.
- Premium dataset without Pro or Teams: refused.
- Exports turned off for your seat: on Teams, the team owner can switch exports off per member.
- Monthly limit reached: refused until your allowance resets or you upgrade.
Excel workbooks
Provider, Facility and ACO Network record pages, Drug Profile and Territory Brief have an Export button that builds a formatted Excel workbook (.xlsx) with one tab per section.
The Export to Excel dialog offers Preset buttons (on a provider record: Everything, Profile only, Practice, Exposure), a Sheets list with row counts, and Select All / Unselect All. Every workbook starts with a Cover sheet (title page, key metrics, contents and sources) that is always included. Export Excel downloads the file. A provider workbook, for example, can also hold Profile, Patient Panel, Procedures, Prescriptions, Patent Cliff, Market Signals and Similar Providers sheets.
Each workbook counts as one export toward your monthly limit. Without an active plan, the button shows a lock and opens the plan options.
Panel downloads
Many analysis panels have their own Export or download button. These save exactly the rows shown in the panel, including computed columns you cannot get from the raw tables. They are built in your browser from data already on the page, so they are instant and do not count toward your monthly exports.
| Page | What you can download |
|---|---|
| Shortages Tracker > Supply gaps | Supply-gap opportunities: suppliers and whether that count is a floor, supplier tier, ANDA generics, RLD flag, duration in days, Medicare Part D prescriber lines, NADAC baseline and current price, score. Respects the panel's own filters |
| Shortages Tracker > Market exits | Quiet market exits: labelers exited (parent companies), sample labelers, NDCs terminated and scheduled, last termination, single-source share, NADAC change |
| Shortages Tracker > Manufacturers | Manufacturer reliability: molecules short now, structural shortages, median open age, discontinuation notices, Medicaid rebate terminations, risk score |
| Radar | Export CSV: the drugs on the board with tier, generic or biosimilar makers, ANDA listings, staged generics, first generic year, protection end and months remaining, NADAC price and generic savings, shortage and recall status, Medicare Part B paid. Add N dates to calendar saves protection end dates as a calendar file |
| Patent Cliff | Markets opening and Supply gaps: contestability, generic makers and ANDA listings, staged generics, marketed generic labelers, market-open date, shortage status, Part D spend, the at-generic-price range, and sampled top prescribers where shown |
| Safety-Net Intel | The by-state summary, and the site list with operator, location, status, NPI, Medicare billing number and BPHC number |
| EHR Intelligence | Most panels: hospital finder results and a hospital's module stack, vendor directory, market share, migration and upgrade lists, territory planner targets with contact detail, shared-stack bundles, and vendor and developer pages |
| Provider record | Market Signals and Patent Cliff tabs |
| Map, Insights, NPI Match | The coverage table on the Map (Export CSV), the answer rows of an Insights question, and NPI Match results |
The Map's Export (layer) in N states button is different: it runs a table export for the selected states, so it follows the 1,000-row cap (shared across the states) and counts as one export.
Plan limits
| Plan | Exports per month |
|---|---|
| Regular | 100 |
| Pro | Unlimited |
| Teams | Unlimited |
Table exports, the Map's selected-states export and Excel workbooks each count as one export. Samples, panel downloads and incomplete exports do not. Every export is capped at 1,000 rows regardless of plan. Your export count is shown on the Usage page.
Notes
- In CSV files, values containing commas, quotes or line breaks are quoted and escaped correctly.
- In CSV files, values that begin with
=,+,-or@are prefixed with an apostrophe, to prevent spreadsheet formula injection. - Multi-value filters are translated from the pipe form used in the URL to comma form for the export request.
- Missing values export as empty in CSV files, not as
--.