{"id":13964,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/filterxml\/"},"modified":"2021-02-26T08:48:03","modified_gmt":"2021-02-26T08:48:03","slug":"filterxml","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/filterxml\/","title":{"rendered":"FILTERXML"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n Espec\u00edfica para Trabajar con Datos XML<\/h2>\n

La funci\u00f3n FILTERXML de Excel permite extraer informaci\u00f3n espec\u00edfica de datos XML utilizando una consulta XPath. Esta funci\u00f3n resulta extremadamente \u00fatil para analizar datos en formato XML, ya que posibilita la selecci\u00f3n de segmentos concretos del mismo mediante el lenguaje XPath.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n FILTERXML es la siguiente:<\/p>\n

FILTERXML(xml, xpath)<\/code><\/pre>\n
Donde: <\/p>\n
    \n
  • xml:<\/strong> es el texto que contiene el c\u00f3digo XML.<\/li>\n
  • xpath:<\/strong> es la expresi\u00f3n XPath que especifica las partes del documento XML que queremos extraer.<\/li>\n<\/ul>\n
    Veamos un ejemplo b\u00e1sico de su uso:<\/p>\n
    =FILTERXML(\"<empleados><empleado><nombre>Juan<\/nombre><\/empleado><empleado><nombre>Ana<\/nombre><\/empleado><\/empleados>\", \"\/\/nombre\")<\/code><\/pre>\n
    Este ejemplo extrae los nombres de los empleados, resultando en \u00abJuan\u00bb y \u00abAna\u00bb.<\/p>\n
    Casos Pr\u00e1cticos de Aplicaci\u00f3n<\/h2>\n
    Ejemplo 1: Extracci\u00f3n de Datos de un Reporte Meteorol\u00f3gico<\/h2>\n
    Imaginemos que hemos recibido un archivo XML con informaci\u00f3n meteorol\u00f3gica y deseamos extraer la temperatura actual:<\/p>\n
    =FILTERXML(\"<clima><temperatura>20\u00b0C<\/temperatura><\/clima>\", \"\/clima\/temperatura\")<\/code><\/pre>\n
    En este caso, la funci\u00f3n devolver\u00e1 \u00ab20\u00b0C\u00bb, valor que se encuentra dentro del elemento <temperatura> del documento XML.<\/p>\n
    Ejemplo 2: An\u00e1lisis de Datos de Productos<\/h2>\n
    Consideremos que disponemos de un listado de productos en formato XML y queremos obtener los nombres de los productos:<\/p>\n
    =FILTERXML(\"<productos><producto><nombre>L\u00e1piz<\/nombre><\/producto><producto><nombre>Cuaderno<\/nombre><\/producto><\/productos>\", \"\/\/nombre\")<\/code><\/pre>\n
    Este ejemplo nos proporcionar\u00e1 los nombres de todos los productos listados, en este caso \u00abL\u00e1piz\u00bb y \u00abCuaderno\u00bb. Utilizando la sintaxis correcta de XPath, podemos seleccionar y extraer cualquier segmento del documento XML seg\u00fan nuestras necesidades.<\/p>\n
    Como podemos ver, FILTERXML es una herramienta eficaz para el tratamiento de datos XML directamente desde Excel, facilitando el an\u00e1lisis y la manipulaci\u00f3n de informaci\u00f3n compleja almacenada en este formato.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve datos espec\u00edficos del contenido XML usando el XPath especificado<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[548],"tags":[],"class_list":["post-13964","post","type-post","status-publish","format-standard","hentry","category-web-12"],"acf":[],"yoast_head":"\nFunci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FILTERXML de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/filterxml\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FILTERXML de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/filterxml\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:48:03+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/filterxml\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/filterxml\/\",\"name\":\"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:48:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n FILTERXML de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/filterxml\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/filterxml\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/filterxml\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web\",\"item\":\"https:\/\/functiontranslator.com\/es\/web-12\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"FILTERXML\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n FILTERXML de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/filterxml\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n FILTERXML de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/filterxml\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/filterxml\/","url":"https:\/\/functiontranslator.com\/es\/filterxml\/","name":"Funci\u00f3n FILTERXML en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:48:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n FILTERXML de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/filterxml\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/filterxml\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/filterxml\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Web","item":"https:\/\/functiontranslator.com\/es\/web-12\/"},{"@type":"ListItem","position":3,"name":"FILTERXML"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13964"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13964\/revisions"}],"predecessor-version":[{"id":30023,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13964\/revisions\/30023"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}