{"id":1341052,"date":"2017-08-28T01:15:16","date_gmt":"2017-08-28T08:15:16","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/"},"modified":"2017-08-28T08:32:10","modified_gmt":"2017-08-28T15:32:10","slug":"import-function-via-csv-file","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/","title":{"rendered":"Import function via csv file"},"content":{"rendered":"<p>Dear Support,<\/p>\n<p>is it possible to change the import separator for csv files from comma to something else?<br \/>\nIt is annoying when having text in a cell containing commas. Standard separator in Excel is the semicolon and this is nearly not used in texts. So it would be really better to change that import separator to semi-colon or something complete different which is not used within a text. I guess I am not the only one who struggles with that disadvantage.<\/p>\n<p>To change the separator or to be able to choose different signs when importing, this would be a great help!<\/p>\n<p>Thank you!<br \/>\nChristoph<\/p>\n","protected":false},"template":"","class_list":["post-1341052","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import function via csv file -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import function via csv file -\" \/>\n<meta property=\"og:description\" content=\"Dear Support, is it possible to change the import separator for csv files from comma to something else? It is annoying when having text in a cell containing commas. Standard separator in Excel is the semicolon and this is nearly not used in texts. So it would be really better to change that import separator [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-28T15:32:10+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/\",\"name\":\"Import function via csv file -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-08-28T08:15:16+00:00\",\"dateModified\":\"2017-08-28T15:32:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Welcome!\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Pre-Sales Questions\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Import function via csv file\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import function via csv file -","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:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"Import function via csv file -","og_description":"Dear Support, is it possible to change the import separator for csv files from comma to something else? It is annoying when having text in a cell containing commas. Standard separator in Excel is the semicolon and this is nearly not used in texts. So it would be really better to change that import separator [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/","article_modified_time":"2017-08-28T15:32:10+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/","name":"Import function via csv file -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-08-28T08:15:16+00:00","dateModified":"2017-08-28T15:32:10+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/import-function-via-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Welcome!","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/"},{"@type":"ListItem","position":4,"name":"Pre-Sales Questions","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/"},{"@type":"ListItem","position":5,"name":"Import function via csv file"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1341052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1341052\/revisions"}],"predecessor-version":[{"id":1341170,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1341052\/revisions\/1341170"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1341052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}