Excel data dictionary prompt

excel-data-dictionary-prompt.txt

Goal:
Analyze an Excel workbook and generate a structured data dictionary describing all structured Excel tables it contains.

Inputs:
Excel file: [Upload workbook]

Task: Create a Simple Data Dictionary for This Workbook

Instructions:

1. Look through the entire workbook.
2. Find all structured Excel tables (ignore normal cell ranges).
3. Count how many structured tables there are.
4. For each table:
   - Give the table name.
   - Give the worksheet name.
   - List the column headers.
   - Briefly describe what the table seems to track (1–2 sentences).

Output Format:

Total Structured Tables: <number>

Table Name: <TableName>
Worksheet: <SheetName>
Columns:
- Column1
- Column2
- Column3

What This Table Appears To Track:
<Short plain-English description>

Rules:
- Only include structured Excel tables.
- Do not modify the workbook.
- Do not output JSON.
- Do not use Markdown tables.
- Keep descriptions short and clear.