{"id":883,"date":"2018-03-22T06:41:01","date_gmt":"2018-03-22T06:41:01","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=883"},"modified":"2023-11-04T03:36:22","modified_gmt":"2023-11-04T03:36:22","slug":"de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/","title":{"rendered":"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click."},"content":{"rendered":"<h2>Enviar datos de excel a google sheets<\/h2>\n<p>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. Hay una alternativa que automatiza una buena parte del proceso con la API de Google Drive (se describir\u00e1 en siguientes publicaciones), pero eso no anula el proceso de importaci\u00f3n del archivo de Excel, conversi\u00f3n a Google Seets, traslado de informaci\u00f3n, etc. La alternativa presentada aqu\u00ed es una macro desde Excel que env\u00eda informaci\u00f3n a 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><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2><strong>Instrucciones para enviar datos de Excel a Google Sheets<\/strong><\/h2>\n<p>Instrucciones y condiciones bajo las que opera este archivo (<strong>FromExcelToSheets, <\/strong>descarga el material m\u00e1s abajo) :<\/p>\n<ul>\n<li>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 modificar 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 a la que quieres enviar la informaci\u00f3n desde 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;\">1fkJxMHx8uSrP9GL4f-DcFFtr72yN7g1pa9gg3SccFnM<\/span>\/<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Cuando des click en &#8220;Enviar datos&#8221;, aparece una ventana preguntando por el ID de la hoja a donde quieres llevar 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 Google Sheets, la aplicaci\u00f3n crear\u00e1 esta hoja. Si quieres enviar informaci\u00f3n a una hoja distinta, solo cambia el nombre de la hoja (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<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- post_edate --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4902726138\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>Ejemplos descargables de Excel a Google Sheets<\/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\/885\/?tmstv=1775308718\" rel=\"nofollow\" id=\"download-link-885\" data-redirect=\"false\" >\n\tdeExcelAGoogleSheets<\/a>\n<\/p>\n<p>Consulta aqu\u00ed el archivo de prueba (Google Sheets): <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1fkJxMHx8uSrP9GL4f-DcFFtr72yN7g1pa9gg3SccFnM\/edit#gid=0\" 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><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enviar datos de excel a google sheets 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 <a href=\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":897,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,113],"tags":[7,11,21],"class_list":["post-883","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-google-sheets-api","tag-excel","tag-google-sheets","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click. - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"C\u00f3mo enviar datos de Excel a Google Sheets usando macros. Descarga el ejemplo listo para usarse con la API de Google Sheets y VBA\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click. - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"C\u00f3mo enviar datos de Excel a Google Sheets usando macros. Descarga el ejemplo listo para usarse con la API de Google Sheets y VBA\" \/>\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\/\" \/>\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-22T06:41:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-04T03:36:22+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=\"3 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\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click.\",\"datePublished\":\"2018-03-22T06:41:01+00:00\",\"dateModified\":\"2023-11-04T03:36:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/\"},\"wordCount\":441,\"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\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg\",\"keywords\":[\"Excel\",\"Google Sheets\",\"VBA\"],\"articleSection\":[\"Excel\",\"Google Sheets API\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/\",\"url\":\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/\",\"name\":\"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click. - 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\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg\",\"datePublished\":\"2018-03-22T06:41:01+00:00\",\"dateModified\":\"2023-11-04T03:36:22+00:00\",\"description\":\"C\u00f3mo enviar datos de Excel a Google Sheets usando macros. Descarga el ejemplo listo para usarse con la API de Google Sheets y VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/#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\/\"]}]},{\"@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\/#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\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fditf.com\/bi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click.\"}]},{\"@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:\/\/www.fditf.com\/bi\/#\/schema\/person\/image\/\",\"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 C\u00f3mo enviar datos de Excel a Google Sheets con un click. - Business Intelligence MX","description":"C\u00f3mo enviar datos de Excel a Google Sheets usando macros. Descarga el ejemplo listo para usarse con la API de Google Sheets y VBA","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\/","og_locale":"en_US","og_type":"article","og_title":"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click. - Business Intelligence MX","og_description":"C\u00f3mo enviar datos de Excel a Google Sheets usando macros. Descarga el ejemplo listo para usarse con la API de Google Sheets y VBA","og_url":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-03-22T06:41:01+00:00","article_modified_time":"2023-11-04T03:36:22+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":"3 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\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click.","datePublished":"2018-03-22T06:41:01+00:00","dateModified":"2023-11-04T03:36:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/"},"wordCount":441,"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\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","keywords":["Excel","Google Sheets","VBA"],"articleSection":["Excel","Google Sheets API"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/","url":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/","name":"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click. - 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\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/03\/meta.jpg","datePublished":"2018-03-22T06:41:01+00:00","dateModified":"2023-11-04T03:36:22+00:00","description":"C\u00f3mo enviar datos de Excel a Google Sheets usando macros. Descarga el ejemplo listo para usarse con la API de Google Sheets y VBA","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/de-excel-a-google-sheets-con-un-click-i-envio-de-datos-googlesheetsapi\/#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\/"]}]},{"@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\/#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\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"\u25b6 C\u00f3mo enviar datos de Excel a Google Sheets con un click."}]},{"@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:\/\/www.fditf.com\/bi\/#\/schema\/person\/image\/","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\/883","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=883"}],"version-history":[{"count":15,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/883\/revisions"}],"predecessor-version":[{"id":4672,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/883\/revisions\/4672"}],"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=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}