Importing your data

Rizer CRM allows you to import data from external sources, making it easy to migrate your existing customer and business information into the system. This guide will walk you through the process of preparing and importing your data using a CSV (Comma-Separated Values) file.

To import your data into Rizer CRM:

  1. Log in to your Rizer CRM account.
  2. Navigate to the Import section inside Settings.
  3. Download the empty CSV example file
  4. Follow the examples and add your data accordingly
  5. Review the data and ensure everything is correct.
  6. Click “Import” to begin the Import process.
  7. Wait for the import to complete. Rizer CRM will provide a summary of the imported records and any errors encountered.

Note: If a company you are trying to import already exists, but you are providing extra missing info, like phone numbers, emails etc. that information will be updated.

Best Practices

  • Always back up your existing CRM data before performing an import.
  • Start with a small test import to ensure your file is formatted correctly.
  • After import, review a sample of the imported data to ensure accuracy.

Note: For now the import does not worn you of duplicate entries but does not create them either. So for example, if you are importing 3 companies and all 3 already exist in the CRM, the import will show as successful but no new companies will be created.

Preparing Your Import File

Rizer CRM accepts CSV files for data import. Here’s what you need to know about the file format:

  • The first row should contain column headers that match the field names in Rizer CRM.
  • Each subsequent row represents a single record (e.g., a company or a contact).
  • Fields are separated by commas.
  • If a field contains a comma, enclose the entire field in double quotes.

Supported Fields

Rizer CRM supports a wide range of fields for both entities (companies) and contacts. Here’s a breakdown of the supported fields:

Entity (Company) Fields

Entity Contact Methods

  • entity.contact_methods.calling.mobile_work.phone_country_code.1: Country code for work mobile
  • entity.contact_methods.calling.mobile_work.phone_number.1: Work mobile number
  • entity.contact_methods.calling.landline_work.phone_country_code.1: Country code for work landline
  • entity.contact_methods.calling.landline_work.phone_number.1: Work landline number
  • Skype username
  • Work email address
  • entity.contact_methods.messaging.fax_work.phone_country_code.1: Country code for work fax
  • entity.contact_methods.messaging.fax_work.phone_number.1: Work fax number

Contact Fields

For each contact (up to 2 in the CSV example), the following fields are supported:

Contact Methods

  • contact.{n}.contact_methods.calling.mobile_work.phone_country_code.1: Country code for work mobile
  • contact.{n}.contact_methods.calling.mobile_work.phone_number.1: Work mobile number
  • contact.{n}.contact_methods.calling.landline_work.phone_country_code.1: Country code for work landline
  • contact.{n}.contact_methods.calling.landline_work.phone_number.1: Work landline number
  • contact.{n}.contact_methods.calling.mobile_personal.phone_country_code.1: Country code for personal mobile
  • contact.{n}.contact_methods.calling.mobile_personal.phone_number.1: Personal mobile number
  • contact.{n}.contact_methods.calling.landline_personal.phone_country_code.1: Country code for personal landline
  • contact.{n}.contact_methods.calling.landline_personal.phone_number.1: Personal landline number
  • contact.{n} Skype username
  • contact.{n} Work email address
  • contact.{n} Personal email address
  • contact.{n}.contact_methods.messaging.fax_work.phone_country_code.1: Country code for work fax
  • contact.{n}.contact_methods.messaging.fax_work.phone_number.1: Work fax number
  • contact.{n}.contact_methods.messaging.fax_personal.phone_country_code.1: Country code for personal fax
  • contact.{n}.contact_methods.messaging.fax_personal.phone_number.1: Personal fax number

Note: You can replace {n} with the contact number (e.g., 1, 2, etc.) and add more than just one contact person.


If you encounter issues during the import process:

  • Check that your CSV file is properly formatted and all required fields are included.
  • Ensure that date fields are in the correct format (typically YYYY-MM-DD).
  • Verify that phone numbers include the country code and are in the correct format.
  • Look for any special characters or formatting that might cause issues, especially in text fields.
  • Check if contry or language codes are correct
  • Make sure you are using the correct inbound or outbound terminology

In case of errors, Rizer CRM will notify you of a failed import and suggest possible solutions. After you fix the problems you can retry the import.

Further reading:

Still stuck? How can we help?