{"id":10957,"date":"2017-07-26T12:57:24","date_gmt":"2017-07-26T10:57:24","guid":{"rendered":"http:\/\/www.noabe.com\/help\/?p=10957"},"modified":"2025-10-29T15:41:45","modified_gmt":"2025-10-29T14:41:45","slug":"import-contacts-file","status":"publish","type":"post","link":"https:\/\/www.noabe.com\/help\/index.php\/import-contacts-file\/","title":{"rendered":"Import contacts from file"},"content":{"rendered":"

Back to overview<\/a><\/p>\n

 <\/p>\n

I would like to import contacts to Jablotool from a file. These contacts will be synchronized to phones in Jablotool. I already have a list of contacts and their phone numbers in a table. How should I adjust the file so that the contacts can be imported by Jablotool?<\/p>\n

The best and easiest way to import contacts from a table is to convert it to CSV format. Follow the steps below to prepare a compatible CSV file.
\nNote: We are going to use MS Excel, but feel free to use any other SW, the process should be similar.<\/span><\/p>\n

    \n
  1. First organize your data so that it looks as on the table below. The first line should look as in the picture. Download template here<\/a>.
    \n \"\"<\/p>\n<\/li>\n
  2. Click on empty column. Merge the texts from cells together and separate them with commas. Use the function CONCATENATE or its equivalent in your spreadsheet editor.
    \nExample of formula: =CONCATENATE(A1;”,”;B1;”,”;C1;”,”;D1;”,”;E1;”,”;F1)<\/i><\/li>\n
  3. Copy the formula to other lines.<\/li>\n
  4. You can see the concatenated table in the column H in the picture below.
    \n \"\"<\/p>\n<\/li>\n
  5. Copy the column H (Select the whole column and press Ctrl+c). Make sure that the first line with the heading is copied too.<\/li>\n
  6. Create a new excel file, press Ctrl+n.<\/li>\n
  7. Insert the copied cells into the new file, press Ctrl+v.<\/li>\n
  8. Click on the (Ctrl) 1.<\/b><\/span> icon and select Paste Values 2.<\/b><\/span>.
    \n \"\"<\/p>\n<\/li>\n
  9. Save the new file with your contact list as contacts.csv<\/b> file. Choose the format CSV (Comma delimited) (*.csv).\n

    Note:MS Excel may alert you that some features in the workbook might be lost if you save it as CSV (Comma delimited). Select Yes and keep using this format.<\/li>\n

  10. Now you have prepared a compatible CSV file ready for import to jablotool.com<\/a>.<\/li>\n
  11. Import the contacts to Jablotool. Sign in to your account at www.jablotool.com<\/a>.\n
      \n
    1. Select where you want to import those contacts. Choose a Phone group or click on Essence phone on the Dashboard.<\/li>\n
    2. Go to Contacts<\/b><\/li>\n
    3. Click on MORE<\/b><\/li>\n
    4. Select import<\/b><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n\n
      Phone Group<\/td>\nEssence phone<\/td>\n<\/tr>\n
      \"\"<\/a><\/td>\n\"\"<\/a><\/td>\n<\/tr>\n<\/table>\n
        \n
          \n
        1. Click on the button Choose file<\/b><\/li>\n
        2. Select the CSV file you have created and click Open<\/b><\/li>\n<\/ol>\n<\/li>\n
        3. Click Import contacts<\/b> and the imported contacts will appear in the contact list.<\/li>\n<\/ol>\n

          <\/p>\n

          <\/p>\n

          <\/p>\n","protected":false},"excerpt":{"rendered":"

          Back to overview   I would like to import contacts to Jablotool from a file. These contacts will be synchronized to phones in Jablotool. I already have a list of contacts and their phone numbers in a table. How should I adjust the file so that the contacts can be imported by Jablotool? The best […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,20,14,85],"tags":[49,55,56,88],"class_list":["post-10957","post","type-post","status-publish","format-standard","hentry","category-gdp-06","category-raven","category-jablotool","category-phone-administration","tag-contacts","tag-import","tag-jablotool-online-essence-import","tag-phoneadmin-trouble"],"_links":{"self":[{"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/posts\/10957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/comments?post=10957"}],"version-history":[{"count":1,"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/posts\/10957\/revisions"}],"predecessor-version":[{"id":13878,"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/posts\/10957\/revisions\/13878"}],"wp:attachment":[{"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/media?parent=10957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/categories?post=10957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.noabe.com\/help\/index.php\/wp-json\/wp\/v2\/tags?post=10957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}