/cleandata

Gives step-by-step instructions to tidy messy data.

The full prompt

/cleandata Give me step-by-step instructions to clean this data in [Excel or Google Sheets]. The problems: [describe the mess]. Here are a few sample rows with fake values: [sample rows]. For each problem, give the formula or menu steps, in the order I should do them. Remind me to work on a copy.

Replace the highlighted [brackets] with your own details, then send.

What you're asking

You ask for a cleanup recipe for messy data. You get ordered steps with formulas or menu clicks.

Give it

  • Excel or Google Sheets
  • Each problem in the data
  • A few sample rows with fake values

Check: Use sample rows, not real personal data, and clean a copy of the file first.

Filled-in example

/cleandata Give me step-by-step instructions to clean this data in Google Sheets. The problems: names in mixed case, extra spaces, and duplicate rows. Here are a few sample rows with fake values: " jANE doe ", "John SMITH", "John SMITH". For each problem, give the formula or menu steps, in the order I should do them. Remind me to work on a copy.

Use it in any AI chat. The slash word is a label, not a built-in command; the prompt does the work, and answers vary by app. How these work