100 Best ChatGPT Excel Data Analysis Prompts for Physiotherapists

Direct Answer

The best ChatGPT prompts for Excel data analysis for physiotherapists are designed to turn raw patient data into accurate, actionable insights. Use them to clean data, compute progress metrics, uncover trends, and build clinician-friendly reports. Each prompt includes role, task, placeholders, and concrete outputs to reduce guesswork.

Introduction

This page is a practical prompt library focused on Excel data analysis for physiotherapists. It helps clinicians and analysts turn spreadsheet data into actionable insights about patient progress, treatment effectiveness, and clinic performance.

Whether you manage a small clinic or a larger practice, these prompts provide repeatable, auditable workflows to analyze outcomes, track rehabilitation progress, and communicate results clearly to stakeholders.

How to Use These ChatGPT Prompts

• Replace placeholders like [industry], [audience], [product], [constraints], [data], [tone], and [format] with your actual data and preferences.
• Add constraints to define outputs precisely, such as date ranges, grouping, or formatting requirements.
• Request outputs in explicit formats like CSV, Excel tabs, or charts, and specify how many records to include.
• Verify results by spot-checking random samples and cross-checking key metrics against source data.
• Reuse prompts by cloning the workbook for different diagnoses, therapies, or timeframes and update the constraints as needed.

100 Best ChatGPT Excel Data Analysis Prompts for Physiotherapists

