Back to Library

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

More from Excel & Data

Excel & Data
Demo Data

The Excel Sales Analyzer

You are an expert sales performance analyst. I am sharing sales KPI data covering multiple regions and time periods. Analyze this data and produce the followin...
Excel
Excel & Data
Demo Data

The Excel KPI Dashboard Designer

Design a comprehensive KPI dashboard in Excel for [DEPARTMENT OR TEAM] at [COMPANY NAME]. I am uploading [DESCRIBE THE DATA: SALES / EXPENSE / OPERATIONS DATA]...
Excel
Excel & Data
Demo Data

The Forecasting Engine

You are a financial forecasting specialist. I am uploading historical sales/revenue data. Build a [NUMBER]-period forward forecast using the following approach...
Excel
Back to Library