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.
More free sales tools
Explore all free sales toolsContact CSV cleaner
Trim whitespace, find duplicate rows and download a clean contact CSV.
Open toolDuplicate contact finder
Compare matching contact rows side by side. Choose which records to combine, preview the result and download your reviewed contact list.
Open toolPhone number formatter
Turn the phone numbers in a contact CSV into one international format. Numbers that cannot be formatted are flagged for review instead of guessed.
Open tool