How to fix CSV imports, standardise messy data, and stop doing the same cleanup work every week.
Prospect lists from Apollo, ZoomInfo, and LinkedIn exports need different cleanup than a CRM import: merging sources, suppressing existing contacts, and verifying emails before outreach.
Read article →CSV imports into a CRM fail because of validation rules at every pipeline stage. This guide covers what breaks each stage and how to fix it before you upload.
Read article →An agency or consultant just asked for a CSV export. Sending the raw file is a compliance risk. Sending it fully redacted makes it useless. Here's the middle ground that keeps the data analyzable.
Read article →A practical decision guide for anonymizing CSV columns. When to redact, when to hash, when to replace with fake data, and why picking the wrong strategy either leaks information or destroys the analysis.
Read article →GDPR rules for sharing CSV exports with a vendor or agency: the anonymized vs pseudonymized distinction, what hashing actually changes, and what to check first.
Read article →When multiple people build UTM links independently, attribution splits into fragments. Here's how to define a naming convention and enforce it without a style guide nobody reads.
Read article →Migrating from HubSpot, Salesforce, or Pipedrive? Here's how to clean and reshape your CSV exports before they hit the new CRM, so you don't lose history, picklist values, or relationships.
Read article →Most ops teams treat each CSV import as a fresh problem. Here's how to turn recurring imports into 30-second workflows by building reusable mappings, normalisation rules, and validation checks.
Read article →How to convert values in a CSV column: country codes, status numbers, language values. Why find-and-replace fails, and how to build a reusable value mapping.
Read article →Open a CSV and see é become é or ç become garbage? Learn what causes CSV encoding errors and how to detect and fix UTF-8 vs Windows-1252 mismatches.
Read article →MM/DD/YYYY or DD/MM/YYYY? Learn how to detect which date format your CSV uses, convert it to ISO 8601, and avoid silent data corruption downstream.
Read article →CSV files from French or German Excel use semicolons, comma decimals, and DD/MM/YYYY dates. Here's what breaks when you upload them to HubSpot, Salesforce, or Pipedrive, and how to fix it.
Read article →HubSpot and Salesforce require separate first and last name fields, but your export has a single Name column. Here's how to split columns in Excel and Google Sheets, and what to do when formulas break.
Read article →Online CSV cleaners can fix anything with a rule or a pattern. They can't make a judgment call. Here's the actual line between what a browser-based tool solves and what still needs a human, and why.
Read article →Free CSV import tools for CRM split into two categories, transport and cleaning. A breakdown of which tool covers which, and why none cover both.
Read article →Picklist fields in HubSpot, Salesforce, and Pipedrive require an exact value match. Excel IF formulas fail as variants pile up. Build a reusable mapping instead.
Read article →A practical guide to importing CSV files into Pipedrive: column naming, required fields, custom field types, picklist values, date formats, and the most common import errors.
Read article →Event registration exports are messy by nature: free-text fields, inconsistent company sizes, duplicate attendees, and job titles entered a hundred different ways. Here's how to clean them before they pollute your CRM.
Read article →A practical guide to preparing a CSV file for Salesforce import: column naming differences between the Data Import Wizard and Data Loader, picklist validation, date formats, and the most common errors and how to fix them.
Read article →A practical checklist covering every common CSV data quality problem: inconsistent values, date formats, delimiter mismatches, encoding issues, BOM, duplicates, whitespace, and more, before you import into any system.
Read article →HubSpot CSV imports fail for four predictable reasons: bad column names, rejected picklist values, wrong date formats, and comma-separated multi-select fields.
Read article →No articles match your search.