Clinical Trial Data Lookup plugin

Published · Updated · Thomas Wood

Fast Data Science are pleased to announce the release Clinical Trial Data Lookup plugin for Google Sheets. It lets you look up data for multiple clinical trials by NCT ID and fills out information such as condition, sponsor, endpoints, or protocol URL in different columns.

How can I look up clinical trial data?

To look up clinical trial data for a single trial, you can search public registries like ClinicalTrials.gov for US or global studies, the EU Clinical Trials Register for European data, or the ISRCTN Registry for UK-focused research. You may have an ID such as the NCT ID in the case of US trials. You can find clinical trial protocols by keyword using the protocol finder at clinicaltrialrisk.org.

What if I want to look up trial data for multiple trials by NCT ID and fill it out in a spreadsheet?

For multiple trials, the most efficient approach is to use a spreadsheet plugin like the Clinical Trial Data Lookup plugin for Google Sheets by Fast Data Science.

You can enter a number of NCT IDs in column A (or whichever column you choose) in your spreadsheet, and the plugin will look up those NCT IDs and retrieve information on those trials and populate that information into columns.

The information is taken directly from the ClinicalTrials.gov API and so is up to date. The tool doesn’t use generative AI and is free from hallucinations.

I am a UK government body or an NHS trust. Can I use Fast Data Science’s products and services?

Please check out our listing on G-Cloud 15 https://www.applytosupply.digitalmarketplace.service.gov.uk/g-cloud/services/961759064594172 and the UK Digital Marketplace: https://www.applytosupply.digitalmarketplace.service.gov.uk/g-cloud-15/supplier/714844

Disclaimer

The data used in the Clinical Trial Data Lookup plugin comes from the ClinicalTrials.gov API. This plugin is not endorsed by the National Library of Medicine or NIH.

Clinical Trial Data Lookup Google Sheets™ Plugin

Install plugin

Install “Clinical Trial Data Lookup”, the free Google Sheets™ plugin for looking up clinical trial data

De-risking clinical trial protocols with the Clinical Trial Risk Tool

Fast Data Science have also developed the Clinical Trial Risk Tool, a tool to analyse clinical trial protocols in PDF format. You can upload a trial protocol and generate a site budget and risk score.

Create a site budget

Review your schedule of events

Upload your clinical trial protocol in PDF form, check the risk assessment, and generate a site budget.

Other useful Google Sheets plugins by Fast Data Science

You may also be interested in the UK Company Details Google Sheets plugin, which fills out information about UK registered companies into a Google Sheet, and the Drug Name Recogniser Google Sheets plugin, which lets you look up drug properties by name.

Unlock Your Future in NLP!

Dive into the world of Natural Language Processing! Explore cutting-edge NLP roles that match your skills and passions.

Explore NLP Jobs

Fast Data Science appointed as official supplier on AI Framework
Data science consulting

Fast Data Science appointed as official supplier on AI Framework

Fast Data Science Ltd has officially been accepted onto the Artificial Intelligence DPS (Dynamic Purchasing System) framework as an Appointed Supplier. This status validates our ongoing commitment to delivering cutting-edge AI, machine learning, and data science solutions, while making our services directly accessible to contracting authorities across the UK public sector.

Fast Data Science available for UK government procurement
Ai for business

Fast Data Science available for UK government procurement

Fast Data Science is listed on the UK Government’s Digital Marketplace under the G-Cloud 15 Framework and Digital Outcomes 6 as well as the Artificial Intelligence DPS.

Harmony Meta at DRIVE-Health on 24 September 2026
Ai in researchEvents

Harmony Meta at DRIVE-Health on 24 September 2026

Thomas Wood, director of Fast Data Science, and Dr Bettina Moltrecht of UCL will be appearing at DRIVE-Health, an event hosted at Kings College London, to present Harmony Meta on 24 September 2026.

What we can do for you

Transform Unstructured Data into Actionable Insights

Contact us