{"id":14589,"date":"2021-06-04T18:55:09","date_gmt":"2021-06-04T18:55:09","guid":{"rendered":"https:\/\/www.collabox.com\/2021\/06\/04\/create-a-csv-file\/"},"modified":"2022-11-22T20:11:03","modified_gmt":"2022-11-22T20:11:03","slug":"create-a-csv-file","status":"publish","type":"post","link":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/","title":{"rendered":"Create a CSV file"},"content":{"rendered":"\n

Do you want to import your data into the Collabox, but you don’t know how to create a CSV file?<\/span><\/p>\n\n

You will find here all the explanations to transform your database into a CSV file. But on board, what is a CSV file? It stands for Comma-Separated Values in English. It is an open, computerized format of text separated by commas. Thus, a tabular file like Excel can be turned into a full text file, ideal for importing data.<\/span><\/p>\n\n

How to create a CSV file<\/h3>\n\n

There are several ways to save as CSV, but only two work when importing into Collabox.<\/span><\/p>\n\n

NOTE: Technically, Excel allows to save in CSV format, but it is not very flexible, not allowing to choose the encoding of the file. This therefore makes the produced file incompatible when importing into Collabox.<\/span><\/p>\n\n

<\/span><\/p>\n[toggle title=”Instructions for using LibreOffice”]<\/span>
\n The first method is to use the free software LibreOffice. It is a software suite similar to Microsoft Office. Calc (LibreOffice) is the equivalent of Excel at Microsoft. The first step is to open your Excel file using this new software. Once it’s done, click on File … -> Save as…<\/span><\/p>\n

In the window that appears on the screen, you will be able to choose the location where you want to save the file. In the small drop-down menu, choose the option “CSV Text (.csv)” and click “Save”.<\/span><\/p>\n

\"tocsv1\" The next step is to choose the options so that they are the same as the screen clip above. The field separator MUST be a semicolon. As for the text separator, the field must be empty. Once the options have been chosen, click on “OK”.<\/span>\"tocsv2\"<\/p>\n

[\/toggle]\n[toggle title=”Instructions for using Numbers”]\n

This solution is only valid for Mac owners. Numbers is the equivalent of Excel, but on the Mac OS X platform.<\/span><\/p>\n

First you need to open your Excel file with Numbers. Once this is done, click on File -> Export to -> CSV.<\/span><\/p>\n

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

In the recording options you can choose the desired encoding.\"tocsv56\"The one to select is “Western (ASCII)”.\"tocsv5\"<\/span><\/p>\n

You just have to do next to choose the location of the new file and you’re done.<\/span><\/p>\n

[\/toggle]\n\n

If you have problems and are unable to transform your file, don’t panic!<\/span> Contact us and we will assist you. <\/a><\/span><\/p>\n\n

If you have been efficient and everything has gone well,<\/span> you can continue to the next text to import your data into Collabox.<\/a><\/span><\/p>\n\n

Watch several videos on our Youtube channel<\/a> and visit our 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.<\/p>\n\n

info@collabox.com (418) 907-9274<\/p>\n","protected":false},"excerpt":{"rendered":"

Do you want to import your data into the Collabox, but you don’t know how to create a CSV file? You will find here all the explanations to transform your…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[187],"tags":[],"class_list":{"0":"post-14589","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-uncategorized"},"yoast_head":"\nCreate a CSV file - Collabox 2026 - ERP management software \u00c3\u00a0 la carte<\/title>\n<meta name=\"description\" content=\"Collabox allows you to import your list of contacts, suppliers and customers from a CSV file. Here's how to do it.\" \/>\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\/2021\/06\/04\/create-a-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create a CSV file\" \/>\n<meta property=\"og:description\" content=\"Collabox allows you to import your list of contacts, suppliers and customers from a CSV file. Here's how to do it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/\" \/>\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=\"2021-06-04T18:55:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-22T20:11:03+00:00\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/\"},\"author\":{\"name\":\"ad2816ed_admin\",\"@id\":\"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/f5c41eec8a13ff07c99a6059ded74439\"},\"headline\":\"Create a CSV file\",\"datePublished\":\"2021-06-04T18:55:09+00:00\",\"dateModified\":\"2022-11-22T20:11:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/\"},\"wordCount\":449,\"publisher\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/\",\"url\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/\",\"name\":\"Create a CSV file - Collabox 2026 - ERP management software \u00c3\u00a0 la carte\",\"isPartOf\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/#website\"},\"datePublished\":\"2021-06-04T18:55:09+00:00\",\"dateModified\":\"2022-11-22T20:11:03+00:00\",\"description\":\"Collabox allows you to import your list of contacts, suppliers and customers from a CSV file. Here's how to do it.\",\"breadcrumb\":{\"@id\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/doc.collabox.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create a CSV file\"}]},{\"@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":"Create a CSV file - Collabox 2026 - ERP management software \u00c3\u00a0 la carte","description":"Collabox allows you to import your list of contacts, suppliers and customers from a CSV file. Here's how to do it.","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\/2021\/06\/04\/create-a-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"Create a CSV file","og_description":"Collabox allows you to import your list of contacts, suppliers and customers from a CSV file. Here's how to do it.","og_url":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/","og_site_name":"Collabox","article_publisher":"https:\/\/www.facebook.com\/collbx","article_published_time":"2021-06-04T18:55:09+00:00","article_modified_time":"2022-11-22T20:11:03+00:00","author":"ad2816ed_admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ad2816ed_admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/#article","isPartOf":{"@id":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/"},"author":{"name":"ad2816ed_admin","@id":"https:\/\/doc.collabox.com\/en\/#\/schema\/person\/f5c41eec8a13ff07c99a6059ded74439"},"headline":"Create a CSV file","datePublished":"2021-06-04T18:55:09+00:00","dateModified":"2022-11-22T20:11:03+00:00","mainEntityOfPage":{"@id":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/"},"wordCount":449,"publisher":{"@id":"https:\/\/doc.collabox.com\/en\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/","url":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/","name":"Create a CSV file - Collabox 2026 - ERP management software \u00c3\u00a0 la carte","isPartOf":{"@id":"https:\/\/doc.collabox.com\/en\/#website"},"datePublished":"2021-06-04T18:55:09+00:00","dateModified":"2022-11-22T20:11:03+00:00","description":"Collabox allows you to import your list of contacts, suppliers and customers from a CSV file. Here's how to do it.","breadcrumb":{"@id":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/doc.collabox.com\/en\/2021\/06\/04\/create-a-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/doc.collabox.com\/en\/"},{"@type":"ListItem","position":2,"name":"Create a CSV file"}]},{"@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\/14589","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=14589"}],"version-history":[{"count":12,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/posts\/14589\/revisions"}],"predecessor-version":[{"id":19122,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/posts\/14589\/revisions\/19122"}],"wp:attachment":[{"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/media?parent=14589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/categories?post=14589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/doc.collabox.com\/en\/wp-json\/wp\/v2\/tags?post=14589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}