{"id":962,"date":"2023-05-03T12:35:50","date_gmt":"2023-05-03T15:35:50","guid":{"rendered":"https:\/\/www.rdwd.com.br\/blog\/?p=962"},"modified":"2023-05-03T12:35:50","modified_gmt":"2023-05-03T15:35:50","slug":"puxar-tabela-de-sites-para-o-excel","status":"publish","type":"post","link":"https:\/\/www.rdwd.com.br\/blog\/puxar-tabela-de-sites-para-o-excel\/","title":{"rendered":"Puxar tabela de sites para o excel"},"content":{"rendered":"\n<p class=\"has-medium-font-size\">Primeiramente copie o link do site, com o link em m\u00e3os fa\u00e7a esse caminho, Dados, procure o \u00edcone com um formul\u00e1rio e mundo azul que \u00e9 o &#8220;Da Web&#8221; clique nele.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1bs.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"201\" src=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1bs-1024x201.jpg\" alt=\"\" class=\"wp-image-963\" srcset=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1bs-1024x201.jpg 1024w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1bs-300x59.jpg 300w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1bs-768x151.jpg 768w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1bs.jpg 1420w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p>Ao abrir teremos essa aba;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cs.jpg\"><img decoding=\"async\" width=\"881\" height=\"284\" src=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cs.jpg\" alt=\"\" class=\"wp-image-964\" srcset=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cs.jpg 881w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cs-300x97.jpg 300w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cs-768x248.jpg 768w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">Cole a URL no campo e d\u00ea OK, o excel vai analisar o site todo e puxar todas as tabelas dispon\u00edveis, assim que puxar todas as tabelas ir\u00e1 abrir uma coluna do lado esquerdo com as tabelas dispon\u00edveis, clique nos links que vai abrir uma pr\u00e9 visualiza\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cd.jpg\"><img decoding=\"async\" width=\"1024\" height=\"818\" src=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cd-1024x818.jpg\" alt=\"\" class=\"wp-image-965\" srcset=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cd-1024x818.jpg 1024w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cd-300x240.jpg 300w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cd-768x614.jpg 768w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cd.jpg 1105w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">Ap\u00f3s decidir qual tabela deseja s\u00f3 clicar em carregar, vai ficar dessa forma, como abaixo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"272\" src=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf-1024x272.jpg\" alt=\"\" class=\"wp-image-967\" srcset=\"https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf-1024x272.jpg 1024w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf-300x80.jpg 300w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf-768x204.jpg 768w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf-1536x408.jpg 1536w, https:\/\/www.rdwd.com.br\/blog\/wp-content\/uploads\/2023\/05\/1cf.jpg 1918w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">Pronto pode trabalhar com a tabela da forma que quiser, bom trabalho.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Primeiramente copie o link do site, com o link em m\u00e3os fa\u00e7a esse caminho, Dados, procure o \u00edcone com um formul\u00e1rio e mundo azul que \u00e9 o &#8220;Da Web&#8221; clique nele. Ao abrir teremos essa aba; Cole a URL no campo e d\u00ea OK, o excel vai analisar o site todo e puxar todas as &hellip; <a href=\"https:\/\/www.rdwd.com.br\/blog\/puxar-tabela-de-sites-para-o-excel\/\" class=\"more-link\">Continue lendo<span class=\"screen-reader-text\"> &#8220;Puxar tabela de sites para o excel&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[34,38,40,37,39],"class_list":["post-962","post","type-post","status-publish","format-standard","hentry","category-blog","tag-excel","tag-puxar-dados-de-tabela-a-internet","tag-tabela","tag-tabela-da-internet","tag-tabelas"],"a3_pvc":{"activated":false,"total_views":0,"today_views":0},"_links":{"self":[{"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/posts\/962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/comments?post=962"}],"version-history":[{"count":1,"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/posts\/962\/revisions"}],"predecessor-version":[{"id":968,"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/posts\/962\/revisions\/968"}],"wp:attachment":[{"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/media?parent=962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/categories?post=962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rdwd.com.br\/blog\/wp-json\/wp\/v2\/tags?post=962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}