Data Extraction Form Builder for Systematic Reviews: Word Form, Excel Template and Codebook
Design the data extraction form for your systematic review in minutes. Start from a template for randomised trials, observational studies, diagnostic accuracy or prevalence studies, add, remove and reorder fields, mark outcome fields to repeat for each study arm, and download a blank Word form for piloting, a CSV template that opens in Excel (one row per study) and a codebook for your protocol.
Quick add to the last section:
- PriceFree, no login or sign-up needed
- Your dataProcessed in your browser, never uploaded
- Works onPhone, tablet or computer, any modern browser
- Made byDr. Muhammad Aammar Tufail, Codanics
- Published17 November 2026
- Last updated16 November 2026
📚 How to cite this tool
This tool is free. If it helped your thesis, paper, report or assignment, please cite it. It keeps the tools free and helps other students find them.
Tufail, M. A. (2026). Data extraction form builder for systematic reviews: Word form, Excel template and codebook [Online tool]. Codanics. Retrieved 16 November 2026, from https://codanics.com/tools/data-extraction-form-builder/
In-text citation: (Tufail, 2026) · Narrative: Tufail (2026)
The access date is today’s date, filled in automatically. Author: Muhammad Aammar Tufail. Published 17 November 2026.
How to use the data extraction form builder
- Choose a template (randomised trial, cohort/case–control, diagnostic accuracy, prevalence or blank) and the number of study arms.
- Edit the sections and fields: rename them, change the field type, add options for choice fields, tick per arm for outcome data that you extract for each group, reorder or delete fields. Use the quick-add buttons for common fields.
- Click Preview and export to see the blank form.
- Download the Word form (or print to PDF) to pilot the form, the CSV template to extract into Excel (one row per study) and the codebook for your protocol or appendix.
- Save the form as JSON and send it to your co-reviewer so you both extract with exactly the same form. It is also saved automatically in this browser.
Why a piloted extraction form matters
The Cochrane Handbook (chapter 5) recommends extracting data with a form designed for the review, piloted on a few studies and used independently by at least two reviewers. A good form makes extraction faster, reduces errors and makes your review reproducible. PRISMA 2020 items 9 and 10 ask you to describe the data collection process and the variables you extracted, which is exactly what the codebook gives you.
What the templates contain
- Randomised trial: identification, methods, participants (per arm), interventions described with TIDieR prompts, outcomes with mean, SD, n and events per arm, and RoB 2 domains.
- Cohort / case–control: design, exposure and outcome definitions, confounders adjusted for, unadjusted and adjusted effects, and a risk-of-bias section (ROBINS-I/E, Newcastle–Ottawa or JBI).
- Diagnostic accuracy: index test, reference standard, the 2×2 table (TP, FP, FN, TN) and QUADAS-2.
- Prevalence: setting, sampling, case definition, numerator and denominator, and the JBI prevalence checklist.
Tips for extraction
- Extract the numbers you need for the meta-analysis directly (mean, SD, n per arm, or events and totals). If a paper reports a median and IQR, record it and convert later with the meta-analysis data converter.
- Record where in the paper each number came from (page, table or figure), especially when you extract from figures.
- Keep one CSV row per study (or per study arm comparison) so the file can go straight into R, Stata or the meta-analysis calculator.
- Compare the two reviewers’ extractions and resolve disagreements; check agreement on categorical items with the agreement calculator.
Frequently asked questions
Is there a standard Cochrane data extraction form?
Cochrane provides example forms and a checklist of items to collect (Handbook Table 5.3.a), but every review needs its own form. The RCT template here follows that checklist, so you can start from it and adapt it.
Can I extract in Excel instead of Word?
Yes. Download the CSV template: it opens in Excel with one column per variable. Use one row per study. The Word form is mainly for piloting and for reviewers who prefer paper.
How do I extract outcomes for each group?
Tick ‘per arm’ for a field. The form then shows one column per arm, and the CSV template gets one variable per arm, for example mean_intervention and mean_control.
Can my co-reviewer use the same form?
Yes. Click Save form (JSON) and send the file. Your co-reviewer opens it with Open form, so you both use identical fields and variable names.
Does this replace Covidence or SRDR+?
It gives you the form, template and codebook without an account or subscription. Covidence and SRDR+ add online collaboration and automatic comparison of two extractors, which require a server.
Is my form saved?
Yes, in this browser only. Nothing is uploaded. Download a JSON backup to keep it safe.
Do I need to log in or create an account to use the data extraction form builder?
No. There is no login, no sign-up and no email required. Open the page and start using it straight away, for free, on any device.
How do I cite this tool in my thesis or paper?
Use the citation box on this page. In APA 7th edition: Tufail, M. A. (2026). Data extraction form builder for systematic reviews: Word form, Excel template and codebook [Online tool]. Codanics. Retrieved [date you used it], from https://codanics.com/tools/data-extraction-form-builder/. BibTeX, RIS (EndNote, Mendeley, Zotero), MLA, Harvard, Chicago and Vancouver formats are also available.
Free guides and courses from Codanics
More free tools
See all free Codanics tools → · Codanics on YouTube · WhatsApp channel