Skip to content
NoClutterCRM

Free spreadsheet check

CRM import readiness checker

Map the email and phone columns in a contact CSV. Find missing identifiers, common format problems and repeated identities before importing into NoClutterCRM.

  • Free to use
  • No signup
  • Stays in your browser

Enable JavaScript to use this tool in your browser.

Worked example

A row with a name but no email or phone is flagged. A phone number saved in scientific notation also needs review against the source spreadsheet.

This browser check flags common identity issues. The CRM importer makes the final decision on email syntax, other mapped fields, existing contacts, consent and workspace rules.

How to prepare a contact list for a CRM import

Messy CRM imports often go wrong for the same few reasons: rows with no email or phone, phone numbers damaged by a spreadsheet, and the same person listed twice. Fixing them in the spreadsheet is much quicker than cleaning up the CRM afterwards.

Map the email and phone columns in your CSV. The checker flags rows with neither, common format problems such as phone numbers saved in scientific notation, and email addresses or phone numbers that appear on more than one row.

Fix the flagged rows in your spreadsheet, check the file again and download the identity report for your records. The CRM importer still makes the final decision on each field during the import.

CRM import readiness checker questions

What does the checker look for?

Rows without an email address or phone number, common email and phone format problems, and identities that repeat across rows.

Why does my phone number look like 4.47701E+11?

Spreadsheets can show long numbers in scientific notation, and the CSV export then loses digits. In the original spreadsheet, format the phone column as a number with no decimal places, check the full numbers are shown and export the CSV again.

Which files can I check?

A CSV file of up to 5 MB and 10,000 rows. Export Excel or Google Sheets files as CSV first.

Does it import my contacts into NoClutterCRM?

No. It only checks the file in your browser. Importing is a separate step after you sign in to a workspace.