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
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.
