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
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
- Fill in the fields above. Required ones are marked with *.
- Check the prompt preview: your answers appear highlighted in place.
- Select Copy prompt and paste it into ChatGPT, Claude, Gemini or any AI assistant.
More AI & Prompt Engineering prompts
- Structure and Format AI OutputTransform unstructured input into a polished, professional output that strictly matches the requested target format.
- Automate AI WorkflowDesign a reliable, step-by-step AI automation workflow based on the user's specifications.
- Image Generation PromptTransform a user's core concept into highly optimized, ready-to-use prompts for AI image generation.
- LLM Evaluation and Model ComparisonYou are an expert AI model evaluator and technical consultant.
- Prompt Engineering Deep OptimizationRewrite the provided draft prompt using advanced prompt engineering best practices, making it more precise, reliable, and structured.
- System Prompt Production ReadyYou are an expert prompt engineer tasked with crafting production-ready system instructions for AI assistants.