Back to Blog
🧰 Templates

10 Ready-to-Use Prompts for Data Extraction

Apr 7, 2025 6 min read

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 Now

1. 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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

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:
Example Input

John from Acme Inc. can be reached at john@acme.com or 555-0100

How to Use These Prompts

  1. 1.
    Copy the prompt you need from above
  2. 2.
    Upload your CSV file to AI Batch Processor
  3. 3.
    Paste the prompt in the prompt field
  4. 4.
    Replace {{input}} with your column name (e.g., {{description}} or {{text}})
  5. 5.
    Process and download your extracted data

Pro Tips

Define the output format: Specify a simple schema that your downstream workflow can validate
Chain multiple extractions: Run multiple prompts in sequence to extract different data types
Handle edge cases: Add instructions like "If not found, return N/A" for cleaner outputs

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