How to fix CSV imports, standardise messy data, and stop doing the same cleanup work every week.
Import contacts and companies into HubSpot from one CSV or two linked files. Choose the right unique IDs, prevent duplicates, and preserve every association.
Read article →Clean prospect lists from Apollo, ZoomInfo, and LinkedIn: merge sources, suppress existing contacts, remove duplicates, and verify 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 →Learn how to anonymize a CSV for an agency or contractor without exposing personal data or making the file useless for analysis.
Read article →Choose how to anonymize each CSV column: when to redact, hash, generalize, or replace values with fake data without destroying 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 →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 →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 →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 →Fix European CSV import problems caused by semicolon delimiters, comma decimals, DD/MM/YYYY dates, and Excel encoding in HubSpot or Salesforce.
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 →See which CRM import problems an online CSV cleaner can fix automatically, which still need human review, and how browser-based tools protect your data.
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 exact value matches. Excel IF formulas fail as variants pile up. Build a reusable mapping instead.
Read article →Prepare CSV files for Pipedrive: column names, required fields, custom field types, picklist values, date formats, and common import errors.
Read article →Clean event attendee lists before CRM import: standardise free-text fields, company sizes and job titles, remove duplicates, and preserve lead context.
Read article →Prepare CSV files for Salesforce Data Import Wizard or Data Loader: column names, picklist validation, date formats, required fields, and common errors.
Read article →A practical CSV cleaning checklist for inconsistent values, dates, delimiters, encoding, duplicates, whitespace, and other common import problems.
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.