Donaldson R F
Data Conversion & Parsing
Raw Text to Formatted Lead Data Script
Extract emails, phone numbers and other lead details automatically from messy pasted text.
The Problem
Leads often arrive as a dump of raw text — a copied email signature, a scraped page, a forwarded message — and manually picking out the email and phone number from every one doesn't scale.
About this problem
Contact details in raw text appear in many forms: email addresses with odd punctuation, phone numbers with spaces, brackets or country codes, and names mixed in with signatures. Regular expressions can catch most patterns, but they need tuning to your data and the regions involved, or they produce false matches and miss valid ones.
People usually come to this when leads arrive as pasted text and sorting them manually into a spreadsheet or CRM takes more time than following them up.
What's Included
- A script that extracts emails, phone numbers and other patterns you specify from raw text input
- Output as a clean, structured CSV ready to import into a CRM or spreadsheet
- Handling of varied formats and international phone number styles
- A short usage note for running it again on future batches
What's NOT Included
- Validating whether extracted contacts are genuinely reachable/opted-in (a compliance question for you to own)
- Scraping data from sources that require bypassing access restrictions
- Ongoing automatic processing unless set up as a standing tool
How It Works
- I review sample text to see what kinds of leads and formats appear.
- I write extraction rules for emails, phone numbers and any other patterns you specify.
- I normalise phone numbers into a consistent format and handle international styles.
- I remove duplicates and output a structured CSV with one lead per row.
- I test on your real samples and tune the rules for false matches and misses.
- I provide a usage note for future batches.
In practice: you buy the service, send over whatever access or details the job needs, I investigate and do the work, and you confirm it's resolved before we call it done.
Frequently Asked Questions
- How can I extract emails and phone numbers from text?
- A script using pattern matching can pull them out and write them to a CSV. I tune it to your text.
- Will it catch every contact?
- Pattern matching is accurate for common formats but not perfect, so some unusual cases may need checking.
- Does it check whether contacts are valid?
- No. Checking whether contacts can be reached or have consented is for you to manage.
- Can it scrape websites?
- No. It processes text you give it, and I do not bypass access restrictions.
- Does it handle international numbers?
- It handles common international styles. Tell me which countries matter so I can test them.
- Can it run automatically?
- Not unless set up as a standing tool.