--- title: "Formatting outputs: getting the shape you need" description: "Format is part of the request A great answer in the wrong shape still creates work. If you need a table for a spreadsheet, a bullet list for a slide, or…" url: https://optimizeall.com/learn/prompt-engineering-foundations/formatting-outputs updated: 2026-10-05 --- Prompt Engineering Foundations · Iterating and formatting outputs · lesson 6 of 16 · 10 min # Formatting outputs: getting the shape you need ## Format is part of the request A great answer in the wrong shape still creates work. If you need a table for a spreadsheet, a bullet list for a slide, or plain text for WhatsApp, say so. AI assistants can produce almost any text format when asked clearly. ## Common formats and how to ask **Bullet points:** "Summarise in 5 bullet points, each under 15 words." **Numbered steps:** "Give me step-by-step instructions, numbered, one action per step." **Tables:** "Put this in a table with columns: Product, Price, Main benefit, Best for." **Email:** "Write it as an email with a subject line, greeting, 2 short paragraphs and sign-off." **Headings:** "Organise the answer under three headings: Problem, Options, Recommendation." **Plain text:** "Plain text only, no bullet points, bold text or headings; I'm pasting it into a text message." **Spreadsheet-ready:** "Output as comma-separated values with a header row, so I can paste it into a spreadsheet." **Checklist:** "Make it a checklist with tick boxes I can print." ## Length control Be explicit and realistic: - "One sentence." - "Under 50 words." - "About one page." - "3 short paragraphs." AI is better at counting items (bullets, paragraphs) than counting exact words, so use structure-based limits when precision matters. ## Tone and reading level Tone is also format: - "Friendly and casual, like a message to a colleague." - "Formal, suitable for a government office." - "Plain English; explain any technical term in brackets." - "Suitable for a reading age of about 12." ## Language You can ask for outputs in any major language, or in two at once: ```text Write the announcement in English, then the same message in Urdu, keeping the meaning identical. ``` For important translations, such as legal notices, medical instructions or contracts, have a fluent human check. AI translation can be very good but can miss nuance or local terms. ## Show the format with a template If you need an exact structure, give a template for the AI to fill: ```text Fill in this template for each of the 3 suppliers in my notes: Supplier: Price per unit: Delivery time: Strengths: Concerns: Recommendation (Yes/No/Maybe): ``` This is extremely reliable because there is little room for interpretation. ## Worked example: meeting notes to action table A project coordinator pastes messy meeting notes and asks: ```text From the notes below, create a table with columns: Action | Owner | Deadline | Status. If no deadline was mentioned, write "Not set". Then, below the table, write a 2-sentence summary for people who missed the meeting. NOTES: --- (paste notes) --- ``` Notice the instruction for missing information ("Not set"). Without it, the AI may invent a deadline to fill the column. Telling it what to do when information is missing is a simple habit that prevents made-up details. ## Formatting for where it will be used Think about the destination: - **Slides:** short bullets, no long sentences, one idea per bullet. - **Social media:** platform length norms, line breaks, hashtags if appropriate. - **Voice or video scripts:** written for speaking, short sentences, no bullet points or symbols. - **Emails:** subject line, short paragraphs, clear request. - **Documents:** headings, logical sections. Tell the AI where the text will go: "This will be read aloud in a 30-second video." ## Common formatting mistakes - Asking for a table but not naming the columns. - Not saying what to do with missing information. - Forgetting the destination, so text for a chat message arrives full of headings and bold. - Expecting exact word counts; check and adjust. ## Quick practice Try asking for the same information in two shapes, for example "a 5-bullet summary for my manager" and "a 3-sentence WhatsApp update for the team". Comparing them side by side trains your eye for which format suits which reader, and you will quickly start specifying format in your very first prompt instead of fixing it afterwards. ## Hands-on: one message, three destinations Paste some real information (a price list, an event plan, your notes) and send this: ```text Using the information below, produce three versions: 1. A table with columns: Item | Price | Notes. If a price is missing, write "TBC". 2. A WhatsApp message under 60 words, plain text, no bold or bullet symbols, with line breaks. 3. A 20-second voice-note script, written to be spoken, numbers written as words. INFORMATION: --- [paste here] --- ``` Compare the three. You are training yourself to name the destination in your first prompt. ## Getting data you can paste into a spreadsheet For data you will analyse, ask for a format that pastes cleanly: ```text Extract every order from the emails below into CSV with the header row: date,customer,product,quantity,amount_gbp Use ISO dates (YYYY-MM-DD). If a value is missing, leave it empty. Output only the CSV, nothing before or after it. ``` "Output only the CSV" stops the assistant adding friendly sentences that break your paste. Many assistants can also create a downloadable spreadsheet or document file directly; if yours can, ask for "a downloadable .xlsx file" and check it opens correctly. ## Formatting in right-to-left and mixed languages If you work in Arabic or Urdu, tell the assistant which language each part should be in and whether you need numerals in Western or Eastern Arabic style. Check the result in the app where it will be used, because right-to-left text can display differently in different apps. ## Tone presets you can reuse Save three tone descriptions that match your real needs and paste them when required: ```text TONE A (clients): warm, clear, professional; short sentences; no slang. TONE B (social): friendly, energetic, one emoji maximum, a question at the end. TONE C (internal): direct, bullet points, decisions and owners first. ``` ## How to check format quickly Before using an output, check the four things that most often go wrong: length, structure (are all the columns or sections there?), missing-information handling (did it invent anything to fill gaps?) and destination fit (does it look right where you will paste it?). ## Video lecture: Formatting outputs: getting the shape you need Video: [Formatting outputs: getting the shape you need](https://www.youtube-nocookie.com/embed/2tSc42qep8Q) — Format is part of the request A great answer in the wrong shape still creates work. If you need a table for a spreadsheet, a bullet list for a slide, or… 12 chapters · about 8 minutes · captions and full transcript below. 1. Formatting outputs 2. Why format matters 3. Name the format 4. Length, tone and language 5. Give a template 6. Say what to do when info is missing 7. Format for the destination 8. Practise: one message, three shapes 9. Spreadsheet-ready output 10. Example 1: a family trip plan 11. Example 2: 30 sales calls, 3 outputs (illustrative) 12. Recap ## Lecture transcript ### Formatting outputs A brilliant answer in the wrong shape still creates work. You wanted a table for a spreadsheet and got paragraphs. You wanted a WhatsApp message and got headings and bold text. In this lecture you will learn how to ask for exactly the format you need, how to control length and tone, how to use fill-in templates, and the one instruction that stops the AI inventing details to fill gaps. By the end, you will name the destination in your very first prompt. ### Why format matters Why does this matter so much? Because most of the time you spend on AI output is not reading it. It is reshaping it. Copying paragraphs into a spreadsheet cell by cell. Deleting headings before pasting into WhatsApp. Cutting a long answer down to fit a slide. Every one of those minutes is avoidable if you name the shape up front. Think of it like ordering at a tailor rather than buying off the rack: say the measurements first, and the result fits the first time. ### Name the format Format is part of the request, so say it plainly. Summarise in five bullet points, each under fifteen words. Give me numbered steps, one action per step. Put this in a table with the columns Product, Price, Main benefit and Best for. Write it as an email with a subject line, greeting, two short paragraphs and a sign-off. Plain text only, no bullets, bold or headings, because I am pasting it into a text message. Or output comma-separated values with a header row so I can paste it into a spreadsheet. ### Length, tone and language For length, remember the AI counts items better than words. One sentence. Three short paragraphs. Five bullets. Those are reliable. Exact word counts are approximate, so give a range and check. Tone is format too. Friendly and casual, like a message to a colleague. Formal, suitable for a government office. Plain English, explaining any technical term in brackets. And language: you can ask for English and then the same message in Urdu or Arabic, keeping the meaning identical. For legal, medical or contract translations, always have a fluent human check. ### Give a template When you need an exact structure, give a template for the AI to fill. For example, for each of the three suppliers in my notes, fill in: Supplier, Price per unit, Delivery time, Strengths, Concerns, and Recommendation yes, no or maybe. This is extremely reliable, because there is very little room for interpretation. Templates are also how you get consistent outputs week after week. ### Say what to do when info is missing Here is the most important formatting habit of all. Tell the AI what to do when information is missing. A project coordinator pastes messy meeting notes and asks for a table with Action, Owner, Deadline and Status. Without guidance, the AI may invent a deadline to fill the empty column. So she adds: if no deadline was mentioned, write Not set. That one line prevents made-up details. Use it everywhere: write unknown, write TBC, or ask me instead of guessing. ### Format for the destination Think about where the text will be used. Slides need short bullets, one idea each. Social posts need platform-appropriate length and line breaks. Voice or video scripts must be written for speaking, with short sentences and no symbols. Emails need a subject and a clear request. And if you need data for analysis, ask for CSV and add output only the CSV, nothing before or after it, so friendly sentences do not break your paste. Some assistants can also create a downloadable spreadsheet or document; if yours can, check that the file opens correctly. ### Practise: one message, three shapes A quick way to build this skill: ask for the same information in several shapes at once. Using the information below, give me a table, a WhatsApp message under sixty words in plain text, and a twenty-second voice-note script with numbers written as words. Comparing them side by side trains your eye for which format suits which reader. Also save a few tone presets you reuse, one for clients, one for social media, and one for internal updates. ### Spreadsheet-ready output One more practical scenario: getting data you can paste straight into a spreadsheet. Ask the assistant to extract every order from a batch of emails into CSV with a header row of date, customer, product, quantity and amount in pounds. Ask for dates in year, month, day format, empty cells for missing values, and add: output only the CSV, nothing before or after it. That last line stops a friendly introduction from breaking your paste. If your assistant can create downloadable spreadsheet files, you can ask for one directly, and then check it opens correctly. ### Example 1: a family trip plan First, a simple example. You have messy notes about a family trip: dates, hotel, flights, what to pack. You ask: organise these. You get paragraphs. Now ask for a shape: make a table with the columns Day, Plan, Booking reference and Notes, and if a booking reference is missing, write to confirm. Then a packing checklist grouped by adults and children. The information is identical, but now you can scan it, print it and share it with your family in seconds. Format is not decoration. It decides whether the answer is usable. ### Example 2: 30 sales calls, 3 outputs (illustrative) Now a business scenario, with illustrative numbers. Hassan runs sales for a small furniture supplier in Dubai and has notes from thirty sales calls this month. He needs three things: a table for his CRM, a summary for his manager, and a message for the team. He asks for all three. The table has the columns Company, Contact, Product interest, Budget in dirhams, and Next step, with not stated for any missing budget. The manager summary is five bullets: total pipeline, top three opportunities, and risks. The team message is under fifty words, plain text for WhatsApp. One prompt, three destinations. Because he asked for not stated, the table does not invent budgets, and when his manager asks how big the pipeline is, the number comes from real notes, not guesses. ### Recap To recap. State the format you need, with named columns or parts. Use item-based length limits and give ranges. Treat tone and language as format. Use templates for exact structures. Always say what to do when information is missing. And write for the destination. Try this now: take one piece of information you use often and ask for it as a table, a WhatsApp message and a thirty-second script. Then check length, structure, missing-information handling and destination fit. Next module: the modern features that make assistants far more powerful. ## Key takeaways - State the format you need: bullets, steps, table columns, email parts, plain text or spreadsheet-ready. - Use structure-based length limits (bullets, paragraphs) when precision matters. - Give a fill-in template for exact structures, and say what to write when information is missing. - Tell the AI where the output will be used: slides, social, voice script, email or document. ## Try it Take one piece of information you use often (a price list, notes, a plan) and ask the AI to produce it in three formats: a table, a WhatsApp message and a 30-second script. - [Previous: Iterating: the art of the follow-up](https://optimizeall.com/learn/prompt-engineering-foundations/iterating-in-conversation) - [Next: Quick answers, thinking modes and deep research](https://optimizeall.com/learn/prompt-engineering-foundations/quick-thinking-and-research-modes) - [All lessons of Prompt Engineering Foundations](https://optimizeall.com/learn/prompt-engineering-foundations)