Creating new customers in bulk through spreadsheet import

Make sure your excel sheet is cleaned up before starting your import...

  • No empty or extra rows and columns
  • One information per cell
  • No main titles at the top of your excel sheet, except your column titles

You can import a list of customers from an excel sheet into Kimoby.

In the customers section

  • Save your excel sheet as .csv to assure a successful import.
  • Click on the Customers  tab, on the left side of you screen.
  • Click on the downward arrow to start the import.
  • Drag and drop your excel sheet in Import customers the box or click on browse your files to attach it from your computer files.
  • Wait for the import to be completed.
  • Click on Create import.

In the import section

  • Save your excel sheet as .csv to assure a successful import.
  • Click on your name, at the top right corner of your screen.
  • Click on Imports
  • Click on New import to start the import.
  • Click on Import customers.
  • Drag and drop your excel sheet in the File the box or click on browse your files to attach it from your computer files.
  • Wait for the import to be completed.
  • Click on Create import.

Create your import

If the first row of your excel sheet contains your main titles of your coloumns, click on the checkbox at the top of your screen First row is the column's header. Kimoby will then use these informations as titles and not as a customer's information.

As soon as you create your import, you will be redirected in your import's page. 

For all of your columns, you will need to identify and match your excel file's information with Kimoby's attributes. 

  • Click on the Belongs to drop-down menu, on the right of every column.
  • Choose the category of the information of each column. 
  • You can add a category by clicking on New string, if the title of your column is not in the drop-down menu.
  • Write the attribute's name in the box right under New string.
  • You can skip the column in the drop-down menu by selecting Skip this column. Kimoby will then discard that information from your group.
  • Click on Import
Did you find it helpful? Yes No

How do you like using Kimoby?