<\/p>\n
[\/et_pb_text][et_pb_text admin_label=”Connections T – Automate between spreadsheets – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\"){kind=icon}
<\/p>\n
![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\n
Automate data transfers between spreadsheets Find out how<\/a>[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Please note that this functionality is also available on Google Docs and Google Slides. However, we will focus our discussion within the confines of Google Sheets. We have a spreadsheet that has a sample of sales data as shown in the screenshot below. Since we are seeking contextual help, let us select one of the cells within the data range. Now, let\u2019s click on the\u00a0<\/span>Explore<\/strong>\u00a0<\/span>button at the bottom right corner of the Google Sheets user interface.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-1-Explore-Feature.png” alt=”Explore Google Sheets: Sample Product Details” title_text=”product-details” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n On doing so, we will see a non-intrusive, floating window pane that appears on the right side of the Google Sheets user interface. We\u2019ll notice it comes up with multiple suggestions.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-2-Explore-Feature.png” alt=”Explore Google Sheets: Window Pane to Explore” title_text=”explore-window-pane” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n This is where we ask specific Google Sheets questions in the most human way possible, within the context of the data. It already shows us some of the questions that we might be interested in. We can either choose one of those or type our own. For instance, we tried \u201cWhich Product has the highest Sum of Units\u201d, and here\u2019s what it came up with.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-6-Explore-Feature.png” alt=”Explore Google Sheets: Answers Section” title_text=”explore-answers” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n The result displays a pivot table that lists products in order of their total units, with the highest totals at the top. Therefore, it is clear that Product A has sold the highest number of units.<\/p>\n As we can see, it offers us multiple options for \u201calternating colors\u201d. Although we chose just a single data cell, it automatically recognized the entire data range. Therefore, if we select one of the suggested options, the formatting will be applied to the entire data range.<\/p>\n <\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-3-Explore-Feature.png” alt=”Explore Google Sheets: Formatting Section” title_text=”formatting-section” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Scrolling further down, we see a suggestion for a pivot table. However, if that is not what we are looking for, we can click on the\u00a0<\/span>MORE<\/strong>\u00a0<\/span>hyperlink within this section to see other options. Let\u2019s say we liked a suggestion and want that pivot table. All we have to do is click\u00a0the\u00a0Insert Pivot Table<\/strong> button corresponding to the suggested pivot table<\/span>. Doing that will insert a pivot table in a brand new worksheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-4-Explore-Feature.webp” alt=”Explore Google Sheets: Pivot Table Section” title_text=”pivot-table-section” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n It is possible that we may not see what we are looking for. In such scenarios, insert a pivot table that closely resembles what we are looking for. Insert that table, and then proceed to make changes to it.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Depending on the nature of the data, the Explore feature automatically suggests the most suitable charts to use. Scrolling further down to the\u00a0<\/span>ANALYSIS<\/strong> section reveals the charting suggestions it generated<\/span>. As we did in the PIVOT TABLE section, we can click on the MORE hyperlink if we don\u2019t see the chart we like. Once the chart is selected, click the Insert Chart button corresponding to the chart you want to insert. Again, should we need to edit the chart that we chose, we can easily do so.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-5-Explore-Feature.png” alt=”Explore Google Sheets: The Analysis Section” title_text=”analysis-section” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n The Explore Google Sheets feature will display suggestions that it deems relevant to the spreadsheet’s context. Needless to say, the suggestions can vary depending on the composition of the underlying data set.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”] Automate data transfers beyond Importrange<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Most of us work with loads of data on our spreadsheets. Wouldn\u2019t it be nice to have an assistant that can help intuitively help us with our work, so that we can speed it up? The Explore feature in Google Sheets does exactly that. It intelligently gathers the context that we are working upon, and […]<\/p>\n","protected":false},"author":40,"featured_media":9679,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":" Most of us work with loads of data on our spreadsheets. Wouldn't it be nice to have an assistant that can help intuitively help us with our work, so that we can speed it up? The Explore feature in Google Sheets does exactly that. It intelligently gathers the context that we are working upon, and gives us the right suggestions that might be suitable for the purpose. And its insightful suggestions include tips for formatting, charting, pivot tables etc. If we can't find something, we can even ask for answers. No, it isn't anything like the annoying MS Office Clippy<\/a>, but rather an extremely intelligent yet reliable assistant.<\/p> Please note that this functionality is also available on Google Docs and Google Slides. However, we will focus our discussion within the confines of Google Sheets. We have a spreadsheet that has a sample sales data as shown in the screenshot below. Since we are seeking contextual help, let us select one of the cells within the data range. Now let's click on the Explore<\/strong> button at the bottom right corner of the Google Sheets user interface.<\/p> On doing so, we will see a non-intrusive, floating window pane that appears on the right side of the Google Sheets user interface. We'll notice it comes up with multiple suggestions.<\/p> This is where we ask specific Google Sheets questions in the most human way possible, pertaining to the data context that is. It already shows us some of the questions that we might be interested in. Either we can choose one of that, or type our own. For instance, we tried \"Which Product has the highest Sum of Units\", and here's what it came up with.<\/p> The result shows a pivot table, that has the list of products sorted in a way that the products with higher sum of units is at the top. So, it is very easy to see Product A has the highest number of Units sold.<\/p> As we can see, it offers us multiple options for \"alternating colors\". Although we chose just a single data cell, it automatically recognized the entire data range. So, if we choose one of the suggested options, the formatting will apply to the entire data range.<\/p> Scrolling further down, we see a suggestion for a pivot table. However, if that is not we are looking for, we can click on the MORE<\/strong> hyperlink within this section to see other options. Let's just say we liked a suggestion, and want that pivot table. All we have to do is click on the Insert Pivot Table<\/strong> button corresponding to the pivot table suggestion. Doing that will insert a pivot table in a brand new worksheet.<\/p> It might so happen that we may not still see what we are looking for. In such scenarios, just insert a pivot table that closely resembles what we are looking for. Insert that table, and then go on to make changes to that table.<\/p> Depending upon the nature of data, the Explore feature automatically comes up with the most probable charts we would want to use. Scrolling further down to the ANALYSIS<\/strong> section reveals the charting suggestions it came up with.\u00a0Like we did in the PIVOT TABLE section, we can click on the MORE hyperlink if we don't see the chart of our liking. Once decided with the chart, just click on the Insert Chart button corresponding to the chart we want to insert.\u00a0Again, should we need to edit the chart that we chose, we can easily do so.<\/p> The Explore will bring up the suggestions that it deems fit to the context of the spreadsheet. Needless to say, the suggestions can vary depending upon the composition of the underlying data set.<\/p> Featured Image by\u00a0Anastasia Petrova<\/a>\u00a0on\u00a0Unsplash<\/a><\/p>","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-9668","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\/fr\/wp-json\/wp\/v2\/posts\/9668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=9668"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/9668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/9679"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=9668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=9668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=9668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/span><\/p>\nExplore Google Sheets<\/h2>\n
The ANSWERS section<\/h3>\n
The\u00a0FORMATTING section<\/h3>\n
The PIVOT TABLE section<\/h3>\n
The ANALYSIS (Charts) section<\/h3>\n
Note<\/h2>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\")
<\/p>\n<\/p>\nThe Explore feature<\/h3>
![\"Illustration](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-1-Explore-Feature.png\")
<\/p>![\"Illustration](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-2-Explore-Feature.png\")
<\/p>The ANSWERS section<\/h4>
![\"Illustration](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-6-Explore-Feature.png\")
<\/p>The\u00a0FORMATTING section<\/h4>
![\"Illustration](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-3-Explore-Feature.png\")
<\/p>The PIVOT TABLE section<\/h4>
![\"Illustration](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-4-Explore-Feature.png\")
<\/p>The ANALYSIS (Charts) section<\/h4>
![\"Illustration](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Illustration-5-Explore-Feature.png\")
<\/p>Note<\/h3>