{"id":14591,"date":"2016-09-08T10:41:33","date_gmt":"2016-09-08T14:41:33","guid":{"rendered":"https:\/\/www.collabox.com\/2021\/06\/04\/import-your-contacts-from-a-csv\/"},"modified":"2022-11-22T20:11:23","modified_gmt":"2022-11-22T20:11:23","slug":"import-your-contacts-from-a-csv","status":"publish","type":"post","link":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/","title":{"rendered":"Import your contacts from a CSV"},"content":{"rendered":"\n

Collabox allows you to import your contacts, suppliers and customers from a document in CSV format. So you have everything<\/span>your data in one place. <\/p>\n\n

If you have not already done so, please refer to this article<\/a> before proceeding. <\/p>\n\n

<\/p>\n\n

How to prepare your CSV file<\/h3>\n\n

Before importing your data into Collabox, it is essential to prepare your document well. First, make sure you have these three essential columns for importing: “Name” and “First name” of the contact and “Customer name”. These three headings are mandatory for importing into the Collabox. <\/p>\n\n

You can add as many columns as you want, such as address, email or phone number. Make sure you always have one piece of data per column.<\/p>\n\n

What is a customer<\/h4>\n\n

A customer is the entity to whom you sell your product or service. The invoice is sent to the client at the end of your project.<\/p>\n\n

What is a contact<\/h4>\n\n

The contact is a person whose details you want to keep for several reasons. It can be a customer, a prospect, a supplier or a professional subcontractor. <\/p>\n\n

<\/p>\n\n

How to import your contacts<\/h3>\n\n

The first step is to click on the “Configuration” icon located in the navigation bar at the top of the page.<\/span><\/p>\n\n

\"Configuration\"<\/figure><\/div>\n\n

Then click on “Import” in the left sidebar. <\/span><\/p>\n\n

\"CSV9\"<\/figure><\/div>\n\n

Once on the import page, you can see all the ones that have already been done. To start a new import, click on “Add import”.<\/span><\/p>\n\n

\"CSV8\"<\/figure><\/div>\n\n

<\/span>To import your contacts, the file must be in CSV form.<\/span> You can see the steps to convert your Excel to CSV here.<\/a> If you already have your file, select it with the tool. Choose the options “Text” and “Do not import the first row” (only if the first row contains the column titles) in the import format. <\/span><\/span><\/p>\n\n

Then choose where in the Collabox you want to import your data: “Customers”, “Suppliers” or “Contacts”. In our example, we chose to import our data into our contacts.<\/span><\/span><\/p>\n\n

\"CSV7\"<\/figure><\/div>\n\n

Configuration of headings<\/span><\/h3>\n\n

The second step of the import is to associate the columns in your file with their correct name (title) in the Collabox.<\/span> So, choose what each column corresponds to.<\/p>\n\n

\"CSV6\"<\/figure><\/div>\n\n

<\/span>Then, if necessary, add a non-existent heading. This The third step allows you to create custom fields if you have information in your file that has no equivalent in Collabox. If you don’t need it, continue to the next step.<\/span><\/p>\n\n

\"CSV5\"<\/figure><\/div>\n\n

The fourth step is important since it allows you to assign the files that will be created to your employees \/ salespeople. If several employees are involved, select them<\/span> all.<\/p>\n\n

\"\"<\/figure><\/div>\n\n

<\/span><\/p>\n\n

Finally, verification ensures that the file is imported correctly. If an error has occured, it is always time to modify it by clicking on “Modify”. You can switch from one contact to another using the arrows. If everything is perfect, click on “Import contact list”. Of course, if you are importing a list of customers or suppliers instead, the button will change accordingly.<\/span><\/p>\n\n

\"CSV3\"<\/figure><\/div>\n\n

The last step is to confirm the import. It is important to verify that the number of contacts imported is equal to the number of entries in your CSV file. If not, check your file and \/ or the import process.<\/span>
<\/span><\/p>\n\n

\"CSV2\"<\/figure><\/div>\n\n

How to delete an import<\/h3>\n\n

At any time, you can cancel an import and start over. <\/strong>So you don’t have to be afraid of making a big mistake for your business!<\/p>\n[toggle title=”To delete an import”]<\/span>
\n If you’ve made a blunder in your import and you want to undo it, you can. When you are on the import page, you must check the import that you want to withdraw and click on “Cancel selected imports”. And There you go! The contacts are now deleted.<\/span><\/p>\n

\"CSV1\"<\/span><\/p>\n

[\/toggle]\n\n

Watch several videos on our Youtube channel<\/a> and visit our Tips and Tricks section in the Blog<\/a> to continue your Collabox configuration!<\/p>\n\n

If you have any questions, please contact us and we will be happy to answer you. info@collabox.com (418) 907-9274<\/p>\n","protected":false},"excerpt":{"rendered":"

Collabox allows you to import your contacts, suppliers and customers from a document in CSV format. So you have everythingyour data in one place. If you have not already done…<\/p>\n","protected":false},"author":1,"featured_media":28093,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[208],"tags":[],"class_list":["post-14591","post","type-post","status-publish","format-standard","has-post-thumbnail","category-import-and-export-of-data"],"yoast_head":"\nImport your contacts from a CSV - Collabox 2026 - ERP software<\/title>\n<meta name=\"description\" content=\"Import your contacts, or your customer and supplier lists into Collabox using a CSV file. Simple and easy!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import your contacts from a CSV\" \/>\n<meta property=\"og:description\" content=\"Import your contacts, or your customer and supplier lists into Collabox using a CSV file. Simple and easy!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Collabox\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/collbx\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-08T14:41:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-22T20:11:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2575\" \/>\n\t<meta property=\"og:image:height\" content=\"1860\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"ad2816ed_admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ad2816ed_admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\"},\"author\":{\"name\":\"ad2816ed_admin\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/f5c41eec8a13ff07c99a6059ded74439\"},\"headline\":\"Import your contacts from a CSV\",\"datePublished\":\"2016-09-08T14:41:33+00:00\",\"dateModified\":\"2022-11-22T20:11:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\"},\"wordCount\":663,\"publisher\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png\",\"articleSection\":[\"Import and export of data\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\",\"url\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\",\"name\":\"Import your contacts from a CSV - Collabox 2026 - ERP software\",\"isPartOf\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png\",\"datePublished\":\"2016-09-08T14:41:33+00:00\",\"dateModified\":\"2022-11-22T20:11:23+00:00\",\"description\":\"Import your contacts, or your customer and supplier lists into Collabox using a CSV file. Simple and easy!\",\"breadcrumb\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage\",\"url\":\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png\",\"contentUrl\":\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png\",\"width\":2575,\"height\":1860,\"caption\":\"Importation des clients et des contacts \u00e0 partir d'un fichier .csv\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/doc.collabox.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import your contacts from a CSV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#website\",\"url\":\"https:\/\/doc.collabox.com\/en\/\",\"name\":\"Collabox\",\"description\":\"La nouvelle \u00e8re des ERP\",\"publisher\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/doc.collabox.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#organization\",\"name\":\"Collabox\",\"alternateName\":\"Collabox\",\"url\":\"https:\/\/doc.collabox.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2019\/10\/Logo-NEW-sans-slogan-300-dp1-11-pouces.png\",\"contentUrl\":\"https:\/\/doc.collabox.com\/wp-content\/uploads\/2019\/10\/Logo-NEW-sans-slogan-300-dp1-11-pouces.png\",\"width\":3300,\"height\":1380,\"caption\":\"Collabox\"},\"image\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/collbx\",\"https:\/\/www.linkedin.com\/company\/collabox\/?viewAsMember=true\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/f5c41eec8a13ff07c99a6059ded74439\",\"name\":\"ad2816ed_admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e908a4d963a82e0654e0a4ec26cf641356cb1764029f274dee8fd477a174e805?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e908a4d963a82e0654e0a4ec26cf641356cb1764029f274dee8fd477a174e805?s=96&d=mm&r=g\",\"caption\":\"ad2816ed_admin\"},\"sameAs\":[\"https:\/\/doc.collabox.com\"],\"url\":\"https:\/\/doc.collabox.com\/en\/author\/ad2816ed_admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Import your contacts from a CSV - Collabox 2026 - ERP software","description":"Import your contacts, or your customer and supplier lists into Collabox using a CSV file. Simple and easy!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/","og_locale":"en_US","og_type":"article","og_title":"Import your contacts from a CSV","og_description":"Import your contacts, or your customer and supplier lists into Collabox using a CSV file. Simple and easy!","og_url":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/","og_site_name":"Collabox","article_publisher":"https:\/\/www.facebook.com\/collbx","article_published_time":"2016-09-08T14:41:33+00:00","article_modified_time":"2022-11-22T20:11:23+00:00","og_image":[{"width":2575,"height":1860,"url":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png","type":"image\/png"}],"author":"ad2816ed_admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ad2816ed_admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#article","isPartOf":{"@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/"},"author":{"name":"ad2816ed_admin","@id":"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/f5c41eec8a13ff07c99a6059ded74439"},"headline":"Import your contacts from a CSV","datePublished":"2016-09-08T14:41:33+00:00","dateModified":"2022-11-22T20:11:23+00:00","mainEntityOfPage":{"@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/"},"wordCount":663,"publisher":{"@id":"https:\/\/doc.collabox.com\/en\/#organization"},"image":{"@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png","articleSection":["Import and export of data"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/","url":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/","name":"Import your contacts from a CSV - Collabox 2026 - ERP software","isPartOf":{"@id":"https:\/\/doc.collabox.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage"},"image":{"@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png","datePublished":"2016-09-08T14:41:33+00:00","dateModified":"2022-11-22T20:11:23+00:00","description":"Import your contacts, or your customer and supplier lists into Collabox using a CSV file. Simple and easy!","breadcrumb":{"@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#primaryimage","url":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png","contentUrl":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2023\/12\/SW_Importation.png","width":2575,"height":1860,"caption":"Importation des clients et des contacts \u00e0 partir d'un fichier .csv"},{"@type":"BreadcrumbList","@id":"https:\/\/doc.collabox.com\/en\/2016\/09\/08\/import-your-contacts-from-a-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/doc.collabox.com\/en\/"},{"@type":"ListItem","position":2,"name":"Import your contacts from a CSV"}]},{"@type":"WebSite","@id":"https:\/\/doc.collabox.com\/en\/#website","url":"https:\/\/doc.collabox.com\/en\/","name":"Collabox","description":"La nouvelle \u00e8re des ERP","publisher":{"@id":"https:\/\/doc.collabox.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/doc.collabox.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/doc.collabox.com\/en\/#organization","name":"Collabox","alternateName":"Collabox","url":"https:\/\/doc.collabox.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/doc.collabox.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2019\/10\/Logo-NEW-sans-slogan-300-dp1-11-pouces.png","contentUrl":"https:\/\/doc.collabox.com\/wp-content\/uploads\/2019\/10\/Logo-NEW-sans-slogan-300-dp1-11-pouces.png","width":3300,"height":1380,"caption":"Collabox"},"image":{"@id":"https:\/\/doc.collabox.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/collbx","https:\/\/www.linkedin.com\/company\/collabox\/?viewAsMember=true"]},{"@type":"Person","@id":"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/f5c41eec8a13ff07c99a6059ded74439","name":"ad2816ed_admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e908a4d963a82e0654e0a4ec26cf641356cb1764029f274dee8fd477a174e805?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e908a4d963a82e0654e0a4ec26cf641356cb1764029f274dee8fd477a174e805?s=96&d=mm&r=g","caption":"ad2816ed_admin"},"sameAs":["https:\/\/doc.collabox.com"],"url":"https:\/\/doc.collabox.com\/en\/author\/ad2816ed_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/posts\/14591","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/comments?post=14591"}],"version-history":[{"count":12,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/posts\/14591\/revisions"}],"predecessor-version":[{"id":19125,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/posts\/14591\/revisions\/19125"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/media\/28093"}],"wp:attachment":[{"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/media?parent=14591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/categories?post=14591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/tags?post=14591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}