{"id":902,"date":"2018-03-22T20:11:01","date_gmt":"2018-03-22T20:11:01","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=902"},"modified":"2020-12-23T20:14:39","modified_gmt":"2020-12-23T20:14:39","slug":"de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/","title":{"rendered":"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI"},"content":{"rendered":"<h2>Enviar datos de google sheets a Excel<\/h2>\n<p>En la publicaci\u00f3n anterior se detall\u00f3 una aplicaci\u00f3n que env\u00eda informaci\u00f3n a Google Sheets. Este es un complemento: se trata de la descarga de informaci\u00f3n en Excel. Si eres un usuario frecuente de Excel y Google Sheets, sabr\u00e1s que el intercambio de informaci\u00f3n manual entre las dos herramientas es un poco tedioso, sobre todo si tratas de mantener dos archivos sincronizados. La alternativa presentada aqu\u00ed es una macro en Excel que descarga informaci\u00f3n desde Google Sheets con un solo click. Se trata de una variaci\u00f3n al proyecto de Bruce Mcpherson (<em>Desktop Liberation<\/em>) que puedes usar de forma inmediata.<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<p>Instrucciones y condiciones bajo las que opera este archivo (<strong>FromSheetsToExcel, <\/strong>descarga el material m\u00e1s abajo) :<\/p>\n<ul>\n<li>Desde luego, necesitas una cuenta de Google.<\/li>\n<li>Como paso inicial, debes conceder tu permiso para que esta aplicaci\u00f3n pueda acceder a tus hojas de c\u00e1lculo en Google Sheets, y descargar datos de aquellas que indiques. Para conceder este permiso, da click en el bot\u00f3n con letras en rojo:<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisos.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-888\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisos.png\" alt=\"\" width=\"271\" height=\"95\" \/><\/a><\/p>\n<ul>\n<li>Ver\u00e1s una ventana como esta. Click en PERMITIR (&#8220;ALLOW&#8221;):<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosDos.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-889 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosDos.png\" alt=\"\" width=\"425\" height=\"342\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosDos.png 425w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosDos-300x241.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosDos-336x270.png 336w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/a><\/p>\n<ul>\n<li>La ventana desaparece. Los permisos fueron concedidos. Si tuvieras alg\u00fan problema o mensaje de error,ve a las opciones de internet y reduce el nivel de seguridad para que permita la ejecuci\u00f3n de esta aplicaci\u00f3n. Funciona bien con niveles medio y medio bajo.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosTres.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-892 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosTres.png\" alt=\"\" width=\"416\" height=\"390\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosTres.png 416w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosTres-300x281.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosTres-288x270.png 288w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a><\/p>\n<ul>\n<li>Ahora est\u00e1s en condici\u00f3n de ejecutar la aplicaci\u00f3n. Necesitas lo siguiente:\n<ul>\n<li>Google Sheets ID: el ID de la hoja en Google Sheets desde la que quieres descargar la informaci\u00f3n a Excel. Como ejemplo:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\">https:\/\/docs.google.com\/spreadsheets\/d\/<span style=\"color: #ff0000;\">1CkaztFTRjAw82qXOlXulX6GRHw_dgMQWS6SqiTypsUE<\/span>\/<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Cuando des click en &#8220;Traer datos&#8221;, aparece una ventana preguntando por el ID de la hoja desde donde quieres descargar la informaci\u00f3n. Aseg\u00farate de tener los permisos necesarios para editar la hoja a donde llegar\u00e1 la informaci\u00f3n (edici\u00f3n).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCuatro.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-893 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCuatro.png\" alt=\"\" width=\"373\" height=\"166\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCuatro.png 373w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCuatro-300x134.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCuatro-360x160.png 360w\" sizes=\"auto, (max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Los datos se mover\u00e1n desde la hoja &#8220;<strong>data<\/strong>&#8221; a una hoja con el mismo nombre. Si no existe en Excel, la aplicaci\u00f3n crear\u00e1 esta hoja. Si quieres descargar informaci\u00f3n a una hoja distinta, solo cambia el nombre de la hoja en Google Sheets (evita caracteres especiales).<\/li>\n<li>Cuando el proceso termine, recibir\u00e1s una notificaci\u00f3n.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCinco.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-894\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCinco.png\" alt=\"\" width=\"394\" height=\"156\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCinco.png 394w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCinco-300x119.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/permisosCinco-360x143.png 360w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/a><\/p>\n<h2>El material<\/h2>\n<p>Descarga la plantilla de Excel:\u00a0<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/www.fditf.com\/bi\/download\/904\/?tmstv=1782513823\" rel=\"nofollow\" id=\"download-link-904\" data-redirect=\"false\" >\n\tdeGoogleSheetsAExcel<\/a>\n<\/p>\n<p>Consulta aqu\u00ed el archivo de prueba (Google Sheets): <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1CkaztFTRjAw82qXOlXulX6GRHw_dgMQWS6SqiTypsUE\" target=\"_blank\" rel=\"noopener noreferrer\">abrir archivo<\/a>.<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- RegularPostBottom --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2196072090\" data-ad-format=\"auto\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enviar datos de google sheets a Excel En la publicaci\u00f3n anterior se detall\u00f3 una aplicaci\u00f3n que env\u00eda informaci\u00f3n a Google Sheets. Este es un complemento: se trata de la descarga de informaci\u00f3n en Excel. Si eres un usuario frecuente de <a href=\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,10,113],"tags":[7,11,21],"class_list":["post-902","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-google-sheets","category-google-sheets-api","tag-excel","tag-google-sheets","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"Enviar datos de Google Sheets a Excel. Descarga la plantilla y \u00fasala en tus proyectos. El archivo est\u00e1 listo para usarse.\" \/>\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.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"Enviar datos de Google Sheets a Excel. Descarga la plantilla y \u00fasala en tus proyectos. El archivo est\u00e1 listo para usarse.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-22T20:11:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-23T20:14:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg\" \/>\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\/jpeg\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI\",\"datePublished\":\"2018-03-22T20:11:01+00:00\",\"dateModified\":\"2020-12-23T20:14:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/\"},\"wordCount\":417,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/meta.jpg\",\"keywords\":[\"Excel\",\"Google Sheets\",\"VBA\"],\"articleSection\":[\"Excel\",\"Google Sheets\",\"Google Sheets API\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/\",\"name\":\"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/meta.jpg\",\"datePublished\":\"2018-03-22T20:11:01+00:00\",\"dateModified\":\"2020-12-23T20:14:39+00:00\",\"description\":\"Enviar datos de Google Sheets a Excel. Descarga la plantilla y \u00fasala en tus proyectos. El archivo est\u00e1 listo para usarse.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/meta.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/meta.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI - Business Intelligence MX","description":"Enviar datos de Google Sheets a Excel. Descarga la plantilla y \u00fasala en tus proyectos. El archivo est\u00e1 listo para usarse.","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.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/","og_locale":"en_US","og_type":"article","og_title":"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI - Business Intelligence MX","og_description":"Enviar datos de Google Sheets a Excel. Descarga la plantilla y \u00fasala en tus proyectos. El archivo est\u00e1 listo para usarse.","og_url":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-03-22T20:11:01+00:00","article_modified_time":"2020-12-23T20:14:39+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","type":"image\/jpeg"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI","datePublished":"2018-03-22T20:11:01+00:00","dateModified":"2020-12-23T20:14:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/"},"wordCount":417,"commentCount":2,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","keywords":["Excel","Google Sheets","VBA"],"articleSection":["Excel","Google Sheets","Google Sheets API"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/","url":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/","name":"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","datePublished":"2018-03-22T20:11:01+00:00","dateModified":"2020-12-23T20:14:39+00:00","description":"Enviar datos de Google Sheets a Excel. Descarga la plantilla y \u00fasala en tus proyectos. El archivo est\u00e1 listo para usarse.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"\u25b6 De Google Sheets a Excel con un click (II): descarga de datos. #GoogleSheetsAPI"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=902"}],"version-history":[{"count":5,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/902\/revisions"}],"predecessor-version":[{"id":5203,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/902\/revisions\/5203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/897"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}