More Prompts:

Best prompts for ChatGPT using structured data-extraction templates

13 copy-ready prompts for extracting structured data (JSON/CSV/YAML) from text inputs: product listings, resumes, meetings, emails, contracts, medical notes, recipes, job postings, news, papers, e-commerce pages, and reviews. Each entry includes a concise explanation, a practical prompt you can paste, and a realistic input/output example.

Claude Sonnet 4
GPT-5
Claude Opus 4
Gemini 2.5 Flash
Gemini 2.5 Pro
You've probably spent hours wrestling with ChatGPT, trying to get it to extract clean data from messy text, only to receive inconsistent formats that break your workflow. You ask for JSON and get paragraphs, request specific fields and receive random outputs, or worse yet, get perfectly formatted data that's completely wrong. Sound familiar?
This collection of 13 battle-tested prompts transforms ChatGPT into your personal data extraction powerhouse, handling everything from product listings and resumes to medical notes and customer reviews. Each prompt comes with precise instructions that consistently deliver structured JSON, CSV, or YAML output you can actually use in your systems. Instead of fighting with inconsistent AI responses, you'll have reliable templates that turn any unstructured text into clean, actionable data every single time.
1
Product listing to JSON product object
Extract the product details from the following text and return a single JSON object with exactly these keys: sku (string), title (string), short_description (string, max 200 chars), price (number, USD), currency (string, 3-letter), categories (array of strings), availability (boolean), weight_kg (number or null), dimensions_cm (object with width, height, depth numbers or null), images (array of URL strings). If a field is not present, use null or an empty array as appropriate. Do not include any extra keys. Input: "<<<PRODUCT_TEXT>>>"
Extract key product attributes from a free-form product listing and return a validated JSON object with typed fields.
2
Resume parsing to structured candidate profile
Read the resume text inside <<RESUME>> and output one JSON object with these keys: name (string), contact {email, phone, location}, summary (string, max 160 chars), education (array of objects with degree, institution, start_year, end_year or null), experience (array of objects with title, company, start_month_year, end_month_year or 'Present', responsibilities (array of short strings)), skills (array of strings), total_years_experience (number, round to one decimal). Only populate fields you can infer. Use null for unknown values. Input: "<<RESUME>>"
Parse a resume/CV and produce a standardized JSON candidate profile including contact, education, experience (array), skills (tag list), and total_years_experience.
3
Meeting notes to action items table (CSV)
Analyze the meeting notes in <<NOTES>> and output a CSV (header row included) with columns: action_id (A1, A2...), description, owner, due_date (YYYY-MM-DD or empty), priority (Low/Medium/High), status (Todo/In Progress/Done). Only include clear actionable items. Do not add commentary. Input: "<<NOTES>>"
Convert meeting text into a CSV list of action items with owner, due_date, priority, status, and short description.
4
Email to structured JSON for CRM
Given the customer email text between <<EMAIL_START>> and <<EMAIL_END>>, return a JSON object with keys: from {name,email}, subject, received_date (YYYY-MM-DD if present), intent (one of: Support, Sales, Billing, Feedback, Other), urgency (Low/Medium/High), required_action (short instruction for agent), tags (array). Infer values conservatively and use null when not available. Input: <<EMAIL_START>> <<EMAIL_TEXT>> <<EMAIL_END>>
Transform an incoming customer email into a JSON object suitable for CRM ingestion: customer details, intent, urgency, required_action, and tags.
5
Contract key terms extraction (legal summary JSON)
From the contract text between <<CONTRACT>> extract a single JSON object with these keys: parties (array of objects with name and role), effective_date (YYYY-MM-DD or null), termination_date (YYYY-MM-DD or null), term_length (string or null), payment_terms (string or null), liability_limit (string or null), termination_for_cause (boolean), governing_law (string or null), auto_renewal (boolean). Provide null for unknowns. Input: "<<CONTRACT>>"
Extract key contract metadata (parties, effective/termination dates, payment terms, liabilities, governing_law) into a JSON summary for legal review.
6
Medical note to structured encounter record
Parse the clinical note provided in <<NOTE>> and output one JSON object with: patient_age (number or null), sex (Male/Female/Other/null), visit_date (YYYY-MM-DD or null), chief_complaint (string), diagnosis (array of strings), medications (array of objects: name, dose, route, frequency), vitals (object: bp, hr, rr, temp_c or null), plan (array of short strings). Use null for missing fields. Do not output PHI beyond age and sex. Input: "<<NOTE>>"
Convert a clinical note into a structured JSON encounter record focusing on diagnosis, meds, vitals, and next steps, preserving privacy-sensitive fields only as needed.
7
Recipe text to structured recipe JSON
From the recipe text in <<RECIPE>>, generate a JSON object with: title, servings (number or null), total_time_minutes (number or null), ingredients (array of objects: name, quantity, unit, notes), steps (array of ordered strings), dietary_tags (array of strings: Vegetarian/Vegan/Gluten-Free/Dairy-Free/Nut-Free/Contains-Meat/Other). Use null when unknown. Input: "<<RECIPE>>"
Extract ingredients, quantities, steps, times, servings, and dietary tags from a recipe and return a compact JSON object.
AI Flow Chat

Stop Losing Your AI Work

Tired of rewriting the same prompts, juggling ChatGPT and Claude in multiple tabs, and watching your best AI conversations disappear forever?

AI Flow Chat lets you save winning prompts to a reusable library, test all models in one workspace, and convert great chats into automated workflows that scale.

Teach World Class AI About Your Business, Content, Competitors… Get World Class Answers, Content, Suggestions...
AI Flow Chat powers our entire content strategy. We double down on what’s working, extract viral elements, and create stuff fast.
Video thumbnail

Reference Anything

Bring anything into context of AI and build content in seconds

YouTube

PDF

DOCX

TikTok

Web

Reels

Video Files

Twitter Videos

Facebook/Meta Ads

Tweets

Coming Soon

Audio Files

Coming Soon

Choose a plan to match your needs

Upgrade or cancel subscriptions anytime. All prices are in USD.

Basic

For normal daily use. Ideal for getting into AI automation and ideation.

$30/month
  • See what Basic gets you
  • 11,000 credits per month
  • Access to all AI models
  • 5 app schedules
  • Free optional onboarding call
  • 1,000 extra credits for $6
Get Started

No risk, cancel anytime.

ProRecommended

For power users with high-volume needs.

$100/month
  • See what Pro gets you
  • 33,000 credits per month
  • Access to all AI models
  • 10 app schedules
  • Remove AI Flow Chat branding from embedded apps
  • Free optional onboarding call
  • 2,000 extra credits for $6
Get Started

No risk, cancel anytime.

Frequently Asked Questions

Everything you need to know about AI Flow Chat. Still have questions? Contact us.