Margo
Workflow//2 min read

The CSV Export Workflow: From Lead List to Booked Meeting

A practical walkthrough of how to take a Margo CSV export and turn it into booked meetings using free and low-cost tools.

Written by Margo Team
The CSV Export Workflow: From Lead List to Booked Meeting — Margo field notes

Why CSV Exports Are the Starting Line

A CSV export from Margo gives you structured lead data instantly. But the export is just the beginning — the real work is turning that list into conversations.

Step 1: Download and Clean Your Export

Open your Margo CSV in Google Sheets or Excel. Remove: <ul class="my-6 list-disc space-y-2 pl-6 text-[17px] leading-[1.85] text-slate-300 marker:text-sky-400"><li class="pl-1">Rows missing email or phone</li><li class="pl-1">Businesses with generic contact info (info@, contact@)</li><li class="pl-1">Duplicates</li></ul> <h2 class="mb-5 mt-16 border-t border-white/10 pt-8 text-3xl font-black tracking-tight text-white">Step 2: Personalise at Scale</h2>

Add a column for personalisation notes. For each lead, add one specific observation: <ul class="my-6 list-disc space-y-2 pl-6 text-[17px] leading-[1.85] text-slate-300 marker:text-sky-400"><li class="pl-1">"No website"</li><li class="pl-1">"Last review 8 months ago"</li><li class="pl-1">"3.2 stars — lots of complaints about response time"</li></ul> This takes 30 seconds per lead but dramatically improves reply rates.

Step 3: Load Into an Outreach Tool

Import your cleaned CSV into an email outreach tool. Popular options: <ul class="my-6 list-disc space-y-2 pl-6 text-[17px] leading-[1.85] text-slate-300 marker:text-sky-400"><li class="pl-1"><strong class="font-semibold text-slate-100">Instantly</strong> — great for cold email at volume</li><li class="pl-1"><strong class="font-semibold text-slate-100">Lemlist</strong> — strong personalisation features</li><li class="pl-1"><strong class="font-semibold text-slate-100">Apollo</strong> — CRM + outreach combined</li><li class="pl-1"><strong class="font-semibold text-slate-100">Gmail + a spreadsheet</strong> — works for under 50 leads</li></ul> <h2 class="mb-5 mt-16 border-t border-white/10 pt-8 text-3xl font-black tracking-tight text-white">Step 4: Write Your Sequence</h2>

Create a 3-email sequence: <ol class="my-6 list-decimal space-y-2 pl-6 text-[17px] leading-[1.85] text-slate-300 marker:text-sky-400"><li class="pl-1">Email 1: Short, specific, value-first</li><li class="pl-1">Email 2: Follow-up with a case study or stat</li><li class="pl-1">Email 3: Break-up email ("Should I close your file?")</li></ol> <h2 class="mb-5 mt-16 border-t border-white/10 pt-8 text-3xl font-black tracking-tight text-white">Step 5: Track and Iterate</h2>

After 100 sends, review: <ul class="my-6 list-disc space-y-2 pl-6 text-[17px] leading-[1.85] text-slate-300 marker:text-sky-400"><li class="pl-1">Open rate (aim for 40%+)</li><li class="pl-1">Reply rate (aim for 5–10%)</li><li class="pl-1">Positive reply rate (aim for 2–5%)</li></ul> Adjust subject lines first, then body copy.

Conclusion

The CSV export is your starting point, not your endpoint. With this workflow, a 200-row Margo export can generate 10–20 qualified conversations in 2–3 weeks.

Build the list

Turn the idea into a prospect list.

Margo helps agencies, founders, and sales teams find verified local business leads by niche and city, then export emails, phone numbers, websites, and review data.

Start free with 25 leads