10 Ready-to-Use Prompts for Data Extraction
These 10 starter prompts cover common extraction tasks. Adapt each prompt to your schema, test it on a representative sample, and use only data you are authorized to process.
Adapt These Starter Prompts
Copy any prompt below and paste it into AI Batch Processor. Replace {{input}} with your column reference.
Try It Now1. Email Address Extraction
Extract all email addresses from messy text data
Extract all email addresses from the following text. Return only the email addresses, one per line. If no emails found, return "No emails found".
Text: {{input}}
Emails:Contact us at support@company.com or sales@company.com
2. Phone Number Extraction
Extract phone numbers in various formats
Extract all phone numbers from the following text. Normalize them to the format (XXX) XXX-XXXX. Return one per line.
Text: {{input}}
Phone Numbers:Call us at 555-123-4567 or (555) 987-6543
3. Physical Address Extraction
Extract complete mailing addresses
Extract all physical addresses from the following text. Format each address as: Street, City, State ZIP. Return one address per line.
Text: {{input}}
Addresses:Our office is at 123 Main St, New York, NY 10001
4. Date Extraction
Extract and normalize dates to YYYY-MM-DD format
Extract all dates from the following text. Convert them to YYYY-MM-DD format. Return one per line.
Text: {{input}}
Dates:Meeting scheduled for March 15, 2024 and 04/20/2024
5. URL Extraction
Extract all URLs and web addresses
Extract all URLs from the following text. Include both http/https links and plain domain names. Return one per line.
Text: {{input}}
URLs:Visit https://example.com or www.test-site.org for more info
6. Name Extraction
Extract person names from text
Extract all person names from the following text. Return in format: First Last. Return one name per line.
Text: {{input}}
Names:Contact John Smith or Jane Doe for assistance
7. Company Name Extraction
Extract business and organization names
Extract all company/organization names from the following text. Return one per line.
Text: {{input}}
Companies:Partners include Microsoft, Google, and Amazon Web Services
8. Currency/Price Extraction
Extract monetary amounts and prices
Extract all monetary amounts from the following text. Normalize to format: $X.XX. Return one per line.
Text: {{input}}
Amounts:Price reduced from $99.99 to $49.95 - save $50!
9. Hashtag Extraction
Extract social media hashtags
Extract all hashtags from the following text. Include the # symbol. Return one per line.
Text: {{input}}
Hashtags:Join the conversation #AI #MachineLearning #DataScience
10. JSON Data Extraction
Extract structured data into JSON format
Extract the following information from the text and return as JSON with these fields: name, email, phone, company. If a field is not found, use null.
Text: {{input}}
JSON:John from Acme Inc. can be reached at john@acme.com or 555-0100
How to Use These Prompts
- 1.Copy the prompt you need from above
- 2.Upload your CSV file to AI Batch Processor
- 3.Paste the prompt in the prompt field
- 4.Replace {{input}} with your column name (e.g., {{description}} or {{text}})
- 5.Process and download your extracted data
Pro Tips
Build a Reviewed Extraction Batch
Adapt a prompt to your schema, test a representative sample, and validate important fields before using the exported data.
Start Extracting Free