Analysing Spreadsheet and CSV Data with AI, Safely
Use structured prompts to inspect, clean and explore spreadsheet data, with independent checks and simple rules for keeping business data safe.
' stroke-width='16' fill='none' stroke-linecap='round'/%3E%3Crect x='230' y='40' width='100' height='84' rx='12' fill='%231d2130' opacity='0.75'/%3E%3Crect x='266' y='62' width='100' height='84' rx='12' fill='%231d2130' opacity='0.85'/%3E%3Crect x='302' y='84' width='100' height='84' rx='12' fill='%231d2130' opacity='0.95'/%3E%3Crect x='316' y='98' width='38' height='5' rx='2.5' fill='%23fff' opacity='.55'/%3E%3Crect x='316' y='112' width='49' height='5' rx='2.5' fill='%23fff' opacity='.55'/%3E%3Crect x='316' y='126' width='36' height='5' rx='2.5' fill='%23fff' opacity='.55'/%3E%3Crect x='316' y='140' width='49' height='5' rx='2.5' fill='%23fff' opacity='.55'/%3E%3Crect x='36' y='68' width='52' height='52' rx='12' fill='%231d2130'/%3E%3Ccircle cx='62' cy='94' r='7' fill='%2360a5fa'/%3E%3Cpath d='M341 28 l3 7 7 3 -7 3 -3 7 -3 -7 -7 -3 7 -3z' fill='%239333ea'/%3E%3C/svg%3E)
AI is fast at spotting patterns but can also make up numbers. Ask it to show its working and to suggest checks you can run yourself.
Key points
- Share column names and a small sample, not the full sensitive file.
- Ask for formulas or code you can run locally.
- Request a list of assumptions.
Try this prompt
You are a data analyst. Here are the column names and ten sample rows: [sample]. Suggest how to clean this data, the three most useful charts, and spreadsheet formulas to compute [metric]. List your assumptions.
Verify any surprising result by calculating it yourself before you share it.