Windows, macOS, and Excel on the web
Pull live clinical trial, drug, and pipeline data into the models, trackers, and diligence sheets your team already uses. No copy-paste. No manual lookup. No stale tabs.
Fourteen CLARI formulas query ClinicalTrials.gov, PubMed, OpenFDA, WHO ICTRP, compare trials, explore biological targets, map competitive landscapes, pull company and emerging-intelligence summaries, and enrich your spreadsheets with structured clinical data. Open the side panel for interactive search and AI chat.
Watch formulas type themselves and return live results, or try the autocomplete, side panel, and ribbon yourself. All data below is fetched from real API endpoints.
Click Play to watch a CLARI formula type itself, execute, and return live data.
Type =CLARI. in the formula bar to see all fourteen functions with autocomplete. Pick one, add arguments, and press Enter to execute.
Search a trial in the panel, then click any field to insert it into the spreadsheet. This is how the taskpane works inside Excel.
Try one
Results show status, phase, sponsor, enrollment. Click any field to insert it into the sheet.
The add-in creates a dedicated ClariTrial tab in the Excel ribbon with one-click access to the panel, trial search, AI chat, and pipeline tools.
Click a ribbon button above to open the ClariTrial panel
Downloads a manifest file (XML, ~4 KB). Open Excel, go to Insert > My Add-ins > Upload My Add-in, and select the file. Full steps below.
BD, strategy, portfolio teams
Build a side-by-side view of every company in your target space. Use CLARI.LANDSCAPE to pull all programs for a target, then CLARI.DRUG to dig into specific compounds. Refresh to see movement over time.
=CLARI.LANDSCAPE("STAT6")=CLARI.DRUG("ARV-471", "phase")=CLARI.LANDSCAPE("ER", "count")=CLARI.COMPANY("Kymera", "ceo")=CLARI.PUBMED("protein degrader", "count")Clinical ops, investors, analysts
Start with CLARI.SEARCH to find trials in your space, then use CLARI.TRIAL to track status, enrollment, and completion dates. Use CLARI.COMPARE to spot differences between competing trials.
=CLARI.SEARCH("atopic dermatitis phase 3")=CLARI.TRIAL("NCT07217015", "enrollment")=CLARI.COMPARE("NCT07217015", "NCT07323654")=CLARI.TIMELINE("NCT07217015", "primaryCompletion")=CLARI.SAFETY("dupilumab", "seriousRatio")BD, investors, M&A, research teams
For due diligence on a target, pull the biological profile with CLARI.TARGET, see who else is working on it with CLARI.LANDSCAPE, and check the company's full pipeline with CLARI.PIPELINE.
=CLARI.TARGET("STAT6", "diseases")=CLARI.LANDSCAPE("STAT6", "company")=CLARI.PIPELINE("Kymera")=CLARI.REGISTRY("STAT6 degrader", "count")=CLARI.EMERGING("competition", "capabilities")Pick your inputs, watch the formulas type themselves into the sheet, then click Run to execute them with live data from ClinicalTrials.gov, curated profiles, and more.
Choose 2-4 biological targets, watch the formulas appear in the cells, then run them to pull full profiles side by side.
Pick a target and see every company working on it, with compound, modality, phase, and indication data.
Choose a preset search or type your own query to find clinical trials with status, sponsors, and dates.
Thirteen of the fourteen formulas return structured data from APIs, registries, and curated profiles. CLARI.ASK is the exception: it uses an AI model and should be treated as a starting point, not a verified answer.
Data: Trial status, phase, enrollment, sponsors, dates, conditions, interventions, results availability
How: Live REST API v2 queries. Results are cached for 30 minutes. Covers 470,000+ registered studies.
Data: Pipeline programs, phases, modalities, indications, trial associations
How: Manually curated from SEC filings, investor presentations, press releases, and ClinicalTrials.gov. Updated as companies disclose new data.
Data: Drug/compound names, targets, mechanisms, disease areas, partnership details
How: Curated from public disclosures across targeted protein degradation companies. Cross-referenced with ClinicalTrials.gov NCT IDs where available.
Data: Natural language answers about clinical trials and pharma
How: Uses Anthropic Claude or OpenAI GPT. Prompted to cite NCT IDs and be concise. Not grounded in a retrieval index; answers may reflect model knowledge, not only ClariTrial data.
CLARI.ASK sends your prompt to an AI model (Anthropic Claude or OpenAI GPT). The model is instructed to cite NCT IDs and answer concisely, but it is not retrieval-augmented: answers may reflect the model's training data, not only ClariTrial's sources. Treat AI answers as a research accelerant, not as a validated output. For regulated workflows, verify AI-generated content against primary sources before use.
Click the ClariTrial button in the Home tab to open an interactive panel inside Excel with three tabs.
Look up any trial by NCT ID. View all fields. Click a value to insert it into the active cell, or insert an entire trial as a row.
Ask questions about trials, drugs, and pipelines. Insert answers into cells. Useful for quick research queries without leaving Excel.
Search by company name and see all pipeline programs. Insert the full pipeline as a table, or pick individual programs.
All formulas use the CLARI namespace. Type =CLARI. in any cell to see available functions with autocomplete.
Look up a clinical trial by NCT ID. Returns a single field from the ClinicalTrials.gov record.
=CLARI.TRIAL("NCT12345678", "status")=CLARI.TRIAL("NCT07217015", "phase")Return pipeline data for a company. Use "count" for the program count, or omit the field for a full table (spills into adjacent cells).
=CLARI.PIPELINE("Kymera", "count")=CLARI.PIPELINE("Kymera")Look up drug/molecule data from the curated competitive landscape.
=CLARI.DRUG("KT-621", "mechanism")=CLARI.DRUG("ARV-471", "company")Ask a natural language question. Returns a plain-text answer with NCT IDs where applicable. AI-generated; see trust section below.
=CLARI.ASK("What are active Phase 3 NSCLC trials?")=CLARI.ASK("How many active trials does Kymera have?")Search ClinicalTrials.gov by keyword. Returns a spill-range table of matching trials, a single column, or a count.
=CLARI.SEARCH("NSCLC pembrolizumab", "count")=CLARI.SEARCH("atopic dermatitis phase 3")Compare two trials side by side. Returns a full comparison table or a single field comparison.
=CLARI.COMPARE("NCT07217015", "NCT07323654")=CLARI.COMPARE("NCT07217015", "NCT07323654", "phase")Look up a biological target profile. Returns data for Kymera's three clinical-stage targets: STAT6, IRAK4, IRF5.
=CLARI.TARGET("STAT6", "summary")=CLARI.TARGET("IRAK4", "diseases")TPD competitive landscape. Filter by biological target or return all programs across all companies. Returns a spill-range table.
=CLARI.LANDSCAPE("STAT6")=CLARI.LANDSCAPE("ER", "company")Search PubMed for publications by disease, drug, or target. Returns title, authors, journal, and PMID.
=CLARI.PUBMED("STAT6 degrader")=CLARI.PUBMED("atopic dermatitis IRAK4", "title")FDA adverse event data for any drug. Total reports, serious reports, top reactions, and serious ratio.
=CLARI.SAFETY("dupilumab")=CLARI.SAFETY("tofacitinib", "seriousRatio")Key milestone dates for a clinical trial: start, completion, first posted, last updated, results posted.
=CLARI.TIMELINE("NCT07217015")=CLARI.TIMELINE("NCT07217015", "primaryCompletion")Search 60+ international trial registries via WHO ICTRP (ChiCTR, EUCTR, JPRN, ANZCTR, and more).
=CLARI.REGISTRY("NSCLC immunotherapy")=CLARI.REGISTRY("ChiCTR-2300075821", "title")Company-level metadata: HQ, CEO, therapeutic focus, technology platform, pipeline count.
=CLARI.COMPANY("Kymera")=CLARI.COMPANY("Kymera", "ceo")Emerging drug intelligence pillars: competitive landscape, success prediction, improvement opportunities, stealth programs.
=CLARI.EMERGING("competition")=CLARI.EMERGING("stealth", "capabilities")For contributors and teams running ClariTrial locally.
Office.js requires HTTPS. For local development, install trusted dev certificates and edit the manifest to point to localhost.
1. Install dev certificates
2. Start the dev server
3. Edit manifest.xml: replace the host (macOS)
On Linux, omit the empty string after -i
After starting the dev server, sideload the modified manifest following the install steps above. Changes to the taskpane reload automatically via Next.js HMR.
The add-in does not load or shows a blank panel.
Make sure the manifest URL is reachable. For local dev, you need HTTPS with trusted certificates. Run npx office-addin-dev-certs install and restart Excel.
Formulas return #ERROR.
Check that the server is running and the API endpoints respond. Open your browser to /api/excel/trial?nctId=NCT07217015&field=status to verify.
CORS errors in the console.
The API routes include permissive CORS headers. If you see CORS errors, make sure you are loading the add-in from the same origin as the API.
CLARI.ASK returns 503.
The AI provider is not configured on the server. Set ANTHROPIC_API_KEY or OPENAI_API_KEY in your environment.
Custom functions do not appear.
Custom functions require Excel 2021 or later (or Excel on the web). Ensure the manifest includes the CustomFunctions extension point and functions.json is served correctly.
All formula and panel features are backed by these routes.
All routes return { value } on success and { error } on failure. CORS is open for all origins. No auth required in the current version.
Need formulas specific to your internal data, proprietary APIs, or team workflows? Code Studio can generate a complete Excel add-in project, including the Office manifest, task pane UI, and custom function definitions.