{"id":3766,"date":"2007-12-31T19:00:00","date_gmt":"2008-01-01T00:00:00","guid":{"rendered":"https:\/\/www.cavsi.com\/blog\/?p=282"},"modified":"2007-12-31T19:00:00","modified_gmt":"2008-01-01T00:00:00","slug":"como-importar-una-pgina-web-a-excel","status":"publish","type":"post","link":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/","title":{"rendered":"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel?"},"content":{"rendered":"

Otra herramienta para importar datos, nos permite obtener datos Desde Web.
\nPulsando sobre ella, se abrir\u00e1 una ventana del navegador, donde se marcan con flechas amarillas las tablas existentes en la p\u00e1gina web.<\/p>\n

Para elegir las tablas, basta con pulsar sobre las flechas.
\nEn el bot\u00f3n Opciones… de esta ventana, podremos elegir por ejemplo, si importar o no el formato de la tabla.
\nTen en cuenta que aunque no se vean los bordes, la mayor\u00eda de las webs est\u00e1n estructuradas con tablas.
\nUna vez finalizada la elecci\u00f3n, pulsamos Importar.<\/p>\n

Veremos entonces la misma ventana que con Access, donde elegir si importar en la hoja o en una nueva, y donde podremos modificar en Preferencias las opciones de actualizaci\u00f3n de la conexi\u00f3n.<\/p>\n

Otra forma r\u00e1pida de hacer esto, es directamente seleccionar la tabla en nuestro navegador, copiarla con Ctrl + C y pegarla en la hoja de Excel. Despu\u00e9s podremos modificar el formato y si queremos que haya actualizaci\u00f3n.<\/p>\n

Importar de otros programas.
\nLa mayor\u00eda de tablas que nos encontremos en otros documentos, y podamos seleccionar y copiar, Excel nos permitir\u00e1 pegarlas en una hoja de c\u00e1lculo. En algunos nos permitir\u00e1 crear conexiones de actualizaci\u00f3n y en otros no. Y otros programas nos permitir\u00e1n exportar tablas directamente a Excel. Por ejemplo, si navegamos con Internet Explorer, al hacer clic derecho sobre una tabla, en el men\u00fa contextual encontraremos la opci\u00f3n Exportar a Excel, que volcar\u00e1 los datos de la tabla en una nueva hoja de c\u00e1lculo.<\/p>\n","protected":false},"excerpt":{"rendered":"

Otra herramienta para importar datos, nos permite obtener datos Desde Web.
\nPulsando sobre ella, se abrir\u00e1 una ventana del navegador, donde se marcan con flechas amarillas las tablas existentes en la p\u00e1gina web.<\/p>\n

Para elegir las tablas, basta con pulsar sobre las flechas.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[189],"tags":[198],"class_list":["post-3766","post","type-post","status-publish","format-standard","hentry","category-excel","tag-trucos-excel"],"yoast_head":"\n\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel? - CAVSI<\/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.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel? - CAVSI\" \/>\n<meta property=\"og:description\" content=\"Otra herramienta para importar datos, nos permite obtener datos Desde Web. Pulsando sobre ella, se abrir\u00e1 una ventana del navegador, donde se marcan con flechas amarillas las tablas existentes en la p\u00e1gina web. Para elegir las tablas, basta con pulsar sobre las flechas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CAVSI\" \/>\n<meta property=\"article:published_time\" content=\"2008-01-01T00:00:00+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\"},\"headline\":\"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel?\",\"datePublished\":\"2008-01-01T00:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\"},\"wordCount\":269,\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"keywords\":[\"Trucos Excel\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\",\"name\":\"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel? - CAVSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\"},\"datePublished\":\"2008-01-01T00:00:00+00:00\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"name\":\"CAVSI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\",\"name\":\"CAVSI\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"width\":300,\"height\":70,\"caption\":\"CAVSI\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.cavsi.com\/espanol\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel? - CAVSI","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.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel? - CAVSI","og_description":"Otra herramienta para importar datos, nos permite obtener datos Desde Web. Pulsando sobre ella, se abrir\u00e1 una ventana del navegador, donde se marcan con flechas amarillas las tablas existentes en la p\u00e1gina web. Para elegir las tablas, basta con pulsar sobre las flechas.","og_url":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/","og_site_name":"CAVSI","article_published_time":"2008-01-01T00:00:00+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/#article","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/"},"author":{"name":"admin","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff"},"headline":"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel?","datePublished":"2008-01-01T00:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/"},"wordCount":269,"publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"keywords":["Trucos Excel"],"articleSection":["Microsoft Excel"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/","url":"https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/","name":"\u00bfC\u00f3mo Importar una p\u00e1gina Web a Excel? - CAVSI","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/#website"},"datePublished":"2008-01-01T00:00:00+00:00","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cavsi.com\/espanol\/blog\/como-importar-una-pgina-web-a-excel\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.cavsi.com\/espanol\/#website","url":"https:\/\/www.cavsi.com\/espanol\/","name":"CAVSI","description":"","publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.cavsi.com\/espanol\/#organization","name":"CAVSI","url":"https:\/\/www.cavsi.com\/espanol\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","width":300,"height":70,"caption":"CAVSI"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.cavsi.com\/espanol"]}]}},"_links":{"self":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/3766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/comments?post=3766"}],"version-history":[{"count":0,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/3766\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/media?parent=3766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/categories?post=3766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/tags?post=3766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}