JSON/XML Structure Generator
Converting documents or text into machine-readable formats
The 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 properlyHow to use it
- 1Select Copy the prompt above.
- 2Paste it into Microsoft 365 Copilot.
- 3Replace anything in brackets with your own detail, then send it.
Copilot gathers and drafts. You verify and decide. Check every figure, name and date against the system it came from before you act on it.
Written for
Developer, Data Engineer, Business Analyst, Integration Specialist
More for Copilot Enterprise Prompts (Standalone)
See all 16 promptsFrom the source collection in awesome-microsoft-copilot-prompts, licensed CC BY-SA 4.0.