wowprompt

Data dictionary for a spreadsheet or database table

Documents every column of a spreadsheet or table with its meaning, type, allowed values and example, and flags columns that are unclear or inconsistent. Use it when sharing data with a new team member, an analyst or an agency so nobody misreads a column.

A data dictionary table with column name, plain meaning, data type, allowed values, example, source and owner, followed by a list of data quality questions
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Dataset name and purpose: [e.g. orders sheet used for weekly sales reports]
  • Column headers: [paste the header row]
  • Sample rows: [paste 10 to 20 rows with personal details removed]
  • What you know about the columns: [notes or none]
  • Who maintains the data: [team or role]

Task

Write a data dictionary that a new person could use to read and query this data correctly.

Method

  • Infer the type and format of each column from the sample rows.
  • Where the meaning is not obvious, give the most likely meaning and mark it "to confirm".
  • Look for mixed formats, blank values, codes without a key and columns that seem to duplicate each other.

Output format

| Column | Plain meaning | Data type | Format or unit | Allowed values or range | Example | Can be blank | Status (confirmed or to confirm) |

Then:

  • Data quality questions to ask the owner, one per unclear column.
  • Suggested column renames for any confusing names.

Rules

  • Never copy personal data from the sample rows into the examples; use made-up values in the same format.
  • Dates state their format, such as DD-MM-YYYY.
  • Money columns state the currency and whether tax is included, or mark it "to confirm".
  • Do not guess meanings for codes; list them for the owner.

Example

order_status | Current stage of the order | Text | Code | NEW, PAID, SHIPPED, RETURNED | SHIPPED | No | To confirm

data dictionarycolumn definitionsspreadsheet documentationdatabase documentationmetadata templatedata catalogue

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity