Prepare TSV Data for CRM Import as JSON Lines
Clean formatting, map columns, and export import-ready JSON Lines files directly from TSV.
From Messy Lead Sheet to Clean CRM Import
See how raw event leads are cleaned, formatted, and mapped into import-ready CRM records.
Unformatted lead sheet
The raw export contains top title banners, empty rows, and duplicate contact scans that block clean imports.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | TRADE SHOW LEADS · SEPT 2026 | ||||
| 2 | |||||
| 3 | First | Last | Org | Notes | |
| 4 | Amara | Okafor | amara@brightline.example | Brightline Dental | met at booth, wants demo |
| 5 | Lukas | Brandt | l.brandt@harborpine.example | Harbor & Pine Logistics | |
| 6 | Priya | Raman | priya@kellermoss.example | Keller, Moss & Co. | call after 15th |
| 7 | Tomás | Novák | tomas.novak@vltava.example | Vltava Stavby | budget Q1 |
| 8 | Hana | Sato | hsato@sakuratea.example | Sakura Tea Co. | |
| 9 | Amara | Okafor | amara@brightline.example | Brightline Dental Group | 2nd scan |
| 10 | Diego | Álvarez | diego@solnorte.example | Sol Norte Energía | hot |
Fix bad data before it hits your CRM
Uncleaned errors turn into hours of post-import work, from merging duplicate leads to deleting junk records and correcting broken fields.
Prevent duplicate contacts
Repeated email entries split activity logs and force tedious manual merges inside your CRM.
Automatic field mapping
Pre-aligned column headers match your target CRM fields instantly, eliminating manual import setup.
Eliminate junk records
Prevent banner titles, internal notes, and blank rows from creating useless clutter in your database.
Send lead lists from your own code
The API runs the same conversion. Post each new lead sheet and get the file back, ready for your CRM's bulk import.
Explore the APIcurl -X POST "https://dataconverter.io/api/v1/convert/tsv-to-json-lines" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "file=@sept-leads.tsv" \ --output crm-import-sept-2026.jsonl✓ 200 OK · crm-import-sept-2026.jsonl · 214 contacts
Built for anyone loading contacts into a CRM
Whoever handles the raw files, get clean lead lists into your CRM without spending hours fixing records manually afterward.
Sales & revenue operations
Load purchased lists and rep spreadsheets without duplicating contacts already in the CRM.
Event & field marketing
Turn trade-show scans and webinar sign-ups into contacts attributed to the right campaign.
Teams switching CRMs
Rename exported columns to the new CRM's fields and move everything across in one import.
Agencies & consultants
Onboard each client's contact list with a saved template instead of starting over.
Small businesses
Move customer lists out of spreadsheets and into your first CRM.
Developers
Call the conversion API to clean lead files before they reach your CRM's bulk import.
Set up once, reuse for every lead list
Save your settings and data preparation steps as a template. Apply them to the next list without setting them up again.
Frequently asked questions
Which CRMs are supported?
Any CRM that accepts file imports, including Salesforce, HubSpot, Zoho CRM, Pipedrive, and Microsoft Dynamics 365. Export your cleaned data in your required format (such as CSV, Excel, or JSON), formatted to match your CRM's template for automatic field mapping.
Can I combine several lead lists into one import?
Yes. Save each list as a dataset, then use Merge Data to stack them into one file. Columns are matched by name, so the lists don't need the same column order.
Can I export data directly into my CRM?
Direct CRM integration is not supported yet. You can export clean, ready-to-import files in formats like CSV, Excel, or JSON, or use our Conversion API to integrate file cleaning directly into your custom pipelines.