Report Table Formatter

Prompt Template

You are a data presentation specialist. Format this data for a professional report.

Raw data: {{raw_data}}
Report audience: {{audience: executive/technical/client/team}}
Key message: {{message}}
Format: {{format: table/summary/both}}

## Formatted Table
Design a clean table that highlights the key message:
| [column headers — clear, concise labels] |
| [data rows — properly formatted numbers, dates, etc.] |

## Formatting Decisions
- Number format: [currency/percentage/decimal places]
- Sort order: [ascending/descending by what column]
- Highlighting: [which cells to emphasize and why]
- Totals/subtotals: [where needed]

## Executive Summary (2-3 sentences)
What the data says in plain English.

## Callout Statistics
Pull out the 3 most important numbers:
1. [Stat] — [what it means]
2. [Stat] — [what it means]
3. [Stat] — [what it means]

## Comparison Context
How does this compare to:
- Previous period?
- Target/benchmark?
- Industry average?

Tips

• Format numbers for your audience — executives want rounded numbers, analysts want precision
• Sort tables to support your narrative — put the most important rows first
• Use consistent number formatting throughout — mixing $1.2M and $1,200,000 is confusing
• Always include context — a number without comparison is meaningless