Spreadsheets and dataIntermediate

Tidy up messy data

Plans the steps to clean a messy sheet, with a formula for each step.

This prompt comes with Pro

Pro members get the whole prompt, tips for a better answer and an example filled in, for this and 63 more Pro prompts.

Pro opens on 1 April 2027.Join the waitlist

Already have Pro? Sign in

Before you paste it in. Leave out names, contact details, passwords and anything confidential. At work, use the AI tools your employer has approved, and check what comes back before you rely on it. Using AI at work safely

More on this kind of job: AI for spreadsheets: formulas, tidy data and quick analysis, a free Learning Hub guide.

Spotted a problem with this prompt? Tell us and an editor will check it.

More prompts for spreadsheets and data

BeginnerFreeWrite a spreadsheet formulaTurns what you want a cell to work out into a formula, with an explanation.
IntermediateFreeFind what your survey results are sayingSpots the patterns in survey results and suggests what to look into next.
AdvancedFreeAnalyse a dataset with an assistant that runs codeGets an assistant that can run code to explore your data and show its working.
BeginnerPro promptExplain a formula someone else wroteBreaks down a confusing formula so you can trust it, or fix it.
IntermediatePro promptChoose the right chart for your dataRecommends a chart that makes your point clearly, and how to build it.
IntermediatePro promptSummarise a big table with a pivot tableWalks you through a pivot table that answers your question.
AdvancedPro promptMake a simple forecast you can explainBuilds a forecast with cautious, likely and hopeful cases, and shows its assumptions.

All the prompts for spreadsheets and data, on one page

Get AI explained at your level, every weekday

The five stories that matter, in plain English, with a prompt of the day. Free.

Subscribe free Find your level