{"id":52708,"date":"2023-10-24T15:47:27","date_gmt":"2023-10-24T13:47:27","guid":{"rendered":"https:\/\/www.myscada.org\/?post_type=docs&#038;p=52708"},"modified":"2023-10-24T15:47:27","modified_gmt":"2023-10-24T13:47:27","password":"","slug":"ms-excel-import-and-export","status":"publish","type":"docs","link":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/","title":{"rendered":"MS Excel import and export"},"content":{"rendered":"<h3><span style=\"color: #0084c8;\">Tag Database Export<\/span><\/h3>\n<p style=\"text-align: justify;\">The tag database can be easily exported into Microsoft Excel. To do so, click on the Export button in the main toolbar. Specify a file name and confirm. A new Microsoft Excel file is created containing the whole tag database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg\" alt=\"12.5.1\" width=\"300\" height=\"229\" \/><\/p>\n<p style=\"text-align: justify;\">Once the export file is created, you can open it in MS Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.2.jpg\" alt=\"12.5.2\" width=\"700\" height=\"342\" \/><\/p>\n<h3><span style=\"color: #0084c8;\">Tag Database Import<\/span><\/h3>\n<p style=\"text-align: justify;\">The tag database can be imported from an MS Excel file. It can be useful to keep the tag database in an MS Excel file and import it into myDESIGNER or you can use the MS Excel file as a bridge between your PLC programming software and myDESIGNER to transfer the tag database. To import the tag database from MS Excel, click on the Import button in the main toolbar:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.3.jpg\" alt=\"12.5.3\" width=\"300\" height=\"250\" \/><\/p>\n<p style=\"text-align: justify;\">Select a file for import and confirm. The MS Excel file should have all tags in the first sheet in a plain table. The table should have columns with the following names:<\/p>\n<table style=\"border-color: #e6e6e6; background-color: #fafafa;\" width=\"812\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\" width=\"182\"><strong>Alias<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"226\"><strong>Tag@Conn\/*Alias<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"120\"><strong>Description<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"52\"><strong>Unit<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"80\"><strong>Format<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"151\"><strong>Eng. Unit<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Once you import the tags, myDESIGNER will go over your existing tag database. If you import a tag with the same alias as one that is already in the tag database, it will be overwritten.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tag Database Export The tag database can be easily exported into Microsoft Excel. To do so, click on the Export button in the main toolbar. Specify a file name and confirm. A new Microsoft Excel file is created containing the whole tag database. Once the export file is created, you can open it in MS<a class=\"moretag excerpt orangelink\" href=\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":2555,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[325],"doc_tag":[],"class_list":["post-52708","docs","type-docs","status-publish","hentry","doc_category-mydesigner-v8"],"year_month":"2026-04","word_count":205,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Musilda","author_nicename":"musilda","author_url":"https:\/\/amitomation.cz\/en\/author\/musilda\/"},"doc_category_info":[{"term_name":"AMiTDesigner","term_url":"https:\/\/amitomation.cz\/en\/docs-category\/mydesigner-v8\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MS Excel import and export - AMiT Automation<\/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:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS Excel import and export - AMiT Automation\" \/>\n<meta property=\"og:description\" content=\"Tag Database Export The tag database can be easily exported into Microsoft Excel. To do so, click on the Export button in the main toolbar. Specify a file name and confirm. A new Microsoft Excel file is created containing the whole tag database. Once the export file is created, you can open it in MS[...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/\" \/>\n<meta property=\"og:site_name\" content=\"AMiT Automation\" \/>\n<meta property=\"og:image\" content=\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/\",\"url\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/\",\"name\":\"MS Excel import and export - AMiT Automation\",\"isPartOf\":{\"@id\":\"https:\/\/amitomation.cz\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg\",\"datePublished\":\"2023-10-24T13:47:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#primaryimage\",\"url\":\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg\",\"contentUrl\":\"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/amitomation.cz\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentation\",\"item\":\"https:\/\/amitomation.cz\/en\/documentation\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MS Excel import and export\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/amitomation.cz\/en\/#website\",\"url\":\"https:\/\/amitomation.cz\/en\/\",\"name\":\"AMiT Automation\",\"description\":\"Czech manufacturer of Control Systems and Industrial Automation Electronics\",\"publisher\":{\"@id\":\"https:\/\/amitomation.cz\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/amitomation.cz\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/amitomation.cz\/en\/#organization\",\"name\":\"AMiT, spol. s r.o.\",\"url\":\"https:\/\/amitomation.cz\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/amitomation.cz\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/amitomation.cz\/wp-content\/uploads\/2017\/07\/amit_automation_100x42.gif\",\"contentUrl\":\"https:\/\/amitomation.cz\/wp-content\/uploads\/2017\/07\/amit_automation_100x42.gif\",\"width\":100,\"height\":42,\"caption\":\"AMiT, spol. s r.o.\"},\"image\":{\"@id\":\"https:\/\/amitomation.cz\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/organization\/10939938\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS Excel import and export - AMiT Automation","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:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/","og_locale":"en_US","og_type":"article","og_title":"MS Excel import and export - AMiT Automation","og_description":"Tag Database Export The tag database can be easily exported into Microsoft Excel. To do so, click on the Export button in the main toolbar. Specify a file name and confirm. A new Microsoft Excel file is created containing the whole tag database. Once the export file is created, you can open it in MS[...]","og_url":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/","og_site_name":"AMiT Automation","og_image":[{"url":"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/","url":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/","name":"MS Excel import and export - AMiT Automation","isPartOf":{"@id":"https:\/\/amitomation.cz\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#primaryimage"},"image":{"@id":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#primaryimage"},"thumbnailUrl":"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg","datePublished":"2023-10-24T13:47:27+00:00","breadcrumb":{"@id":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#primaryimage","url":"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg","contentUrl":"http:\/\/myscada.org\/downloads\/manuals_image\/img_12.5.1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/amitomation.cz\/en\/documentation\/ms-excel-import-and-export\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/amitomation.cz\/en\/"},{"@type":"ListItem","position":2,"name":"Documentation","item":"https:\/\/amitomation.cz\/en\/documentation\/"},{"@type":"ListItem","position":3,"name":"MS Excel import and export"}]},{"@type":"WebSite","@id":"https:\/\/amitomation.cz\/en\/#website","url":"https:\/\/amitomation.cz\/en\/","name":"AMiT Automation","description":"Czech manufacturer of Control Systems and Industrial Automation Electronics","publisher":{"@id":"https:\/\/amitomation.cz\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/amitomation.cz\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/amitomation.cz\/en\/#organization","name":"AMiT, spol. s r.o.","url":"https:\/\/amitomation.cz\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/amitomation.cz\/en\/#\/schema\/logo\/image\/","url":"https:\/\/amitomation.cz\/wp-content\/uploads\/2017\/07\/amit_automation_100x42.gif","contentUrl":"https:\/\/amitomation.cz\/wp-content\/uploads\/2017\/07\/amit_automation_100x42.gif","width":100,"height":42,"caption":"AMiT, spol. s r.o."},"image":{"@id":"https:\/\/amitomation.cz\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/organization\/10939938\/"]}]}},"_links":{"self":[{"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/docs\/52708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/users\/2555"}],"replies":[{"embeddable":true,"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/comments?post=52708"}],"version-history":[{"count":1,"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/docs\/52708\/revisions"}],"predecessor-version":[{"id":53657,"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/docs\/52708\/revisions\/53657"}],"wp:attachment":[{"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/media?parent=52708"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/doc_category?post=52708"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/amitomation.cz\/en\/wp-json\/wp\/v2\/doc_tag?post=52708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}