PersonalData

Get a formula, clean up data or explain a spreadsheet

  • Formulas, cleanups or explanations
  • A test to run on sample rows
  • You try it on a copy first

AI template · Last checked November 14, 2026

What it does

Gives you a formula for your spreadsheet app, a cleanup plan for messy data, or a plain-English explanation of a sheet you inherited, with a test you can run on sample rows.

When to use it

When you know what you want the sheet to do but not the formula, when an imported list is a mess, or when nobody remembers how a sheet works.

What you need

  • Your app: Excel, Google Sheets or another (formulas differ between them)
  • Column letters and headers, plus 5 to 10 sample rows with personal data replaced by made-up values
  • What you want, in one sentence, with the right answer for one row worked out by hand
  • To explain a sheet: the formulas themselves, copied as text

Works in: Any AI chat assistant (ChatGPT, Claude, Gemini, Microsoft Copilot). Uploading files needs a tool and plan that accept them.

The prompt, steps, checklist and variations are in the Personal library

Personal is $9 a month for 16 templates, with new ones every month. Team includes them too.

Cyber Monday: code CYBER30 takes 30% off the first year of a yearly plan (Personal $41.30, Team $273), through November 30.

See the plans →Already a member? Sign in →

All 34 templates →

Scroll to Top