Map a lead list to your import layout
Paste a CSV or its header and pick the tool. Get the column mapping and a re-ordered CSV in that tool's column names. It runs in your browser; nothing is uploaded. Free, no account.
The box starts with the 67Leads export header as an example. Replace it with your own. Nothing is uploaded: the file is read and re-ordered in your browser.
How it works
- Your header names are read in your browser and matched to a fixed list of fields (email, first name, last name, full or owner name, company, phone, website, domain, city, state, postal code, category and a few more) by comparing names with the case, spaces and punctuation removed. So "Company Name", "company_name" and "Business" all land on company.
- Each tool's column names and order come from 67Leads' own export layouts for Instantly, Smartlead, lemlist, HubSpot and Apollo, which follow each tool's import documentation. The file you get has those columns, in that order, with your data in them.
- Where a layout wants a first and last name and you have one full name, it is split on the spaces (titles such as Dr and endings such as Jr are dropped). Where it wants a domain and you have a website, the domain is cut from it. Where it wants "city, state" it joins the two.
- A wrong guess? Change what a column is treated as in the first table and the file updates.
Privacy
Nothing is uploaded or stored. The page has no form that submits and sends no request with your data; the file is read by your browser and the new file is made in your browser. You can switch your connection off after the page has loaded and it still works.
What it does not do
- It does not clean, verify or reformat values. Phone numbers, emails and names are copied as they are. Use the lead list cleaner and phone number formatter for that.
- It does not create custom fields in your tool. Check each tool's own import screen after you upload.
- Column names may change in a tool's next release. If an import screen asks you to map a column, trust it over this page.
Lists from 67Leads can also be exported in these layouts directly: pick the tool when you export, and the columns come out named for it. See the layouts.
Get 67 leads free No card. Search free with contacts masked.
Lead list cleanerLead list splitterMerge tag checkerPhone number formatterExport layouts
Questions
Paste the CSV or its header row above and pick the tool. The page lists which of your columns fills each of the tool's columns and gives you the re-ordered CSV.
No. The page runs in your browser. There is no upload, and the list is not sent to us or stored.
Common names are matched by ignoring case, spaces and punctuation. If one is missed or wrong, change what it is treated as in the table.
Instantly, Smartlead, lemlist, HubSpot and Apollo, with the column names 67Leads uses for its own exports to those tools.
Columns with no matching column in your list are left out unless you tick the box to keep them blank.
More free tools
Local business counterNo-website business finderLead list previewCold email template generatorCold call objection handlerLocal SEO audit checklist generatorAgency client onboarding checklist generatorLocal citation list builderLocal keyword generatorNo-website pitch email generatorDiscovery call questions generatorGoogle Business Profile post generatorGatekeeper script generatorDoor-to-door sales script generatorAppointment setting script generatorSMS follow-up template generatorWebsite audit email generatorAgency profit margin calculatorLeads needed calculatorRetainer vs project pricing calculatorFacebook ad copy generator for local servicesLocal landing page outline generatorWebsite maintenance plan pricing calculatorReferral request script generatorCold email subject line generator for local businessesClient report template generatorGoogle Ads budget estimator for local tradesProposal follow-up email generatorWin-back email generator for lost clientsService pricing sheet generatorTrade website copy generatorAbout us page generator for local businessesTestimonial request message generatorCase study template generatorFreelancer and agency commission split calculatorClient churn rate calculator for agenciesTrade job price calculatorTrade estimate template generatorGrand opening press release generatorNextdoor post generator for local businessesYard sign and door hanger copy generatorCall tracking ROI calculatorMissed-call text-back message generatorLead response time cost calculatorAgency revenue goal plannerCold outreach volume plannerSales pipeline value calculatorAgency break-even calculatorClient price increase email generatorClient offboarding checklist generatorScope of work template generatorSales call follow-up email generatorCold email reply templates generatorWebsite launch checklist generatorClient kickoff meeting agenda generatorGoogle Business Profile Q&A generatorWebsite redesign ROI calculatorClient profitability calculatorAd management fee calculatorAgency utilization rate calculatorDental practice website pitch generatorMed spa offer post generatorLaw firm intake form checklist generatorAppointment no-show cost calculatorClinic website audit checklist generatorTrust signals section generatorMembership revenue calculatorAppointment reminder message generatorNAICS code lookupSIC code lookupSSL certificate checkerRedirect checkerBroken link checkerPage weight checkerMerge tag checkerAll Phone & data cleanup toolsAll tools