Sanitizing or cleaning the contacts file before import

You are here:
< All Topics

Saving the right data in aNinja allows for easy searching, powerful Smartlists, and the ability to automate your emails and texts. Here are the essential steps to take and the common mistakes to avoid when importing your Leads into aNinja.

Sanitizing or cleaning the contacts file before import

To successfully import your contacts file, you want to remove unnecessary fields and characters.

  • Have your data saved in an Excel or Google sheet file as a dataset and work on sanitizing it there.
    • Below is an image of a dataset
    • Start your table at cell A1.
    • Always reserve the first row for the headers.
    • Make the contact name in the first column (A) of your sheet.

  • Remove unnecessary columns and rows. You don’t want to bloat your CRM with data that you’re not going to use.
  • Remove duplications. You don’t want to be sending the same email or text sequence to the same leads. That would be annoying for the leads and extra charges for you.
  • Trim spaces.
  • Remove weird and unnecessary characters to avoid receiving errors in importing.
  • Remove hyperlinks from the email or the URL addresses. Save them as text.
  • Convert the phone numbers to Numbers.
  • Delete the empty columns and raws. They might contain hidden data.
  • Rename your file headers according to aNinja fields. This helps you choose the correspondent aNinja field to map.
    • For the custom field values, simply prefix them with “custom.” in the header.
      e.g. put custom.location for importing a column with the location.
  • Lastly, save your file as CSV or Excel as aNinja supports these 2 formats.
    • A CSV file has commas in between the values of each column. If there is no comma separating the values of the columns, the CSV file is not valid. And you’ll not be able to import your file to aNinja. So, you want to check the export options that generated this file to make sure the comma is there to have a valid CSV.

Now your file is clean and ready to import to aNinja.

Have any specific questions about sanitizing or cleaning the contacts file before import? Feel free to leave us an email at We will happily assist you.

Table of Contents