CLEAN UP YOUR SPREADSHEET BEFORE YOU IMPORT IT

Ten minutes of cleanup now saves you a messy contact list forever.

4 minute read · Beginner

Most import problems come from the spreadsheet, not the platform. Fix these things first, in Excel or Google Sheets, and the import goes smoothly.

THE CHECKLIST

  1. 1. One row per person. No blank rows between people, no totals at the bottom, no notes in random cells.
  2. 2. One header row at the top. Simple names like First Name, Last Name, Phone, Email.
  3. 3. Split names into two columns. First Name and Last Name. If they're in one column, use your spreadsheet's Split Text to Columns tool.
  4. 4. Clean phone numbers. Ten digits with area code. Remove extensions and notes like "cell" or "call after 5."
  5. 5. One email per cell. If someone has two, keep the one they actually read.
  6. 6. Delete duplicates. Sort by email or phone and remove repeats.
  7. 7. Save as CSV. File, then Download or Save As, then CSV (comma separated values).
HEADS UP

Only import people who said yes. If someone never agreed to hear from you, don't import them for texting or email campaigns. Sending to a list you bought or scraped is the fastest way to get your number blocked and your emails sent to spam.

EXTRA COLUMNS ARE FINE

Have info like service type, last job date or lead source? Keep it. During import you can match those columns to custom fields. Create the custom fields first so they're ready when you need them.

TIP

Add a column called Tag. Put something like imported-2026 in every row. After import, you can find the whole batch in seconds.

Certified Wisconsin Veteran, Woman Owned Business


© 2026 HABO Ventures Inc.