JSON/XML Structure Generator
Excel & DataAny AI ToolCopilot 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