{"id":3743,"date":"2022-12-14T16:17:20","date_gmt":"2022-12-14T16:17:20","guid":{"rendered":"https:\/\/www.filetechn.com\/?p=3743"},"modified":"2022-12-14T16:17:20","modified_gmt":"2022-12-14T16:17:20","slug":"como-convertir-texto-a-columnas-en-excel","status":"publish","type":"post","link":"http:\/\/34.227.63.65\/en\/tutorials\/how-to-convert-text-to-columns-in-excel\/","title":{"rendered":"\u25b7 How to Convert Text to Columns in Excel | Open CSV Files"},"content":{"rendered":"<p>When we have files downloaded from tools other than excel, we find a text contained in a single column, which is separated either by<em> commas, periods, asterisks, etc.<\/em>so it is important that you learn <strong>how to convert text to columns in excel<\/strong> to improve the visualization of the information and to be able to work with it.\u00a0<\/p>\n<p>This is what a CSV (Comma Separated Values) file looks like, which is a type of format that can be represented in table form where the columns are separated by commas (or other character) and the rows by respective line breaks.<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"292\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/texto-delimitado-por-caracteres-2.png\" alt=\"CSV file text to columns in excel\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-delimitado-por-caracteres-2.png 540w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-delimitado-por-caracteres-2-300x162.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-delimitado-por-caracteres-2-18x10.png 18w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><figcaption>This is a comma delimited file<\/figcaption><\/figure>\n<h3>STEPS TO CONVERT TEXT TO COLUMNS IN EXCEL:<\/h3>\n<p>There are two ways to perform this action, the first is by using the option in excel tool <strong>- Data - text in columns<\/strong> and the second is by importing the file from <strong>Data- Get data- From text\/CSV.<\/strong> Both are correct, the use will depend on the need of each information we want to visualize.&nbsp;<\/p>\n<h3>RELATED POSTS&nbsp;<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.filetechn.com\/tutoriales\/canva-pro-gratis\/\">Get CANVA PRO Free&nbsp;<\/a><\/li>\n<li><a href=\"https:\/\/www.filetechn.com\/tutoriales\/como-crear-un-logo-gratis-canva\/\">How to create a Free Logo<\/a><\/li>\n<\/ul>\n<h3>Let's see step by step how to convert a text to columns with the <strong>first option:<\/strong><\/h3>\n<p>1. Open the CSV file which we are going to convert from text to columns in excel:<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"89\" src=\"http:\/\/54.157.48.44\/wp-content\/uploads\/2022\/12\/texto-contenido-en-una-columna-en-excel-300x89.png\" alt=\"Text in columns in excel\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-contenido-en-una-columna-en-excel-300x89.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-contenido-en-una-columna-en-excel-18x5.png 18w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-contenido-en-una-columna-en-excel.png 590w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><figcaption>Concatenated text in a single column in excel <\/figcaption><\/figure>\n<p>2. Select the entire first column, in this case column A.<\/p>\n<p>3. In the tool menu select - - in the tool menu select - - in the tool menu select - - in the tool menu select - <strong>Data<\/strong> &#8211; <strong>Text in columns.<\/strong><\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"88\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/herramienta-datos-texto-en-columnas.png\" alt=\"Excel tool - Data - Text in colummas\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/herramienta-datos-texto-en-columnas.png 435w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/herramienta-datos-texto-en-columnas-300x61.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/herramienta-datos-texto-en-columnas-18x4.png 18w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/p>\n<p>4. A window opens, select the option <strong>delimited - next\u00a0<\/strong><strong style=\"font-size: 20px;\">\u00a0<\/strong><\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"301\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/texto-en-colimnas-siguiente.png\" alt=\"text window in columns\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-en-colimnas-siguiente.png 355w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-en-colimnas-siguiente-300x254.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/texto-en-colimnas-siguiente-14x12.png 14w\" sizes=\"(max-width: 355px) 100vw, 355px\" \/><\/p>\n<p>5. Determine the <strong>separators<\/strong> that contain the text, in this case are delimited by the <strong>symbol ( | )<\/strong> which must be entered in the option - <strong>other - <\/strong>and following<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"292\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/elegir-los-separadores-de-datos.png\" alt=\"Column text separators\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/elegir-los-separadores-de-datos.png 351w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/elegir-los-separadores-de-datos-300x250.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/elegir-los-separadores-de-datos-14x12.png 14w\" sizes=\"(max-width: 351px) 100vw, 351px\" \/><\/p>\n<p>6. Set the format of the text data, in this case select the - option.\u00a0<strong>General - \u00a0<\/strong>this option converts numeric values to numbers, date values to dates and all other values to text. Finally select\u00a0<strong style=\"font-size: 20px;\">- Finish<\/strong><\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"290\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/opcion-general-para-formato-de-texto.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/opcion-general-para-formato-de-texto.png 346w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/opcion-general-para-formato-de-texto-300x251.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/opcion-general-para-formato-de-texto-14x12.png 14w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/p>\n<p>7. Finally, we have the text separated in columns to visualize the information through an excel table.<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"236\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/Texto-separado-en-columnas-final.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/Texto-separado-en-columnas-final.png 512w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/Texto-separado-en-columnas-final-300x138.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/Texto-separado-en-columnas-final-18x8.png 18w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<h3>Now, let's see step by step how to convert a text to columns in excel with the <strong>second option:<\/strong><\/h3>\n<p style=\"text-align: justify;\">This option allows you to identify other characters such as \u00f1, \u00ed, among others, which are not normally recognized when converting text to columns, depending on the encoding language you use in your country.<\/p>\n<p>1. Select in the - tool<strong> Data- Get data- From a file- From text\/ CSV<\/strong> in this case<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"519\" height=\"249\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/segunda-opcion-por-obtener-datos-.png\" alt=\"Excel tool to obtain data\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/segunda-opcion-por-obtener-datos-.png 519w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/segunda-opcion-por-obtener-datos--300x144.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/segunda-opcion-por-obtener-datos--18x9.png 18w\" sizes=\"(max-width: 519px) 100vw, 519px\" \/><\/p>\n<p>2. Find the file where it is saved to import it to excel.<\/p>\n<p>3. Once selected, the following window of options will appear to select the file source language, in this case select <strong>- 65001: Unicode (UTF-8)\u00a0<\/strong>and select in<strong style=\"font-size: 20px;\"> Upload<\/strong><\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"574\" height=\"419\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/seleccionar-encoding.png\" alt=\"Encoding of text in columns\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/seleccionar-encoding.png 574w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/seleccionar-encoding-300x219.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/seleccionar-encoding-16x12.png 16w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/p>\n<p>4. Finally, the text will be separated into the respective columns to display the information in a table that you can edit as you wish.<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"195\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/tabla-visualizacion-texto-en-columnas-final.png\" alt=\"Text in columns in a table\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/tabla-visualizacion-texto-en-columnas-final.png 605w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/tabla-visualizacion-texto-en-columnas-final-300x97.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/tabla-visualizacion-texto-en-columnas-final-18x6.png 18w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/p>\n<h2>VIDEO ON HOW TO CONVERT TEXT TO COLUMNS IN EXCEL\u00a0<\/h2>\n<p><br \/>\n<iframe width=\"839\" height=\"472\" src=\"https:\/\/www.youtube.com\/embed\/B1aF5JWtr_Q\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><br \/>\n<\/p>","protected":false},"excerpt":{"rendered":"<p>How to convert a text in a column to go<\/p>","protected":false},"author":2,"featured_media":3777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-3743","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda<\/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:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\" \/>\n<meta property=\"og:description\" content=\"Como convertir un texto en una columna a va\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-14T16:17:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"filetechn\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"filetechn\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\"},\"author\":{\"name\":\"filetechn\",\"@id\":\"https:\/\/34.227.63.65\/en\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b\"},\"headline\":\"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV\",\"datePublished\":\"2022-12-14T16:17:20+00:00\",\"dateModified\":\"2022-12-14T16:17:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\"},\"wordCount\":526,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/34.227.63.65\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png\",\"articleSection\":[\"Tutoriales\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\",\"url\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\",\"name\":\"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\",\"isPartOf\":{\"@id\":\"https:\/\/34.227.63.65\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png\",\"datePublished\":\"2022-12-14T16:17:20+00:00\",\"dateModified\":\"2022-12-14T16:17:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage\",\"url\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png\",\"contentUrl\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png\",\"width\":1280,\"height\":720,\"caption\":\"Convert text to columns in Excel | CSV files\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/34.227.63.65\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/34.227.63.65\/en\/#website\",\"url\":\"https:\/\/34.227.63.65\/en\/\",\"name\":\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\",\"description\":\"Emprendimiento Digital, Tutoriales, Tecnolog\u00eda, Hosting, Wordpress\",\"publisher\":{\"@id\":\"https:\/\/34.227.63.65\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/34.227.63.65\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/34.227.63.65\/en\/#organization\",\"name\":\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\",\"url\":\"https:\/\/34.227.63.65\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/34.227.63.65\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png\",\"contentUrl\":\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png\",\"width\":512,\"height\":512,\"caption\":\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\"},\"image\":{\"@id\":\"https:\/\/34.227.63.65\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/34.227.63.65\/en\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b\",\"name\":\"filetechn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/34.227.63.65\/en\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g\",\"caption\":\"filetechn\"},\"url\":\"http:\/\/34.227.63.65\/en\/author\/filetechn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","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:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/","og_locale":"en_US","og_type":"article","og_title":"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","og_description":"Como convertir un texto en una columna a va","og_url":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/","og_site_name":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","article_published_time":"2022-12-14T16:17:20+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png","type":"image\/png"}],"author":"filetechn","twitter_card":"summary_large_image","twitter_misc":{"Written by":"filetechn","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#article","isPartOf":{"@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/"},"author":{"name":"filetechn","@id":"https:\/\/34.227.63.65\/en\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b"},"headline":"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV","datePublished":"2022-12-14T16:17:20+00:00","dateModified":"2022-12-14T16:17:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/"},"wordCount":526,"commentCount":0,"publisher":{"@id":"https:\/\/34.227.63.65\/en\/#organization"},"image":{"@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png","articleSection":["Tutoriales"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/","url":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/","name":"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","isPartOf":{"@id":"https:\/\/34.227.63.65\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png","datePublished":"2022-12-14T16:17:20+00:00","dateModified":"2022-12-14T16:17:20+00:00","breadcrumb":{"@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#primaryimage","url":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png","contentUrl":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/convert-text-to-columns-on-excel-easy.png","width":1280,"height":720,"caption":"Convert text to columns in Excel | CSV files"},{"@type":"BreadcrumbList","@id":"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/34.227.63.65\/en\/"},{"@type":"ListItem","position":2,"name":"\u25b7\u00a0Como Convertir Texto a Columnas en Excel | Abrir archivos CSV"}]},{"@type":"WebSite","@id":"https:\/\/34.227.63.65\/en\/#website","url":"https:\/\/34.227.63.65\/en\/","name":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","description":"Emprendimiento Digital, Tutoriales, Tecnolog\u00eda, Hosting, Wordpress","publisher":{"@id":"https:\/\/34.227.63.65\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/34.227.63.65\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/34.227.63.65\/en\/#organization","name":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","url":"https:\/\/34.227.63.65\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/34.227.63.65\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png","contentUrl":"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png","width":512,"height":512,"caption":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda"},"image":{"@id":"https:\/\/34.227.63.65\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/34.227.63.65\/en\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b","name":"filetechn","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/34.227.63.65\/en\/#\/schema\/person\/image\/","url":"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g","contentUrl":"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g","caption":"filetechn"},"url":"http:\/\/34.227.63.65\/en\/author\/filetechn\/"}]}},"_links":{"self":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/posts\/3743"}],"collection":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/comments?post=3743"}],"version-history":[{"count":0,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/posts\/3743\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/media\/3777"}],"wp:attachment":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/media?parent=3743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/categories?post=3743"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/tags?post=3743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}