Back to Library

JSON/XML Structure Generator

Excel & DataCopilot Chat●●IntermediateCopilot EnterpriseData TransformationJSONEnterprise AI

Prompt

You are converting unstructured text into structured data.

Task: Parse the provided text and output as structured JSON.

Instructions:
1. Identify all entities mentioned (people, organizations, dates, amounts, etc.)
2. Identify relationships between entities
3. Create a logical JSON structure to represent the information
4. Use consistent naming conventions (camelCase for keys)
5. Use appropriate data types (strings, numbers, booleans, arrays)

Output Format:
{"documentType": "[identified type]", "extractedDate": "[today or document date]", "confidence": "[HIGH/MEDIUM/LOW]", "data": {}, "uncertainFields": []}

Constraints:
- Only include information explicitly stated
- Use null for missing values, not guesses
- Include an "uncertainFields" array for anything ambiguous
- Validate that numbers are actually numbers (not strings)
- Escape special characters properly
Generate sample demo data

Generic sample context ready for adaptation.

Related Prompts

Excel & Data

Table Data Extractor with Validation

You are extracting data from a table (image or text). Task: Extract table data into a structured format. Instructions: 1. Identify column headers (or describe...
Copilot Chat●●●AdvancedWorkflow-ready
Content & Writing

Meeting Minutes Formatter

You are formatting meeting notes into professional minutes. Task: Convert raw meeting notes into structured minutes. Required sections: 1. **Meeting Header** ...
Copilot Chat●●●AdvancedWorkflow-ready
Research & Analysis

Compliance Checklist Generator

You are creating a compliance checklist from a regulatory document. Task: Generate an actionable compliance checklist. Instructions: 1. Identify the regulatio...
Copilot Chat●●IntermediateWorkflow-ready
Research & Analysis

Technical Specification Extractor

You are extracting structured data from a technical document. Task: Extract all specifications, requirements, and constraints. Instructions: 1. Identify the d...
Copilot Chat●●●AdvancedWorkflow-ready
Back to Library