{"id":7552,"date":"2017-10-24T17:19:51","date_gmt":"2017-10-24T15:19:51","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=5996"},"modified":"2017-10-24T17:19:51","modified_gmt":"2017-10-24T15:19:51","slug":"como-exportar-automaticamente-o-google-sheets-para-outros-formatos","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/how-to-automatically-export-google-sheets-to-other-formats\/","title":{"rendered":"Como exportar automaticamente o Planilhas Google para outros formatos"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.22.2″ custom_padding=”54px|0px|2px|0px||” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Google Sheets<\/a>\u00a0<\/span>is a cloud-based device independent application, that works on all current web browsers. And its flexibility and compatibility don\u2019t end there. It can also read and write in multiple spreadsheet formats, making it\u00a0<\/span>the one<\/g>\u00a0<\/span>of the most versatile spreadsheets application of today. This article explains the process to automatically export Google Sheets to other formats.<\/p>\n

The usual suspects<\/h4>\n

The existing functions that usually comes to mind are\u00a0<\/span>Share<\/strong>\u00a0<\/span>and\u00a0<\/span>Download as<\/strong>. While they are fantastic features in themselves, they come with inherent problems.<\/p>\n

With\u00a0<\/span>Share<\/strong>, the other users who have access to the spreadsheet will only be able to access the file using Google Sheets application. They do not have it readily available for their own spreadsheet applications like Open Office or Microsoft Excel.<\/p>\n

Download as<\/strong>\u00a0<\/span>overcomes the limitations of\u00a0<\/span>Share<\/strong>\u00a0<\/span>to some extent. With this we can share the file in multiple formats such as .xlsx, .ods, .pdf, .html, .csv or .tsv. But again, there\u2019s a caveat. The files we download and send over to others, will not remain current. What if we changed the Google Sheets spreadsheet after we download it in one of the formats? There\u2019s no way these changes are going to reflect in the downloaded files.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Solution: Use \u2018Publish to web\u2019 functionality\u00a0to automatically export Google Sheets to other formats<\/h4>\n

Google Sheets has an excellent inbuilt utility called\u00a0<\/span>Publish to the web<\/strong>. By using this, not only can we derive the benefits of\u00a0<\/span>Share<\/strong>\u00a0<\/span>and\u00a0<\/span>Download as<\/strong>, but also the limitations discussed above can be handled. To access this, navigate to\u00a0File<\/strong>\u00a0>\u00a0Publish to the web\u2026<\/strong>\u00a0option.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Publish-Google-Sheets-to-the-web.jpg” align=”center” _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Once we invoke this functionality, we see the pop-up window that gives us options to link or embed. Publishing through the link enables us to share a URL which the end users can download the file from. The format they get to download is the one we choose from any of the following options.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Publish-to-the-web-2.jpg” align=”center” _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

For a quick demonstration, let us choose the Web page<\/strong>\u00a0format, and click the\u00a0<\/span>Publish <\/g><\/strong>button. Google Sheets will provide us with a link that we can share with other users.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Web-page-published-Google-Sheets.jpeg” align=”center” _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

When they navigate to that URL, they will see a web page, separately built out of the spreadsheet data we were working on.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Published-Google-Sheets-example.jpeg” align=”center” _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

When we choose one of the other formats (i.e. .csv, .tsv, .pdf, .xlsx, .ods) for publishing, and the user accesses the URL, they will download the corresponding file to their computer automatically.<\/p>\n

If instead of just sharing the link, we want to embed this document or part of it, in another web page, Google Sheets lets us do this! Please see the snapshot below. All we need to do is copy the code and embed it\u00a0<\/span>in<\/g>\u00a0<\/span>our web page(s)!<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Embed-Google-Sheets-to-web-pages.jpeg” align=”center” _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

\n
\n

If at any point in time, we wish to stop publishing, we can do so using the\u00a0<\/span>Stop publishing<\/strong>\u00a0<\/span>button at the bottom of the Publish to the web<\/strong>\u00a0window pane.<\/p>\n

One of the best things about this functionality is that the content remains\u00a0current (not older than 5 minutes). Irrespective of the day and time the link (or embedded code) is accessed on!<\/p>\n

Congratulations! We just explored the process\u00a0to automatically export Google Sheets to other formats, using the \u2018Publish to web\u2019 functionality.<\/p>\n<\/div>\n<\/div>\n

\n
\n

For the other way around, to automatically import CSV or Excel files to Google Sheets, check the following blog posts: How to Automatically Import CSV data to Google Sheets<\/a>\u00a0and Import Filtered Data from Excel to Google Sheets<\/a>.<\/p>\n<\/div>\n<\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

Google Sheets\u00a0is a cloud-based device independent application, that works on all current web browsers. And its flexibility and compatibility don\u2019t end there. It can also read and write in multiple spreadsheet formats, making it\u00a0the one\u00a0of the most versatile spreadsheets application of today. This article explains the process to automatically export Google Sheets to other formats. […]<\/p>\n","protected":false},"author":40,"featured_media":6002,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sheets is a cloud-based device independent application, that works on all current web browsers. And its flexibility and compatibility don't end there. It can also read and write in multiple spreadsheet formats, making it the one of the most versatile spreadsheets application of today. This article explains the process to automatically export Google Sheets to other formats.\n

The usual suspects<\/h3>\nThe existing functions that usually comes to mind are Share<\/strong> and Download as<\/strong>. While they are fantastic features in themselves, they come with inherent problems.\n\nWith Share<\/strong>, the other users who have access to the spreadsheet will only be able to access the file using Google Sheets application. They do not have it readily available for their own spreadsheet applications like Open Office or Microsoft Excel.\n\nDownload as<\/strong> overcomes the limitations of Share<\/strong> to some extent. With this we can share the file in multiple formats such as .xlsx, .ods, .pdf, .html, .csv or .tsv. But again, there's a caveat. The files we download and send over to others, will not remain current. What if we changed the Google Sheets spreadsheet after we download it in one of the formats? There's no way these changes are going to reflect in the downloaded files.\n

Solution: Use 'Publish to web' functionality\u00a0to automatically export Google Sheets to other formats<\/h3>\nGoogle Sheets has an excellent inbuilt utility called Publish to the web<\/strong>. By using this, not only can we derive the benefits of Share<\/strong> and Download as<\/strong>, but also the limitations discussed above can be handled. To access this, navigate to\u00a0File<\/strong>\u00a0>\u00a0Publish to the web\u2026<\/strong>\u00a0option.\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\nOnce we invoke this functionality, we see the pop-up window that gives us options to link or embed. Publishing through the link enables us to share a URL which the end users can download the file from. The format they get to download is the one we choose from any of the following options.\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\nFor a quick demonstration, let us choose the \"Web page<\/strong>\" format, and click Publish<\/strong> button. Google Sheets will provide us with a link that we can share with other users.\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\nWhen they navigate to that URL, they will see a web page, separately built out of the spreadsheet data we were working on.\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\nWhen we choose one of the other formats (i.e. .csv, .tsv, .pdf, .xlsx, .ods) for publishing, and the user accesses the URL, they will download the corresponding file to their computer automatically.\n\nIf instead of just sharing the link, we want to embed this document or part of it, in another web page, Google Sheets lets us do this! Please see the snapshot below. All we need to do is copy the code and embed it in our web page(s)!\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\nIf at any point in time, we wish to stop publishing, we can do so using the Stop publishing<\/strong> button at the bottom of the 'Publish to the web<\/strong>' window pane.\n\nOne of the best things about this functionality is that the content remains\u00a0current (not older than 5 minutes). Irrespective of the day and time the link (or embedded code) is accessed on!\n\nCongratulations! We just explored the process\u00a0to automatically export Google Sheets to other formats, using the 'Publish to web' functionality!","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7552","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=7552"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7552\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/6002"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=7552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=7552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=7552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}