1. Import patient data: Role: Excel data analyst. Task: Create a unified patient dataset from multiple CSV exports. Context: The clinic records patient ID, age, sex, diagnosis, therapy type, session count, and outcome scores. Output: a clean table with deduplicated rows, standardized date format, and a summary row of missing values. Constraints: only include active patients from last 365 days; format: CSV and a brief audit notes section.
2. Cleanse patient IDs: Role: Data cleaner. Task: Normalize patient IDs to a consistent pattern PD-XXXX. Context: IDs come from three systems with inconsistent padding and separators. Output: a mapping table of old_id to new_id, and a sanitized main dataset. Constraints: preserve all existing attributes, log changes, and add a note about any duplicates resolved.
3. Standardize dates: Role: Data librarian. Task: Convert all dates to ISO format (YYYY-MM-DD). Context: Dates appear as MM/DD/YYYY, DD-MM-YYYY, and text like 'tbd'. Output: a date-corrected column and a report listing any non-convertible dates with reasons. Constraints: keep original column for reference.
4. Compute rehab progress index: Role: Data analyst. Task: Derive a Rehab Progress Index (RPI) per patient using baseline and latest outcome scores, scaled 0 to 100. Context: Outcomes include pain, ROM, and function scores. Output: a new RPI column and a cohort summary by diagnosis. Constraints: handle missing values by imputing median for each diagnosis.
5. Pivot by therapy type: Role: BI analyst. Task: Create a pivot table summarizing sessions per therapy type and average outcome improvement. Context: Data includes patient_id, therapy_type, session_count, baseline_score, followup_score. Output: pivot table with therapy_type as rows and metrics as columns. Constraints: show totals and count of patients.
6. Filter active patients: Role: Clinician data expert. Task: Filter dataset to patients currently active in treatment. Context: Active status indicated by 'status' column with values 'active' or 'completed'. Output: filtered dataset with 20 most recent sessions first. Constraints: exclude archived records.
7. Identify outliers: Role: Data scientist. Task: Flag outliers in progress scores using Tukey fences. Context: Baseline and latest scores available. Output: a list of patient IDs flagged with reason. Constraints: use whiskers method and provide recommended action.
8. Missing data audit: Role: QA analyst. Task: Produce a missing data report by column with percentage. Context: Columns include age, diagnosis, therapy_type, session_count, pain_score, function_score. Output: a table of columns with missing counts and suggested imputation strategy. Constraints: rank by impact on outcomes.
9. Visualize progress trend: Role: Data visualization expert. Task: Generate a line chart of average pain score over time per therapy_type. Context: Time series by week. Output: chart in PNG and a brief interpretation paragraph. Constraints: include a legend and axis labels.
10. Compare pre-post: Role: Outcome analyst. Task: Compute mean difference between baseline and latest pain and function scores by diagnosis. Context: Grouped by diagnosis with 95 percent CI. Output: table and chart-ready data. Constraints: annotate clinically meaningful thresholds.
11. Create clinical dashboard: Role: BI developer. Task: Build a compact dashboard showing patient load, average session count, and average RPI by therapy type. Context: Data refreshed daily. Output: dashboard-ready workbook with two tabs: data and visuals. Constraints: deliver in Excel with slicers for date range.
12. Export patient summaries: Role: Report generator. Task: Produce one-page summaries for each patient including demographics, diagnosis, therapy, progress, and next steps. Context: Compile into a multi-page workbook. Output: per-patient sheets or a combined PDF. Constraints: keep under two hundred words per summary.
13. Assess data integrity: Role: Data steward. Task: Run data integrity checks comparing source files to the master dataset. Context: Identify mismatches in patient_id and dates. Output: a discrepancy log with recommended fixes. Constraints: flag high-priority issues.
14. Forecast recovery window: Role: Prognostics analyst. Task: Estimate expected recovery window by therapy_type using historical data. Context: Use baseline scores and time-to-last-session. Output: forecast table with confidence intervals. Constraints: provide at least three scenarios.
15. Risk flags by diagnosis: Role: Clinical risk reviewer. Task: Identify diagnoses with slower progress than average. Context: Use RPI and session_count. Output: list of at-risk diagnoses with action recommendations. Constraints: provide minimal interventions.
16. Treatment protocol alignment: Role: Clinical auditor. Task: Check if therapy_type aligns with documented protocol for diagnosis. Context: Reference protocol table. Output: compliance score per patient and overall compliance rate. Constraints: highlight noncompliant cases.
17. Session cadence optimization: Role: Practice manager. Task: Recommend optimal session cadence to maximize RPI within 12 weeks. Context: Current cadence varies; use a simple optimization model. Output: recommended cadence per therapy_type.
18. ROM improvement tracker: Role: Physiotherapist data analyst. Task: Track range-of-motion improvements per joint across sessions. Context: Data includes joint, date, patient_id, ROM_score. Output: per-joint trend charts and top improvements.
19. Pain score heatmap: Role: Data viz specialist. Task: Create a heatmap of average pain scores by week and diagnosis. Context: Use weekly aggregates. Output: heatmap image and data table for export.
20. Functional score leaderboard: Role: Clinic analyst. Task: Rank patients by function score improvement within last quarter. Context: Include patient_id, diagnosis, therapy_type, baseline, followup. Output: ranked list and summary insights.
21. Daily data quality check: Role: Data ops. Task: Generate daily quality report for new imports. Context: Check row count, missing values, and duplicates. Output: summary metrics and corrective actions.
22. Cost per patient analysis: Role: Finance analyst. Task: Compute average therapy cost per patient and per session. Context: Include therapist, therapy_type, duration, and payer. Output: cost breakdown and chart-ready table.
23. Therapy effectiveness by age: Role: Outcome analyst. Task: Compare progress by age group for each therapy_type. Context: Age bands: under 18, 18-39, 40-64, 65+. Output: grouped statistics and visuals.
24. Diagnosis progression map: Role: Clinical mapper. Task: Map typical progression trajectories by diagnosis. Context: Use historical follow-up scores. Output: trajectory templates and a comparison table.
25. Data refresh checklist: Role: Data engineer. Task: Create a checklist for refreshing the Excel data source. Context: Include source files, mapping, validation steps. Output: a concise, repeatable checklist.
26. Outcomes by therapist: Role: Performance analyst. Task: Compare outcomes across therapists for the same diagnosis. Context: Normalize by patient baseline. Output: table and funnel chart.
27. Session duration analysis: Role: Operations analyst. Task: Analyze average session duration by therapy_type and correlate with outcomes. Context: Use last 12 months. Output: scatter plot and correlation metric.
28. Adherence patterns: Role: Behavioral analyst. Task: Identify patterns of missed sessions by patient segments. Context: Include reasons if available. Output: list of high-risk segments and mitigation ideas.
29. Data dictionary draft: Role: Data steward. Task: Draft a data dictionary for the Excel workbook with field definitions, formats, and valid ranges. Output: readable glossary and data validation rules.
30. Baseline versus follow-up: Role: Clinician researcher. Task: Calculate baseline vs follow-up improvement per patient and summarize by diagnosis. Output: table with effect size and minimal interpretation.
31. Pivot by diagnosis: Role: Analyst. Task: Create a pivot showing counts, average baseline, and average follow-up by diagnosis. Output: pivot with clear labels and totals.
32. Anomaly detection run: Role: Data scientist. Task: Run z-score based anomaly detection on outcome scores. Context: Output: a list of patients with anomalies and suggested checks.
33. Exportable progress report: Role: Report designer. Task: Generate a standardized progress report per patient suitable for emailing to guardians. Output: PDF per patient or consolidated PDF.
34. Seasonality check: Role: Analyst. Task: Test for seasonal effects in outcomes by month. Context: Use last 24 months. Output: summary and small chart.
35. Anonymized dataset ready: Role: Data privacy officer. Task: Create anonymized version of dataset for sharing with researchers. Context: Remove identifiers, replace with hashes. Output: anonymized workbook.
36. Treatment pathway mapping: Role: Clinical strategist. Task: Map typical treatment pathways from initial visit to end of therapy. Output: flow diagram data and transition counts.
37. Patient cohort comparison: Role: Research analyst. Task: Compare two cohorts by diagnosis and therapy_type on key outcomes. Output: side-by-side tables and charts.
38. Data export template: Role: Admin. Task: Create a reusable export template for sending to patients or insurers. Output: structured CSV with headers and sample data.
39. Gender-based outcome view: Role: Outcome analyst. Task: Analyze outcomes by gender within each diagnosis. Output: grouped statistics and charts.
40. Joint ROM trend chart: Role: Clinician analyst. Task: Chart trend of ROM improvements per joint across time. Output: per-joint line chart and data table.
41. Pain vs function map: Role: Clinical researcher. Task: Plot relationship between pain scores and function scores over time by therapy_type. Output: scatter with trend line.
42. Session gap analysis: Role: Data analyst. Task: Calculate gaps between sessions per patient and identify longest gaps. Output: table with alerts.
43. Therapy type adoption: Role: Practice manager. Task: Measure adoption rate of new therapy_type within a quarter. Output: adoption rate and contributing factors.
44. Custom report builder: Role: Report engineer. Task: Build a customizable report builder allowing selection of metrics and date range. Output: user-facing prompts for report fields.
45. Quality assurance pass: Role: QA engineer. Task: Conduct a QA pass on formulas, named ranges, and data connections. Output: QA report with fixes.
46. Data retention note: Role: Compliance officer. Task: Add a data retention note for each dataset with policy dates. Output: retention schedule.
47. Outcome forecast worksheets: Role: Forecaster. Task: Create forecast worksheets for next 12 weeks by therapy_type. Output: week-by-week projections with confidence bands.
48. Patient segments by goals: Role: Strategic analyst. Task: Segment patients by stated goals and map progress per segment. Output: table and heatmap.
49. Correlation matrix: Role: Data scientist. Task: Build correlation matrix for all numeric fields related to outcomes. Output: matrix with strong correlations highlighted.
50. Data cleaning checklist: Role: Data manager. Task: Produce a concise data cleaning checklist specific to physiotherapy datasets. Output: actionable steps.
51. Baseline cohort profile: Role: Clinician researcher. Task: Generate baseline profiles by diagnosis including age, gender, and initial scores. Output: summary table.
52. Follow-up scheduling forecast: Role: Clinic operations. Task: Forecast optimal follow-up scheduling to sustain progress. Output: suggested calendar blocks and patient groups.
53. Therapy-specific milestones: Role: Clinical guide. Task: List milestones achieved by therapy_type across patients. Output: milestone map and progress indicators.
54. Data anomaly notes: Role: Data detective. Task: For each anomaly, write a one-line note describing likely cause and fix.
55. Export to insurers: Role: Compliance/Finance. Task: Prepare an Excel report suitable for insurer claims with required fields. Output: insurer-ready workbook.
56. Missing value imputation: Role: Data analyst. Task: Propose imputation methods per column and apply on a copy of dataset. Output: imputed dataset and rationale.
57. Time-to-improvement metric: Role: Outcome analyst. Task: Compute time to reach a 20 percent improvement in function score. Output: per-patient metric and summary.
58. Clinic-wide stats: Role: Practice administrator. Task: Produce clinic-wide averages for key metrics this quarter. Output: summary table and one-page chart.
59. Patient retention heatmap: Role: Customer success. Task: Visualize 12-month retention by cohort. Output: heatmap and table.
60. Therapy success by region: Role: Market analyst. Task: Compare outcomes by region for each therapy_type. Output: regional comparison chart.
61. Outlier investigation plan: Role: Data investigator. Task: For each outlier, propose a simple verification plan before adjustment. Output: list of patients and steps.
62. Data sharing consent: Role: Privacy officer. Task: Ensure dataset shares do not include PII and record consent status. Output: compliance note.
63. Treatment effect summary: Role: Clinical analyst. Task: Summarize the average treatment effect per diagnosis and therapy_type. Output: concise table.
64. Workbook versioning: Role: Data steward. Task: Implement versioning scheme for the Excel file and log changes. Output: version log.
65. Gender progress gap: Role: Researcher. Task: Analyze gender differences in progress within each diagnosis. Output: table and notes.
66. ROM goals tracking: Role: Therapist. Task: Track ROM goals per patient with target dates. Output: progress board and alerts.
67. Session outcome scoring: Role: Clinician. Task: Assign a per-session outcome score by combining pain, function, and adherence. Output: score log.
68. Anonymized report pack: Role: Data broker. Task: Create a pack of anonymized patient reports for research. Output: zipped workbook.
69. Quality trend report: Role: QA lead. Task: Show trend of data quality issues by month. Output: trend chart and table.
70. Custom alerts: Role: BI engineer. Task: Create rule-based alerts for data quality and progress thresholds. Output: alert log and example messages.
71. Key metrics glossary: Role: Content architect. Task: Build glossary of metrics used in the workbook. Output: glossary sheet.
72. Data visualization kit: Role: Visualization specialist. Task: Prepare a kit of charts for quarterly review. Output: chart templates and data ranges.
73. Session density map: Role: Operations analyst. Task: Map session density by week and therapy_type. Output: density map and summary.
74. Demographics snapshot: Role: Market researcher. Task: Produce a demographics snapshot of patients in dataset. Output: summary table and bar chart.
75. Forecast accuracy check: Role: Data scientist. Task: Validate forecast accuracy against actuals for last 8 weeks. Output: accuracy metrics and notes.
76. Data reset procedure: Role: IT admin. Task: Outline safe data reset steps for test environments. Output: procedure document.
77. Therapy alignment score: Role: Compliance auditor. Task: Score therapy alignment with best-practice guidelines. Output: alignment score per patient.
78. Cohort growth analysis: Role: Growth analyst. Task: Measure cohort growth by diagnosis over time. Output: growth metrics and chart.
79. Data dictionary validation: Role: Data steward. Task: Validate data dictionary with actual workbook fields. Output: validation log.
80. Probability of recovery: Role: Biostatistician. Task: Estimate probability of reaching target function score within 12 weeks by diagnosis. Output: probability table.
81. Therapy utilization report: Role: Clinic ops. Task: Report therapy utilization rates per month by therapist. Output: utilization table and chart.
82. Data normalization pass: Role: Data cleaner. Task: Normalize numeric columns to z-scores for comparability. Output: normalized dataset.
83. Baseline cohort heatmap: Role: Visualization expert. Task: Create heatmap of baseline scores by diagnosis. Output: heatmap image and data table.
84. Follow-up reminder list: Role: Admin. Task: Generate reminder list for patients due for follow-up. Output: email-friendly list with dates.
85. Adverse event flagging: Role: Safety officer. Task: Flag potential adverse events from notes column using keywords. Output: alert list.
86. Outcome by BMI group: Role: Clinician researcher. Task: Compare outcomes across BMI groups within each diagnosis. Output: table and chart.
87. Clinic capacity forecast: Role: Operations planner. Task: Forecast clinic capacity for next quarter by therapy_type. Output: capacity chart and table.
88. Notes synthesis: Role: Clinician. Task: Synthesize free-text notes into structured fields for outcomes. Output: structured notes sheet.
89. Data access checklist: Role: IT auditor. Task: Check who accesses which data and when. Output: access log with findings.
90. Progress summary generator: Role: Clinician assistant. Task: Generate concise progress summaries for weekly team huddle. Output: short bullet list per patient.
91. Cohort retention analysis: Role: Data analyst. Task: Analyze retention by diagnosis and therapy_type over six months. Output: retention rates and charts.
92. Data export validation: Role: QA analyst. Task: Validate exported CSV against workbook schema. Output: validation report.
93. Therapy-specific benchmarks: Role: Clinical strategist. Task: Compare outcomes to published benchmarks by therapy_type. Output: benchmark table.
94. Data transformation script: Role: Data engineer. Task: Document a small transformation script for date normalization. Output: script and usage notes.
95. Quality scorecard: Role: QA lead. Task: Create a quality scorecard for the dataset with five metrics. Output: scorecard sheet.
96. Incident response plan: Role: IT security. Task: Draft a quick incident response plan for data issues. Output: plan outline.
97. Clinical insights brief: Role: Clinician analyst. Task: Produce a 300-word insights brief from the dataset highlighting actionable findings. Output: brief.
98. Session density dashboard: Role: BI analyst. Task: Build a per-week session density dashboard by therapy_type. Output: dashboard tabs and visuals.
99. Outcome stability check: Role: Outcome analyst. Task: Identify patients with unstable outcomes across two consecutive assessments. Output: list and suggested checks.
100. Clinical data roadmap: Role: Data strategist. Task: Outline a roadmap for expanding Excel analytics in physiotherapy practice over the next year. Output: roadmap bullets.

Best Practices

• Test prompts on a small data subset first to confirm outputs are correct and understandable.
• Document assumptions alongside results so clinicians can interpret data accurately.
• Keep transformations and calculations auditable with versioned sheets and change logs.

Common Mistakes to Avoid

• Forgetting to sanitize identifiers before sharing datasets with patients or insurers.
• Using vague outputs like totals without indicating unit, timeframe, or groupings.
• Overlooking data privacy and consent requirements when sharing results.

FAQ

What is the best way to start using these prompts?

Begin with Import patient data to establish a clean base, then progressively add analysis prompts to build a structured workflow.

How can I customize prompts for my clinic?

Replace placeholders with your actual diagnoses, therapy types, and date ranges; adjust constraints to match clinic policies.

Can these prompts handle multi-site data?

Yes, include a site column, group results by site in pivot tables, and ensure IDs are unique across sites.

Are the prompts safe for patient data?

Yes, apply anonymization, restrict access, and follow local privacy regulations before sharing results.

What formats should I export reports in?

Export to Excel for data reuse, and provide PDFs or summaries for stakeholders as needed.

How do I validate prompt outputs?

Spot-check a random sample, compare against source data, and verify that totals and averages align with expectations.