Data Cleaning
How to Clean CSV Data Before Import
A practical sequence for inspecting CSV data, trimming whitespace, reviewing blank rows and standardizing values before export.
Read: How to Clean CSV Data Before ImportRowDesk guides
Practical guides for cleaner, import-ready data.
Learn how to clean, deduplicate, compare and prepare CSV or Excel data before importing it into CRMs and business systems.
Start hereBuild a better
Build a better
preparation routine.
Four practical guides for the decisions that matter before an import: what to clean, which records to keep and how to verify the result.
CRM Import Preparation
How to Prepare CSV Data for CRM Import
An import-preparation checklist covering record identity, required fields, duplicates, existing data and a reviewed CSV handoff.
Read: How to Prepare CSV Data for CRM ImportDeduplication
How to Remove Duplicate Records from CSV
Learn how to distinguish exact duplicate rows from matching records, choose keys, review survivors and verify removals.
Read: How to Remove Duplicate Records from CSVData Comparison
How to Compare Two CSV Files
Map fields between two CSV datasets, choose matching rules and distinguish new, matched and reference-only records.
Read: How to Compare Two CSV FilesBrowse by topicStart with
Start with
the task in front of you.
Find guidance for the part of the workflow you are working on.
Data Cleaning
Formatting, whitespace, blank rows and standardization.
Read the data cleaning guideDeduplication
Duplicate contacts, matching fields and record review.
Read the deduplication guideData Comparison
Compare files, find new records and reconcile CRM exports.
Read the data comparison guideCRM Import Preparation
Import checklists, data quality and migration preparation.
Read the crm import preparation guideFrom reading to reviewingPut the workflow
Put the workflow
into practice.
RowDesk brings inspection, cleanup, duplicate review and file comparison into a browser-based workspace. Preview important transformations, inspect the changes and download a separate clean CSV.
Raw datasets are processed locally in the browser in local-processing mode. The original source file remains unchanged.
The guide library
All guides
- Data Cleaning
How to Clean CSV Data Before Import
A practical sequence for inspecting CSV data, trimming whitespace, reviewing blank rows and standardizing values before export.
- CRM Import Preparation
How to Prepare CSV Data for CRM Import
An import-preparation checklist covering record identity, required fields, duplicates, existing data and a reviewed CSV handoff.
- Deduplication
How to Remove Duplicate Records from CSV
Learn how to distinguish exact duplicate rows from matching records, choose keys, review survivors and verify removals.
- Data Comparison
How to Compare Two CSV Files
Map fields between two CSV datasets, choose matching rules and distinguish new, matched and reference-only records.