Task prompt · Data

Write a data dictionary for my dataset

by Agent Yard Team

Get a clear table that explains every column: meaning, type, allowed values and gaps.

You'll attach

Needs file

Works with

ChatGPTClaudeGeminiGrokCopilot

Use cases

  • Get a clear table that explains every column: meaning, type, allowed values and gaps.
  • When you already have a file and want the AI to work from it instead of starting from scratch.
  • As one step of the Make sense of your data prompt pack.

How to use it

  1. Open chatgpt.com or claude.ai (or another AI listed here).
  2. Attach the file (PDF, Word, CSV or Excel), or paste its text into the prompt.
  3. Copy the prompt, paste it into the chat and send.
  4. Works best with CSV or Excel files under a few thousand rows.

Prompt

Remix
Read the attached dataset and write a data dictionary for it.

For every column give:
- column name
- what it means in plain words (say "unclear" if you can't tell)
- data type (text, number, date, yes/no, ID)
- example values
- allowed values or range you observe
- share of empty or invalid values

Then list columns whose meaning I should confirm with whoever made the file. Don't invent meanings you can't support from the data.
One email a week

The best new prompts and personas, nothing else.

The Weekly is presented byyour brandSponsored · open

More Data prompts

Footer partner · openThis strip runs at the foot of every page. One partner at a time.Ask about it →