{"id":30205,"date":"2014-05-03T12:56:13","date_gmt":"2014-05-03T17:56:13","guid":{"rendered":"http:\/\/webirix.com\/?p=30205"},"modified":"2014-05-03T13:02:36","modified_gmt":"2014-05-03T18:02:36","slug":"cambiar-separador-en-excel-para-archivos-csv","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/cambiar-separador-en-excel-para-archivos-csv\/","title":{"rendered":"Change separator in Excel for .CSV files"},"content":{"rendered":"

Es posible que al visualizar un archivo .CSV en Excel se muestre de manera err\u00f3nea, esto es debido a que nuestro “separador” o “delimitador” no es el correcto.<\/span><\/p>\n

For example, if we have the system in English, the default delimiter of the OS is the semicolon<\/span>\u00a0(;) instead of the comma (,) as usual.<\/span><\/p>\n

For the correct visualization of the file it is necessary that our computer has the numerical format of "Spanish (Mexico)", for this we carry out these simple steps:<\/p>\n

Ingresamos al “panel de control” de nuestra computadora.<\/p>\n

\"Panel<\/a><\/p>\n

We look for the word "region" and click on it.<\/p>\n

\"Region\"<\/a><\/p>\n

We position ourselves in the format option.<\/p>\n

\"3\"<\/a><\/p>\n

From the tab that is displayed, we select \u201cSpanish (Mexico)\u201d.<\/p>\n

\"Espa\u00f1ol(M\u00e9xico)\"<\/a><\/p>\n

We click on accept to save the changes made.<\/p>\n

\"5\"<\/a><\/p>\n

Now we just have to start Excel again and d<\/span>e esta manera nuestros archivos .CSV con “Separador” de coma(,) se mostraran de manera correcta.<\/p>","protected":false},"excerpt":{"rendered":"

Es posible que al visualizar un archivo .CSV en Excel se muestre de manera err\u00f3nea, esto es debido a que nuestro “separador” o “delimitador” no es el correcto. Por ejemplo, \u00a0si contamos con el sistema en ingl\u00e9s, el delimitador por defecto del SO es\u00a0el punto y coma\u00a0(;) en lugar de la coma (,) como \u00a0se …<\/p>","protected":false},"author":21,"featured_media":30213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1953],"tags":[],"class_list":["post-30205","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\/2014\/05\/file-icon-csv.png","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/30205","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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=30205"}],"version-history":[{"count":5,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/30205\/revisions"}],"predecessor-version":[{"id":30217,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/30205\/revisions\/30217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/30213"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=30205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=30205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=30205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}