Four local business bios, four rows
These four bios were pasted with a blank line between each. The florist spells out its email with [at] and [dot]; the barber gives two numbers, one in the awkward +44 (0) format; the bakery has a trade address and an order page; the potter has no contact details and asks not to be messaged.
Phone numbers come out in +44 form, the spelled-out email is rebuilt, and the barber's linked sister account appears as a mention. The potter's row carries two notes, which is exactly the kind of thing worth knowing before anyone sends a message.
@harbourblooms Harbour Blooms Florist in Whitby. Weddings and events hello [at] harbourblooms [dot] example 07700 900123 Shop: harbourblooms.example | linktr.ee/harbourblooms Stockists and collabs: DM or email Northgate Barbers (@northgate.barbers) Walk-ins welcome. Book online https://beacons.ai/northgatebarbers Call 0161 496 0000 · WhatsApp +44 (0)7700 900456 Sister shop @northgate.kids handle: crumbandcrust Small batch bakery and cafe in Leeds Wholesale enquiries: trade@crumbandcrust.example Order at crumbandcrust.example/order @quiet.clay Handmade ceramics. No DMs please, orders through Etsy only
@harbourblooms hello@harbourblooms.example +447700900123 harbourblooms.example linktr.ee/harbourblooms florist, weddings and events asks for DMs; open to trade, PR or collabs; email was spelled out @northgate.barbers (none) +441614960000, +447700900456 beacons.ai/northgatebarbers hair and beauty mentions WhatsApp; takes bookings; mentions @northgate.kids @crumbandcrust trade@crumbandcrust.example crumbandcrust.example/order bakery, cafe open to trade, PR or collabs @quiet.clay (none) handmade goods asks not to be contacted; no direct contact found
Turning a pile of bios into a sheet
Copy bios from profiles you can see
Open each profile as you normally would and copy the name, bio and any visible links or contact buttons' text. Put the handle on the first line if you can; it fills the handle column.
Separate profiles with a blank line
Paste them into the box with an empty line, or a line of three or more dashes, between profiles. Up to 2,000 profiles are read per paste.
Use a first line the tool recognises
Any of these works:
@handle,handle: name,Name (@handle)or the profile URL. If the next line is a short capitalised name it goes in the name column; a full sentence is left as bio text.Check the table and download
Review the rows, especially the notes column, then Download CSV for the full table or Copy emails for a plain list. Multiple values in one cell are joined with semicolons in the CSV.
What it recognises
| Column | What it picks up | What it leaves out |
|---|---|---|
Ordinary addresses, plus spelled-out forms such as jo [at] shop [dot] example, jo(at)shop(dot)example and bookings at studio dot example | A phrase like "order at shop.example", which is a website, not an address | |
| Phone | UK numbers starting 0, +44 or 0044, including +44 (0); other countries when written with + or 00 | Numbers with too few digits, years, opening hours |
| Website | Full URLs and bare domains with a known ending | Social network links, which go in the notes instead |
| Link in bio | Linktree, Beacons, lnk.bio, bio.link, Stan, Taplink, Carrd and similar services | The contents of those pages, which you need to open yourself |
| Business type | Plain words such as florist, barber, bakery, plumber, photographer | Anything subtler; treat it as a sorting hint, not a classification |
| Notes | Asks for DMs, mentions WhatsApp, takes bookings, open to stockists or collabs, asks not to be contacted, other accounts mentioned | Tone, follower counts, how active the account is |
A bio address is still somebody's inbox
A business that puts an email in its bio wants enquiries, but that does not make every message welcome. Many of the profiles you will paste belong to sole traders and small partnerships, and under the UK's PECR rules their email addresses are treated like an individual's: unsolicited marketing email to them generally needs consent. A limited company's generic inbox is treated differently. The ICO's guidance on business-to-business marketing explains the distinction; this page does not decide it for you.
Read the notes column with that in mind. "Asks not to be contacted" is the profile owner telling you their preference in public, so leave them off the list. "Asks for DMs" is a hint that email may not be how they want to hear from you at all. And a link-in-bio page often holds the real contact details, so a row with only a Linktree link is not a dead end, just one more page to read by hand.
Finally, keep where each detail came from. A column saying which profile and which day you copied it from makes it easy to answer the question "where did you get my email?", which you will be asked.
Before you use the sheet
- Remove every row noted as asking not to be contacted.
- Check whether each business is a limited company or a sole trader before emailing a named address.
- Open the link-in-bio pages for rows with no email or phone; the details are often there.
- Match the profile to a website or Google Maps listing so you know it is the business you think it is.
- Verify the email addresses before a first send, and keep a suppression list from day one.
Questions people ask
How do I find the email address in an Instagram bio?
On a business profile, the email is either written in the bio text or behind an Email contact button. Copy the bio, paste it here and the address is pulled out even if it is spelled out as name [at] domain [dot] com. This tool cannot read the contact button for you; open the profile and copy that address yourself.
Can this tool look up a TikTok or Instagram username?
No. It only reads text you paste. Looking a username up would mean fetching the platform's pages, which this page deliberately does not do. Copy the bio from the profile in your own browser or app, then paste it here, one profile per block with a blank line between them.
Why are phone numbers shown with +44?
UK numbers are rewritten in international E.164 style, so 07700 900123 becomes +447700900123 and +44 (0)161 496 0000 becomes +441614960000. That form sorts cleanly, works in click-to-call links and imports into most CRMs. Numbers from other countries are kept only when the bio already writes them with + or 00.
Is it legal to email addresses from social media bios?
Collecting an address a business has published is one question; sending marketing to it is another. In the UK, PECR treats sole traders and partnerships like individuals, so marketing email to them generally needs consent, while corporate inboxes are treated differently. Check the ICO's guidance for your case. This page is not legal advice.
What is a link in bio and why is it listed separately?
Services such as Linktree, Beacons and Stan give a profile one page holding several links, because most platforms allow only one link in a bio. The extractor lists these pages in their own column because they often contain the email or booking link the bio itself lacks, so they are worth opening next.
Where your data goes
Everything you paste is processed by JavaScript in this tab. The tool makes no requests to Instagram, TikTok, X, link-in-bio services or Map Extract, and nothing is stored after you leave the page. The CSV is created on your device.
Checked against the tool on