{!!@$headlines->page_title!!}

CSV Cleanup Tips (Simple Rules for Beginners)

These simple cleanup rules help your CSV import cleanly into Segwik without errors, confusion, or messy data.

Before You Start

A CSV file is just a spreadsheet saved in a simple format. Segwik reads exactly what’s in that file — nothing more, nothing less.

Clean data imports faster, maps easier, and creates fewer issues later.

Rule 1: One Contact Per Row

Each row should represent one person
  • Do not combine multiple people in one row
  • Do not stack names or emails in the same cell

Rule 2: One Type of Data Per Column

Columns should not mix information
  • Email column → emails only
  • Phone column → phone numbers only
  • Name column → names only
Avoid notes like “met at event” inside name or email fields.

Rule 3: Use Clear Column Headers

Headers help Segwik map fields correctly
  • First Name
  • Last Name
  • Email
  • Phone
  • Company

Avoid vague headers like “Info” or “Details.”

Rule 4: Remove Extra Formatting

Keep it plain
  • No merged cells
  • No colors or highlights
  • No formulas
  • No blank header rows
If it looks fancy, it probably won’t import cleanly.

Rule 5: Clean Emails and Phone Numbers

Consistency matters
Good
  • John Doe
  • john@email.com
  • 5551234567
Avoid
  • J.Doe / John from work
  • john@email.com / john@work.com
  • (555) 123-4567 ext 9

Rule 6: Remove Rows You Don’t Need

Less is better
  • Delete test rows
  • Remove empty rows
  • Remove old or irrelevant contacts

Rule 7: Save as CSV

Final step before import
  • Save the file as .csv
  • Do not upload .xlsx or .numbers files

What Happens If Something Isn’t Perfect?

Imports don’t have to be flawless.

  • You can adjust mapping during import
  • Segwik can detect duplicates
  • You can clean or update data after import

The goal is clean enough — not perfect.

Download a Sample CSV Template

Use this sample spreadsheet as a starting point for your own CSV import. It includes common fields, proper formatting, and example data.

Download Sample CSV Template