{"id":15648,"date":"2024-03-20T19:31:30","date_gmt":"2024-03-20T22:31:30","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=15648"},"modified":"2025-01-27T20:21:43","modified_gmt":"2025-01-27T23:21:43","slug":"power-query-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/","title":{"rendered":"POWER QUERY EN EXCEL"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong><u>DESCUBRE EL PODER DE POWER QUERY EN EXCEL: AUTOMATIZA Y TRANSFORMA TUS DATOS<\/u><\/strong><\/span><\/p><div id=\"excel-2094229502\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>En el mundo de la gesti\u00f3n de datos y el an\u00e1lisis en Excel, existe una herramienta que ha ganado una reputaci\u00f3n imponente por su capacidad para transformar la forma en que interactuamos con los datos: <strong>\u00a1Power Query!<\/strong> Desde su introducci\u00f3n en Excel 2010 como un complemento, hasta convertirse en una caracter\u00edstica integral en versiones posteriores, Power Query ha revolucionado la forma en que gestionamos y manipulamos conjuntos de datos en Excel. En este art\u00edculo, exploraremos qu\u00e9 es Power Query, para qu\u00e9 sirve, c\u00f3mo utilizarlo en Excel y las incre\u00edbles posibilidades que ofrece.<\/p>\n<h2>\u00bfQU\u00c9 ES POWER QUERY?<\/h2>\n<p><strong>Power Query<\/strong> es una herramienta de extracci\u00f3n, transformaci\u00f3n y carga (ETL) que permite a los usuarios conectarse, combinar y transformar datos de diversas fuentes para su an\u00e1lisis en Excel. Con una interfaz intuitiva y potentes capacidades de manipulaci\u00f3n de datos, <strong>Power Query<\/strong> elimina la necesidad de tediosas tareas manuales de limpieza y preparaci\u00f3n de datos, permitiendo a los usuarios enfocarse en el an\u00e1lisis y la generaci\u00f3n de informaci\u00f3n valiosa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15654\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-2.png\" alt=\"\" width=\"1686\" height=\"1080\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-2.png 1686w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-2-1000x641.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-2-768x492.png 768w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-2-1536x984.png 1536w\" sizes=\"auto, (max-width: 1686px) 100vw, 1686px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfPARA QU\u00c9 SIRVE POWER QUERY EN EXCEL?<\/h2>\n<p style=\"padding-left: 40px;\"><strong>Power Query<\/strong> es una herramienta vers\u00e1til que puede utilizarse para una amplia gama de tareas relacionadas con la manipulaci\u00f3n de datos, incluyendo:<\/p>\n<p style=\"padding-left: 40px;\"><strong>Conexi\u00f3n a diversas fuentes de datos:<\/strong> Power Query permite conectarse a una variedad de fuentes de datos, como bases de datos, archivos de texto, archivos CSV, archivos XML, carpetas locales e incluso servicios en la nube como Azure y SharePoint.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Transformaci\u00f3n de datos:<\/strong> Con Power Query, puedes limpiar, filtrar, agrupar, ordenar y transformar datos de manera r\u00e1pida y sencilla. Ya no es necesario realizar estas tareas manualmente, ya que Power Query automatiza el proceso y proporciona un historial de acciones para que puedas replicarlas f\u00e1cilmente.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Combinaci\u00f3n de datos:<\/strong> Power Query facilita la combinaci\u00f3n de datos de m\u00faltiples fuentes en una sola tabla. Puedes fusionar, apilar o unir tablas de datos para crear conjuntos de datos m\u00e1s completos y significativos.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Creaci\u00f3n de consultas personalizadas:<\/strong> Con Power Query, puedes crear consultas personalizadas utilizando el lenguaje de consulta M. Esto te permite realizar transformaciones avanzadas y c\u00e1lculos complejos en tus datos, adapt\u00e1ndolos a tus necesidades espec\u00edficas.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Actualizaci\u00f3n autom\u00e1tica de datos:<\/strong> Una vez que hayas configurado una consulta en Power Query, puedes programar Excel para que actualice autom\u00e1ticamente los datos en funci\u00f3n de una programaci\u00f3n espec\u00edfica, lo que te permite mantener tus an\u00e1lisis siempre actualizados con los \u00faltimos datos disponibles.<\/p>\n<h2>\u00bfQU\u00c9 DATOS PUEDES USAR EN POWER QUERY?<\/h2>\n<p style=\"padding-left: 40px;\">En <strong>Power Query<\/strong>, puedes trabajar con una amplia variedad de tipos de datos y fuentes de datos. Algunos ejemplos comunes incluyen:<\/p>\n<p style=\"padding-left: 40px;\"><strong>Archivos de Excel:<\/strong> Puedes importar datos de archivos de Excel (.xlsx) tanto locales como en la nube (OneDrive, SharePoint, etc.).<\/p>\n<p style=\"padding-left: 40px;\"><strong>Archivos de texto:<\/strong> Power Query puede extraer datos de archivos de texto delimitados por comas (CSV), archivos de texto delimitados por tabulaciones, archivos de texto delimitados por otros caracteres, etc.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Bases de datos relacionales:<\/strong> Puedes conectarte a bases de datos SQL Server, MySQL, Oracle, PostgreSQL y otras bases de datos relacionales para importar tablas y realizar consultas.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Bases de datos NoSQL:<\/strong> Power Query tambi\u00e9n es compatible con bases de datos NoSQL como MongoDB, Azure Cosmos DB y otros, mediante la conexi\u00f3n a trav\u00e9s de OData.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Fuentes en la nube:<\/strong> Puedes importar datos de servicios en la nube como Azure SQL Database, Azure Blob Storage, Google BigQuery, Amazon Redshift, entre otros.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Archivos XML:<\/strong> Power Query puede extraer datos de archivos XML, lo que es \u00fatil para trabajar con datos estructurados en formato XML.<\/p>\n<p style=\"padding-left: 40px;\"><strong>API web:<\/strong> Puedes conectarte a servicios web y consumir datos a trav\u00e9s de API utilizando Power Query, lo que te permite integrar datos en tiempo real en tus an\u00e1lisis de Excel.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Otras fuentes de datos:<\/strong> Power Query es extremadamente vers\u00e1til y puede conectarse a una amplia gama de otras fuentes de datos, como carpetas locales, feeds RSS, datos de p\u00e1ginas web, datos de SharePoint, archivos JSON, entre otros.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15655\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-3.png\" alt=\"\" width=\"1686\" height=\"1077\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-3.png 1686w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-3-1000x639.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-3-768x491.png 768w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-3-1536x981.png 1536w\" sizes=\"auto, (max-width: 1686px) 100vw, 1686px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>C\u00d3MO UTILIZAR POWER QUERY EN EXCEL<\/h2>\n<p>Usar Power Query en Excel es sencillo y requiere cuatro pasos principales:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15651\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/power-q-1.png\" alt=\"\" width=\"502\" height=\"118\" \/><\/p>\n<p style=\"padding-left: 40px;\"><strong>Conectar:<\/strong> Abre Excel y selecciona la pesta\u00f1a <strong>\u00abDatos\u00bb<\/strong>. Haz clic en <strong>\u00abObtener datos\u00bb<\/strong> y elige la fuente de datos a la que deseas conectarte, ya sea en la nube, en un servicio o localmente.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Transformar datos:<\/strong> Una vez que hayas importado los datos, Power Query abrir\u00e1 una ventana donde podr\u00e1s realizar diversas transformaciones, como filtrar filas, eliminar columnas, cambiar tipos de datos, agregar columnas calculadas y m\u00e1s.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Combinar datos:<\/strong>\u00a0Power Query proporciona un editor de consultas intuitivo que te permite visualizar y modificar todas las transformaciones aplicadas a tus datos. Puede combinar varias consultas en el libro de Excel anexando o fusion\u00e1ndolas. Puedes agregar, eliminar o reorganizar pasos de transformaci\u00f3n seg\u00fan sea necesario.<\/p>\n<p style=\"padding-left: 40px;\"><strong>Cargar datos:<\/strong> Una vez que hayas finalizado la transformaci\u00f3n de tus datos, puedes cargarlos en Excel haciendo clic en <em>\u00abCerrar y cargar\u00bb<\/em> en la pesta\u00f1a<em> \u00abInicio\u00bb<\/em>. Puedes elegir cargar los datos en una nueva hoja de c\u00e1lculo, en una tabla existente o en un modelo de datos.<\/p>\n<blockquote>\n<p style=\"padding-left: 40px;\"><strong>En los siguientes art\u00edculos exploraremos cada fase con m\u00e1s detalle.<\/strong><\/p>\n<\/blockquote>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p><strong>Power Query<\/strong> es una herramienta imprescindible para cualquier persona que trabaje con datos en Excel. Su capacidad para automatizar tareas tediosas de preparaci\u00f3n de datos, su flexibilidad para conectarse a diversas fuentes de datos y su potencia para realizar transformaciones avanzadas lo convierten en un aliado invaluable para el an\u00e1lisis de datos.<\/p>\n<hr \/>\n<h2>MIRA TAMBI\u00c9N<\/h2>\n<ul>\n<li><a href=\"https:\/\/excelfull.com\/excel\/importar-datos-desde-la-web-con-power-query\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: IMPORTAR DATOS DESDE LA WEB<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/power-query-en-excel-importar-datos\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: IMPORTAR DATOS DESDE UNA TABLA DE EXCEL<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/power-query-para-principiantes-transformar-datos\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 ENCABEZADOS<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/convertir-fechas-con-power-query\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FECHAS<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/dividir-datos-en-varias-columnas-power-query\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 DIVIDIR DATOS EN VARIAS COLUMNAS<\/a><\/li>\n<\/ul>\n<hr \/>\n<blockquote><p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a>.<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb <\/span>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p><\/blockquote>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; DESCUBRE EL PODER DE &#8230; <a title=\"POWER QUERY EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\" aria-label=\"Leer m\u00e1s sobre POWER QUERY EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":15649,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,539,808],"tags":[502,807],"class_list":["post-15648","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-avanzado","category-power-query","tag-datos","tag-power-query","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>POWER QUERY EN EXCEL- Excelfull.com<\/title>\n<meta name=\"description\" content=\"Power Query es una herramienta en Excel que permite importar, transformar y cargar datos de diversas fuentes para su an\u00e1lisis eficiente.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"POWER QUERY EN EXCEL- Excelfull.com\" \/>\n<meta property=\"og:description\" content=\"Power Query es una herramienta en Excel que permite importar, transformar y cargar datos de diversas fuentes para su an\u00e1lisis eficiente.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-20T22:31:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-27T23:21:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.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=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"POWER QUERY EN EXCEL\",\"datePublished\":\"2024-03-20T22:31:30+00:00\",\"dateModified\":\"2025-01-27T23:21:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\"},\"wordCount\":1043,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png\",\"keywords\":[\"datos\",\"power query\"],\"articleSection\":[\"Excel\",\"Excel Avanzado\",\"Power Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\",\"name\":\"POWER QUERY EN EXCEL- Excelfull.com\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png\",\"datePublished\":\"2024-03-20T22:31:30+00:00\",\"dateModified\":\"2025-01-27T23:21:43+00:00\",\"description\":\"Power Query es una herramienta en Excel que permite importar, transformar y cargar datos de diversas fuentes para su an\u00e1lisis eficiente.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"POWER QUERY EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"POWER QUERY EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"POWER QUERY EN EXCEL- Excelfull.com","description":"Power Query es una herramienta en Excel que permite importar, transformar y cargar datos de diversas fuentes para su an\u00e1lisis eficiente.","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:\/\/excelfull.com\/excel\/power-query-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"POWER QUERY EN EXCEL- Excelfull.com","og_description":"Power Query es una herramienta en Excel que permite importar, transformar y cargar datos de diversas fuentes para su an\u00e1lisis eficiente.","og_url":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2024-03-20T22:31:30+00:00","article_modified_time":"2025-01-27T23:21:43+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"POWER QUERY EN EXCEL","datePublished":"2024-03-20T22:31:30+00:00","dateModified":"2025-01-27T23:21:43+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/"},"wordCount":1043,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png","keywords":["datos","power query"],"articleSection":["Excel","Excel Avanzado","Power Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/power-query-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/","url":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/","name":"POWER QUERY EN EXCEL- Excelfull.com","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png","datePublished":"2024-03-20T22:31:30+00:00","dateModified":"2025-01-27T23:21:43+00:00","description":"Power Query es una herramienta en Excel que permite importar, transformar y cargar datos de diversas fuentes para su an\u00e1lisis eficiente.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/power-query-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/03\/POWER-QUERY-EN-EXCEL.png","width":1280,"height":720,"caption":"POWER QUERY EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/power-query-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"POWER QUERY EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=15648"}],"version-history":[{"count":9,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15648\/revisions"}],"predecessor-version":[{"id":18260,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15648\/revisions\/18260"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/15649"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=15648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=15648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=15648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}