Practical guide · 5 minute read

How to Export ClinicalTrials.gov Data by Condition, Phase and Status

Export ClinicalTrials.gov data by condition, phase, recruitment status and sponsor as one row per study.

Key takeaways

  • To export ClinicalTrials.gov data, decide your filters (condition, recruitment status, phase, sponsor), pull the matching studies, and flatten them into one row per study keyed by NCT ID.
  • The registry is public and free. The work is in filtering precisely and turning nested study records into a clean table.
  • If you want that table on demand, my ClinicalTrials.gov Study Feed returns studies by condition, status, phase and sponsor as normalized rows for $0.02 per study row.

Need a study list right now? Run the ClinicalTrials.gov Study Feed on Apify.

What exporting ClinicalTrials.gov data means (and what it does not)

Exporting ClinicalTrials.gov data means taking studies from the public registry and putting them in a format you can work with: a spreadsheet, a CSV or a database table. One row per study, with the fields you care about in columns.

It is not the same as judging a study. The registry tells you what a sponsor registered: the condition, phase, status, locations and so on. It does not tell you whether a study is a good fit for a specific patient, and an export does not either. Treat the data as a starting point, not medical advice.

The filters that matter

  • Condition: the disease or health issue, for example type 2 diabetes.
  • Recruitment status: whether the study is recruiting, not yet recruiting, active but not recruiting, completed and so on.
  • Phase: Phase 1 through Phase 4, plus studies where phase does not apply.
  • Sponsor: the company, university or agency running the study.

The tighter your filters, the more useful the list. "Recruiting Phase 3 studies for condition X" is a list you can act on. "All studies for condition X" usually is not.

How to do it yourself: the method

  1. Write down your filters. Be exact about condition, status, phase and sponsor.
  2. Search the registry. You can run the search on the ClinicalTrials.gov website or query it programmatically.
  3. Pick your columns. At minimum: NCT ID, title, condition, status, phase, sponsor, start date and study URL.
  4. Flatten the records. Study records are nested (a study can have many conditions, locations and contacts). Decide how to fit those into one row, for example joining multiple values with a semicolon.
  5. Key on the NCT ID. Every registered study has one. Use it to dedupe and to match studies across exports.
  6. Re-run when you need fresh data. Statuses change. A study that was recruiting last month may not be now.

The search is the easy part. Flattening the nested records consistently, every time, is where most of the effort goes.

Your options compared

FeatureClinicalTrials.gov websiteYour own scriptClinicalTrials.gov Study Feed (Apify)
Filter by condition, status, phase, sponsorYes, in the search UIIf you write itYes
One normalized row per studyYou reshape itIf you write itYes
NCT ID per rowYesIf you include itYes
Re-run with the same filtersManual each timeIf you host itYes, start a new run
PriceFreeYour time plus hosting$0.02 per study row

Which option is best for whom

  • The website is best for reading a few studies in detail or a one-off search. Not for building a repeatable list you need to refresh and share.
  • Your own script is best for developers who want to control exactly how nested fields get flattened. Not for people who need a clean table this afternoon without writing and testing code.
  • The ClinicalTrials.gov Study Feed is best for recruitment teams, analysts, journalists and builders who want filtered studies as normalized rows. Not for anyone looking for medical advice or eligibility decisions, because it returns registry data, nothing more.

A worked example with real numbers

My live test of the feed returned 3 recruiting type 2 diabetes studies, each with its NCT ID. That is the test I am standing behind.

Cost math at the listed rate: those 3 rows cost $0.06. A list of 250 studies would cost $5.00. That is the listed price multiplied out, not a claim about how many studies exist for any condition.

Run your own condition: open the ClinicalTrials.gov Study Feed on Apify and set the filters you need.

How to choose

  • You want to read a handful of studies: use the ClinicalTrials.gov website.
  • You want to control every field and enjoy writing code: build it yourself with the method above.
  • You need filtered studies as clean rows, again and again: use the ClinicalTrials.gov Study Feed.

"Can't I just download the results from the website?"

You can export from the site, and for a one-off list that may be all you need. Where it gets tedious is repeating the same filtered export every week and reshaping nested fields the same way each time. A feed you can re-run with the same filters saves that repeat work.

FAQ

How do I export clinical trials to Excel?

Run your search, then export the results or pull them with a script, and save as CSV. The ClinicalTrials.gov Study Feed returns normalized rows you can export straight into a spreadsheet.

What is an NCT ID?

It is the unique identifier ClinicalTrials.gov assigns to each registered study. It starts with "NCT" followed by numbers, and it is the best key for matching studies.

How do I find recruiting clinical trials for a condition?

Filter by the condition and set the recruitment status to recruiting. The feed supports filtering by condition, status, phase and sponsor.

Is ClinicalTrials.gov data free to use?

The registry is a public resource and searching it is free. With the Study Feed you pay $0.02 per study row for the export and normalization.

Can this tell me if I qualify for a trial?

No. It returns registry data only. Eligibility is up to the study team, so talk to them and your doctor.

Get the study feed

ClinicalTrials.gov Study Feed on the Apify Store, $0.02 per study row.

More about the tool: ClinicalTrials.gov Study Feed product page