Lesson 4 of 8 · Prompt Writing That Works
Asking for Structure: Tables, Checklists and Data
Get AI answers as tables, checklists, step-by-step guides or data you can paste straight into Excel, instead of long paragraphs.
Long paragraphs are hard to use. A table you can scan, a checklist you can tick, or data you can paste into Excel is far more useful at work. The good news: the AI will give you almost any structure you ask for, as long as you ask clearly.
Tables
Name the columns you want. Otherwise the AI picks its own.
Compare ChatGPT, Gemini, Claude and Microsoft Copilot for a small office.
Give a table with columns: Tool, Best for, Works inside, Free plan (Yes/No),
One limitation. Keep each cell under 12 words.
Tip: keep cells short. Long sentences inside tables are hard to read on a phone.
Checklists
Checklists work well for processes you repeat.
Create a month-end closing checklist for a small trading company that uses
Tally. Group it under: Before closing, Reconciliation, Reports, After closing.
Use checkboxes (☐) and keep each item to one line.
Always check the content against your own process. The AI gives a good starting structure, not your company's rules.
Step-by-step guides
For instructions someone else will follow, ask for numbered steps and say who the reader is.
Write numbered steps for a new employee to submit a leave request in our
HR portal. Assume they have never used it. One action per step. Add a
"Common mistakes" section with 3 points at the end.
Data for Excel (CSV)
When you want to paste the result into a spreadsheet, ask for CSV: plain text with values separated by commas.
From the text below, extract every invoice mentioned. Output CSV only, no
explanation, with the header row:
InvoiceNo,Customer,Date,Amount
Use DD-MM-YYYY for dates and numbers without commas or the ₹ sign.
"""
[paste email or notes]
"""
Copy the result into Notepad and save it as invoices.csv, then open it in Excel. Or paste it into Excel and use Data → Text to Columns with comma as the separator.
Check the numbers. Extraction is one of the places where AI can quietly drop a row or misread a figure. Count the rows and spot-check totals against the original.
Mixing structures
You can combine structures in one answer:
Summarise this meeting transcript as:
1. Three-line summary
2. Decisions (bullet list)
3. Action items (table: Task, Owner, Due date)
4. Open questions (bullet list)
If something is not mentioned, write "Not mentioned". Do not guess.
Numbered sections tell the AI the exact order and keep the answer from rambling.
Ask for "only" the structure
AI assistants like to add friendly introductions and conclusions. When you only want the output, say so:
Return only the table. No introduction or closing sentence.
Practice task
Take one piece of information you currently handle as text, such as an email thread, meeting notes or a list of payments. Ask the AI to turn it into one table and one checklist, or into CSV that you then open in Excel. Check every row against the source.
Key takeaways
- Name the columns for tables and the groups for checklists.
- Ask for numbered steps, one action per step, for instructions.
- Ask for CSV with a fixed header to move data into Excel.
- Say "only the table" to skip the extra chat, and always check extracted numbers.
Finished this lesson?Mark it complete to track your progress on this device.