#16data analysis
Analyze My Spreadsheet or CSV
Finds trends, anomalies, and useful decisions in an uploaded spreadsheet with transparent calculations.
Base prompt
I will upload an Excel or CSV file. Help me answer [business or personal question]. Inspect the sheet names, column meanings, date ranges, units, missing values, duplicates, and outliers before calculating anything. Ask only for clarifications that change the result. Clean and transform the data without silently deleting rows, and show the method and row counts before and after. Calculate relevant totals, rates, trends, segments, and comparisons; verify formulas and reconcile totals. Use readable tables and the most suitable charts, with labels and units. Separate findings supported by the data from possible explanations. Flag data quality limits and avoid claiming causation from correlation. End with the three most useful insights and specific next actions. If possible, deliver an updated spreadsheet with formulas and a summary tab while preserving the original data.Follow-up steps
- 1
Validate the key result
Catches calculation and filtering mistakes in high-impact findings.
step 1Recalculate the most important finding independently using a second method. Show the formula, source rows or columns, and any discrepancy before finalizing the conclusion.
Comments0
No comments yet.
