Structured Data Extractor Prompt

Generate a highly reliable, loop-ready prompt that extracts structured data from unstructured text based on the user's specifications.

Category
AI & Prompt Engineering
Output
Text
Fields
3
  • prompt-engineering
  • data-presentation
  • content-structuring
  • automation-planning
  • output-optimization

Fill in the details

e.g., emails, customer reviews, resumes, receipts, or support tickets

List the exact data points you need extracted, one per line or comma-separated

Choose how the extracted data should be structured

Prompt

You are an expert prompt engineer and data extraction specialist. Your task is to generate a highly reliable, loop-ready prompt that extracts structured data from unstructured text based on the user's specifications. Inputs: - Source type: Source type - Target fields: Target fields - Output format: Output format Instructions: 1. **Extraction Prompt**: Draft a precise, ready-to-use prompt that instructs an AI to parse Source type and extract exactly the specified Target fields. Define the schema clearly. 2. **Data Handling Rules**: Establish strict guidelines for missing, ambiguous, or malformed data. Explicitly state whether to use `null`, skip the field, or flag it for review. Prohibit guessing or inventing data. 3. **Examples**: Provide 1–2 concise examples showing raw input and the exact desired output in the requested format. 4. **Multi-Record Handling**: Include clear logic for identifying and extracting multiple distinct records when they appear in a single input block. 5. **Validation Note**: Add a brief checklist explaining how to verify the output's accuracy and consistency before downstream use. Format Rules: - If Output format is JSON: instruct the AI to return only valid JSON, with no Markdown code fences or extra text. - If Output format is CSV: specify the delimiter, quoting rules, and header row. - If Output format is a table: instruct the AI to output a standard Markdown table. Output Structure: Return your response in the following sections: - **Extraction Prompt**: [The ready-to-use prompt] - **Data Handling Rules**: [Rules for missing/ambiguous data] - **Examples**: [Input → Output] - **Multi-Record Logic**: [Instructions for batch processing] - **Validation Checklist**: [Verification steps] Ensure the generated prompt is modular, precise, and optimized for automated looping. Do not add fields, assumptions, or external data beyond what is provided.

How to use this prompt

  1. Fill in the fields above. Required ones are marked with *.
  2. Check the prompt preview: your answers appear highlighted in place.
  3. Select Copy prompt and paste it into ChatGPT, Claude, Gemini or any AI assistant.
See all AI & Prompt Engineering prompts