{"id":5878,"date":"2013-07-24T13:52:10","date_gmt":"2013-07-24T18:52:10","guid":{"rendered":"http:\/\/webirix.com\/?p=5878"},"modified":"2013-07-24T13:52:10","modified_gmt":"2013-07-24T18:52:10","slug":"importar-archivos-csv-a-microsoft-excel","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/importar-archivos-csv-a-microsoft-excel\/","title":{"rendered":"Import .csv files into Microsoft Excel"},"content":{"rendered":"<p>To import a .csv file into\u00a0\u00a0<strong>Microsoft Excel<\/strong>. It will be necessary to go to the menu <strong>File<\/strong>\u00a0in the group\u00a0<strong>Get external data<\/strong>, click on\u00a0<strong>From text<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" alt=\"Grupo Obtener datos externos de la ficha Datos\" src=\"http:\/\/officeimg.vo.msecnd.net\/es-es\/files\/089\/357\/ZA010371850.gif\" \/>Find the text file you want to import and double-click on it.<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/Asistente-para-importar-texto.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5879\" alt=\"Asistente para importar texto\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/Asistente-para-importar-texto-300x183.jpg\" width=\"300\" height=\"183\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/Asistente-para-importar-texto-300x183.jpg 300w, https:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/Asistente-para-importar-texto.jpg 667w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>It is important that you choose the file type <strong>Delimited<\/strong><\/p>\n<p>After clicking next you must select as separators <strong>Tabulation<\/strong> Y <strong>Eat<\/strong><\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/tabulacion1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5881\" alt=\"tabulacion\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/tabulacion1-300x183.jpg\" width=\"300\" height=\"183\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/tabulacion1-300x183.jpg 300w, https:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/tabulacion1.jpg 667w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>After clicking <strong>Next<\/strong> and in <strong>Finalize\u00a0<\/strong>you can choose to import the database into the same spreadsheet or into a new one.<\/p>\n<p>In this way the data will be properly accommodated in your spreadsheet.<\/p>","protected":false},"excerpt":{"rendered":"<p>To perform a .csv file import into Microsoft Excel. It will be necessary to go to the File menu in the Get External Data group, click From Text. Find the text file you want to import and double-click on it. It is important that you choose Delimited as the file type. After clicking on next, you must select ...<\/p>","protected":false},"author":2,"featured_media":5882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1953],"tags":[],"class_list":["post-5878","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-punto-de-venta"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2013\/07\/CSV.png","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/5878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=5878"}],"version-history":[{"count":2,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/5878\/revisions"}],"predecessor-version":[{"id":5884,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/5878\/revisions\/5884"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/5882"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=5878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=5878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=5878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}