Plan the columns for a new tracker
Works with ChatGPT · Claude · Copilot
Design the right columns before you start a spreadsheet tracker.
The problem
Trackers get rebuilt because the columns were wrong from the start.
What this skill does
AI proposes columns, formats, and a key field for your tracking goal.
When to use it
- Use before building any new spreadsheet.
Juni’s tip
Juni says: design the columns first — retro-fitting them is painful.
The prompt
Try it live
Fill in the blanks — your ready-to-use prompt builds as you type.
Weak vs. better
what columns do I need
Design a tracker for [what I want to track and why]. Propose columns with their data type/format, mark the key identifier column, suggest a status or date field, and note 2 columns people usually forget. Show as a header row.
Why this works
Getting columns and formats right up front saves rebuilding the tracker later.
Practice task
Plan the columns for a tracker you need before building it.
Self-check
- Columns fit the tracking goal
- Each has a sensible data type/format
- A key identifier column is marked
Common mistakes to avoid
- Starting with no plan for columns
- Mixing data types in one column
- Forgetting a date or status field
You’re learning fast. Create a free account to continue your path.
Save your skills, keep your prompts, and continue building your AI skills one step at a time.
