# Step 3: Lead List Data Cleanup

## Step 3: Lead List Data Cleanup

After column mapping is confirmed, CSVgo cleans your lead list automatically.

This step transforms messy, inconsistent input into **clean, structured, and usable data** before verification begins.

CSVgo follows a simple principle: **Messy in, ready out.**

***

### Removing Junk Data

CSVgo removes unnecessary and low-value data by default, including:

* Irrelevant columns
* Empty fields
* Redundant or noisy data points

This keeps the final CSV lean and focused on fields that matter for cold email and sales workflows.

***

### Auto-Deduplication

CSVgo automatically detects and removes duplicate rows.

Deduplication is based on key identifiers such as:

* Email address
* Name combinations
* Company-level overlaps

This prevents:

* Sending duplicate emails
* Wasting verification credits
* Inflating campaign volume with repeated leads

***

### Column Rearrangement

CSVgo rearranges columns into a clean, logical order based on your preferences.

You can:

* Use the default optimized order
* Customize column order in the Preferences tab
* Save your preferred layout for future uploads

This ensures consistency across exports and campaigns.

***

### Name Cleaning and Standardization

CSVgo cleans and standardizes name fields to improve personalization and enrichment.

This includes:

* Cleaning first names
* Cleaning last names
* Fixing capitalization and formatting issues
* Removing invalid characters

***

### Merging First and Last Name into Full Name

CSVgo automatically merges first name and last name into a **Full Name** field.

This is important because:

* Many enrichment tools require a full name
* CRM imports often rely on a single name field
* Personalization workflows perform better with clean full names

The original first and last name fields are preserved alongside the merged full name.

***

### Company Name Cleaning

CSVgo cleans company names by:

* Removing legal suffix noise where applicable
* Fixing inconsistent formatting
* Standardizing capitalization

This improves:

* CRM imports
* Enrichment accuracy
* Reporting and segmentation

***

### Result of the Cleanup Step

After Step 3, your lead list is:

* Free of junk data
* Deduplicated
* Properly structured
* Standardized for names and companies
* Ready for email verification and further processing

***

### Summary

In Step 3, CSVgo:

* Removes junk data automatically
* Deduplicates lead lists
* Cleans and standardizes names
* Creates a full name field
* Prepares clean, structured data for verification

This step ensures your list is usable before any emails are verified or segmented.