This can take up hours of your time. So what\u2019s a more efficient way?<\/p>\n
You can automatically import specific columns into Google Sheets using the Filter feature in Sheetgo\u2019s web app.<\/p>\n
This is a great tool to use within business operations where you\u2019re dealing with vast amounts of data that you want to filter and transfer to other files. For example, let\u2019s say you have a spreadsheet full of all the sales records in the latest quarter. Not only are there hundreds of rows of data but also numerous columns.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#d3e3ff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44972″ theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” header_font_size=”33px” header_4_font_size=”24px” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Ready to streamline<\/span> your data?<\/h4>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns.png” alt=”import specific columns 0″ title_text=”Import columns” align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]You may want to only extract certain columns in order to focus on a specific field of analysis. For example, you may want to extract only the location data in order to gain more specific insights into which products are more popular and where in the last 4 months, for geography-based marketing purposes.<\/p>\n
In this article, we will explore how the filter function works in Sheetgo, and how you can use its features to import specific columns of data to Google Sheets![\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
How to import specific columns to Google Sheets<\/h2>\n
The Sheetgo web app has different types of filter features depending on how much you want to filter your data. Let\u2019s go through the steps on how to import entire columns, and how to import more specific data within columns, all within the Sheetgo web app.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
How to import entire columns to Google Sheets – Query feature<\/h3>\n
Using the example mentioned at the beginning of the post, let\u2019s import columns C, I J & K from our Sales records<\/i> sheet into a new Google Sheets file.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nStep 1: Install Sheetgo<\/h4>\n
Open the Sheetgo web application by clicking the button below. Sign up with your Google, Microsoft, or Dropbox account.[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SING UP FOR FREE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” global_module=”44753″ theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Step 2: Create workflow<\/h4>\n
In the Sheetgo web app, click Create a new workflow<\/b> to begin your project (make sure you label this project clearly). Add your spreadsheet full of data into the Source file section and select the tab where your data is located.<\/p>\n
Once finished, press Continue<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-4.jpg” alt=”import specific columns 1″ title_text=”Import columns \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nStep 3: Filter your data<\/h4>\n
Next, Sheetgo will ask you to choose a next step. Under the Process<\/b> section, select Filter<\/b>.<\/p>\n
Now, select the Query<\/b> feature. This is the easiest function to use to filter our data by entire columns.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-5.jpg” alt=”import specific columns 2″ title_text=”Import columns \u2013 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nStep 4: Use the Query editor<\/h4>\n
As you can already see, Sheetgo has made this process easier by already starting your query.<\/p>\n
Simply click on the columns that you want to filter. Once completed, press Continue<\/b>.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44981″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nConnect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-6.jpg” alt=”import specific columns 10″ title_text=”Import columns \u2013 6″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Step 5: Select destination file<\/h4>\n
It\u2019s time to import your columns to your new sheet. Under the Send to<\/b> section, choose whether to import your data into a single spreadsheet or multiple files. Then, customize your file settings to your needs.<\/p>\n
In this example, let\u2019s create a new file in Google Sheets for our columns. Once finished, press Finish and save<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-7.jpg” alt=”import specific columns 4″ title_text=”Import columns \u2013 7″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nStep 6: View filtered data<\/h4>\n
You\u2019ve successfully imported your specific columns to Google Sheets. Your new file should now show these chosen columns.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-8.jpg” alt=”import specific columns 5″ title_text=”Import columns \u2013 8″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
How to import specific data within columns to Google Sheets – Condition feature<\/h3>\n
Let\u2019s say you want to import data relating to a specific product within our spreadsheet. In this case, you would use the Condition<\/b> feature.<\/p>\n
Depending on how many aspects you want to filter, you can use either the single condition or the multiple condition.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44982″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect<\/span> your spreadsheets to your data sources<\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
\n\n
- Single condition (OR)<\/li>\n<\/h4>\n
Let\u2019s say you want to filter our data relating to only Product 3. Simply follow the steps listed above, but this time, select the Condition<\/b> feature. Then click the Simple condition (OR)<\/b> option.<\/p>\n
Now filter your data by selecting the product column (column C), choose the criteria Text is exactly<\/b>, and write the name of the product (Product 3).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-9.jpg” alt=”import specific columns 6″ title_text=”Import columns \u2013 9″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]Once the process is finished, the specific data will be filtered and imported to a new sheet, like this:[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-10.jpg” alt=”import specific columns 7″ title_text=”Import columns \u2013 10″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n\n\n
- Multiple condition (AND)<\/li>\n<\/h4>\n
Suppose that you want to filter this data more, specifically importing data relating to Product 3 that was also purchased in Indonesia.<\/p>\n
This time, choose the Multiple condition (AND)<\/b> option. First, filter your data by selecting the product column (column C), choose the criteria Text is exactly<\/b>, and write the name of the product (Product 3).<\/p>\n
Then, press Add condition<\/b>. To filter our location, select the city column (Column K), choose Text is exactly<\/b>, and enter your location (Indonesia).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-11.png” alt=”import specific columns 8″ title_text=”Import columns \u2013 11″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]As a result, Sheetgo will filter your data to only show the data relating to Product 3 that was purchased in Indonesia.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44981″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nConnect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-12.jpg” alt=”import specific columns 9″ title_text=”Import columns \u2013 12″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
The Filter feature in Sheetgo<\/h3>\n
In the steps above, we have covered two of the filter features within the Sheetgo web app. There are 3 different filter features within Sheetgo, each designed to manage specific types of data or to fulfill different objectives.<\/p>\n
For a better understanding of each filter feature and when to use them, let\u2019s explore each in more detail and what they can do.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
1. Filter by Query<\/h4>\n
Sheetgo\u2019s Filter by Query feature uses query syntax similar to SQL that acts as an instruction for your spreadsheets.<\/p>\n
With a simple SELECT* query, you can filter down specific columns to import into your spreadsheet.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-1.jpg” alt=”import specific columns 3″ title_text=”Import columns \u2013 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
2. Filter by condition<\/h4>\n
The Filter by condition feature in Sheetgo allows you to filter your spreadsheet data in more detail.<\/p>\n
You can choose to filter by a single condition (OR), or multiple conditions (AND), the latter allowing you to filter your data with multiple requisites.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
\n- Single condition (OR)<\/b> – filter a column of data with a single condition. The data in the column either fulfills the condition or doesn\u2019t. Those that do will be imported to your spreadsheet.<\/li>\n
- Multiple condition (AND)<\/b> – filter a column of data with multiple conditions. The data in the column must fulfill all<\/b> of these conditions in order to be imported to your spreadsheet.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-2.jpg” alt=”import specific columns 11″ title_text=”Import columns \u2013 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
3. Filter by color<\/h4>\n
The Filter by color feature allows you to filter a column whose data is categorized using cell colors. You can choose to import a specific cell color into your spreadsheets.<\/p>\n
For example, we could filter our stock level<\/i> column by only importing the data with the green cell color (denoting \u2018high\u2019 stock levels).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-3.png” alt=”import specific columns 12″ title_text=”Import columns \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nFilter specific columns in Google Sheets<\/h3>\n
And there you have it! Sheetgo\u2019s filter feature has multiple functions that can automatically import specific columns or specific data within columns to Google Sheets in just a few clicks.<\/p>\n
If you would like to learn more about the cell color filter function, take a look at our article on How to filter by color in Google Sheets<\/a>.<\/p>\nYou can also discover more posts on how to solve with Sheetgo below![\/et_pb_text][et_pb_text _builder_version=”4.4.8″ background_color=”#f9f9ff” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44987″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Managing large amounts of data becomes a lot easier when using great spreadsheet tools, such as Google Sheets. Although Google Sheets has many features that help us to manage and analyze our data, there still isn\u2019t a feature to select or filter specific columns to import to another spreadsheet. Currently, the only way to import […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Evan is an analyst in the sales department of his company. One of the tasks he has to do as part his job is to analyze how each product is performing across regions.\u00a0Every day he receives previous day's sales information as shown in the snapshot below. However, for this task, he doesn't need the entire data. So he will have to pick what is required for the purpose. In other words, import specific columns as needed. For this use case, we are going to import columns B, F, G and H.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importspecific1.png\")
\n\n[\/panel]<\/span>\n\nHe may choose to import the entire data set and remove unnecessary columns. But, what if the data set is huge (let's say there are about 50 columns), and the information we need is spread across? Add to that, he is to do this every day. It is definitely not what Evan would like to do repeatedly, especially if there is an automated solution to get this done.<\/span>\nUser-friendly solution: Automate with Sheetgo add-on<\/h3>\nAssuming that Evan has the Sales Information file on his Google Drive with read access, we will now try and configure the automation to import specific columns as required.<\/span>\n1. Start\u00a0Sheetgo and initiate an import link connection<\/h4>\n\n \t- Open the file that we want the data to import to.<\/span><\/li>\n \t
- If the Sheetgo add-on isn\u2019t installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application.\u00a0[panel type=\"default\"][ccj id=\"Install Widget\"]
![]()
[\/panel]<\/span><\/li>\n \t- Once we have it installed, navigate to Add-ons > Sheetgo > Start<\/strong>.\u00a0<\/span><\/li>\n \t
- Doing so will open the Sheetgo interface on the screen as a sidebar, as shown in the image below. Hover the mouse pointer over the green circle with a plus, and click on the Import<\/strong> option.\u00a0[panel type=\"default\"]Example<\/strong><\/span>\n
![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importspecific2.png\")
[\/panel]<\/li>\n<\/ul>\n2. Link source sheet with the destination file that we need to import the data from<\/h4>\nClicking the 'Connect' option leads us to the list of most recently updated files by default. If we don't see the file we want, we can use the search module to lookup a file within the Google Drive. For this example, we select \"Sales Information\" file for 'destination spreadsheet', and then for 'source sheet' choose \"Sheet1\".<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importspecific3.png\")
\n\n[\/panel]<\/span>\n\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \"Automatic update<\/strong>\" section. We leave it to the default option,\u00a0'Daily', because Evan, receives the updated 'Sales Information' file every day.<\/span>\n3. Add the filter condition for selective data import, and create a connection<\/h4>\nTo do this, we may have to scroll down a bit on the sidebar until we see \"Filter by<\/strong>\" section. By default, it shows \"No active filter\". Click on 'edit<\/strong>' to add a condition. Choose 'Query Language<\/strong>' option, and key in the following statement.<\/span>\n\n[panel type=\"default\"]SELECT B, F, G, H<\/strong>[\/panel]<\/span>\n\nThe\u00a0\"Filter by\" section now shows \"SELECT B, F, G, H\". Finally, to establish the link that can\u00a0automatically export filtered data, we click \"CONNECT<\/strong>\" button.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importspecific4.png\")
\n\n[\/panel]<\/span>\n\nDoing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \"Last update: Just now\".<\/span>\n\nCongratulations! We did import specific columns from the 'Sales Information' file! Let's check the \"Sales Analysis\" file to see if the data has flown in.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importspecific5.png\")
\n\n[\/panel]<\/span>\n\nSure enough, it has, and rightly so! We see that Sheetgo creates a new sheet (name will be same as that of the connection), and accordingly pulls only B, F, G and H column data from 'Sales Information' file.<\/span>\n\nThe data import keeps happening automatically and periodically\u00a0once the appropriate connection is in place.\u00a0Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.<\/span>\n\nConnection name\u00a0<\/strong>(in this case \u201cSG_Sheet1\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update > edit<\/strong>.<\/span>\n\nClick on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.<\/span>\nAdvanced solution: Use composite Google Sheets formulas to import specific columns<\/h3>\nSeasoned Google Sheets users may comfortable using a combination of two built-in formulas, QUERY<\/a> and IMPORTRANGE<\/a>. To import specific columns into the destination sheet, we need to key in the following formula:<\/span>\n=QUERY(IMPORTRANGE(url,\"A:E\"), \"SELECT B, F, G, H\")<\/strong><\/span><\/pre>\nFor further reference on this approach, you may want to go through this excellent Stack Exchange<\/a>\u00a0discussion.<\/span>\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-2607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2607","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=2607"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2607\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Step 1: Install Sheetgo<\/h4>\n
Step 3: Filter your data<\/h4>\n
Step 4: Use the Query editor<\/h4>\n
Connect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-6.jpg” alt=”import specific columns 10″ title_text=”Import columns \u2013 6″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Step 5: Select destination file<\/h4>\n
It\u2019s time to import your columns to your new sheet. Under the Send to<\/b> section, choose whether to import your data into a single spreadsheet or multiple files. Then, customize your file settings to your needs.<\/p>\n
In this example, let\u2019s create a new file in Google Sheets for our columns. Once finished, press Finish and save<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-7.jpg” alt=”import specific columns 4″ title_text=”Import columns \u2013 7″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nStep 6: View filtered data<\/h4>\n
You\u2019ve successfully imported your specific columns to Google Sheets. Your new file should now show these chosen columns.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-8.jpg” alt=”import specific columns 5″ title_text=”Import columns \u2013 8″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
How to import specific data within columns to Google Sheets – Condition feature<\/h3>\n
Let\u2019s say you want to import data relating to a specific product within our spreadsheet. In this case, you would use the Condition<\/b> feature.<\/p>\n
Depending on how many aspects you want to filter, you can use either the single condition or the multiple condition.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44982″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect<\/span> your spreadsheets to your data sources<\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
\n\n
- Single condition (OR)<\/li>\n<\/h4>\n
Let\u2019s say you want to filter our data relating to only Product 3. Simply follow the steps listed above, but this time, select the Condition<\/b> feature. Then click the Simple condition (OR)<\/b> option.<\/p>\n
Now filter your data by selecting the product column (column C), choose the criteria Text is exactly<\/b>, and write the name of the product (Product 3).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-9.jpg” alt=”import specific columns 6″ title_text=”Import columns \u2013 9″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]Once the process is finished, the specific data will be filtered and imported to a new sheet, like this:[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-10.jpg” alt=”import specific columns 7″ title_text=”Import columns \u2013 10″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n\n\n
- Multiple condition (AND)<\/li>\n<\/h4>\n
Suppose that you want to filter this data more, specifically importing data relating to Product 3 that was also purchased in Indonesia.<\/p>\n
This time, choose the Multiple condition (AND)<\/b> option. First, filter your data by selecting the product column (column C), choose the criteria Text is exactly<\/b>, and write the name of the product (Product 3).<\/p>\n
Then, press Add condition<\/b>. To filter our location, select the city column (Column K), choose Text is exactly<\/b>, and enter your location (Indonesia).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-11.png” alt=”import specific columns 8″ title_text=”Import columns \u2013 11″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]As a result, Sheetgo will filter your data to only show the data relating to Product 3 that was purchased in Indonesia.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44981″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nConnect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-12.jpg” alt=”import specific columns 9″ title_text=”Import columns \u2013 12″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
The Filter feature in Sheetgo<\/h3>\n
In the steps above, we have covered two of the filter features within the Sheetgo web app. There are 3 different filter features within Sheetgo, each designed to manage specific types of data or to fulfill different objectives.<\/p>\n
For a better understanding of each filter feature and when to use them, let\u2019s explore each in more detail and what they can do.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
1. Filter by Query<\/h4>\n
Sheetgo\u2019s Filter by Query feature uses query syntax similar to SQL that acts as an instruction for your spreadsheets.<\/p>\n
With a simple SELECT* query, you can filter down specific columns to import into your spreadsheet.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-1.jpg” alt=”import specific columns 3″ title_text=”Import columns \u2013 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
2. Filter by condition<\/h4>\n
The Filter by condition feature in Sheetgo allows you to filter your spreadsheet data in more detail.<\/p>\n
You can choose to filter by a single condition (OR), or multiple conditions (AND), the latter allowing you to filter your data with multiple requisites.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
\n- Single condition (OR)<\/b> – filter a column of data with a single condition. The data in the column either fulfills the condition or doesn\u2019t. Those that do will be imported to your spreadsheet.<\/li>\n
- Multiple condition (AND)<\/b> – filter a column of data with multiple conditions. The data in the column must fulfill all<\/b> of these conditions in order to be imported to your spreadsheet.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-2.jpg” alt=”import specific columns 11″ title_text=”Import columns \u2013 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
3. Filter by color<\/h4>\n
The Filter by color feature allows you to filter a column whose data is categorized using cell colors. You can choose to import a specific cell color into your spreadsheets.<\/p>\n
For example, we could filter our stock level<\/i> column by only importing the data with the green cell color (denoting \u2018high\u2019 stock levels).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-3.png” alt=”import specific columns 12″ title_text=”Import columns \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\nFilter specific columns in Google Sheets<\/h3>\n
And there you have it! Sheetgo\u2019s filter feature has multiple functions that can automatically import specific columns or specific data within columns to Google Sheets in just a few clicks.<\/p>\n
If you would like to learn more about the cell color filter function, take a look at our article on How to filter by color in Google Sheets<\/a>.<\/p>\nYou can also discover more posts on how to solve with Sheetgo below![\/et_pb_text][et_pb_text _builder_version=”4.4.8″ background_color=”#f9f9ff” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44987″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Managing large amounts of data becomes a lot easier when using great spreadsheet tools, such as Google Sheets. Although Google Sheets has many features that help us to manage and analyze our data, there still isn\u2019t a feature to select or filter specific columns to import to another spreadsheet. Currently, the only way to import […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Evan is an analyst in the sales department of his company. One of the tasks he has to do as part his job is to analyze how each product is performing across regions.\u00a0Every day he receives previous day's sales information as shown in the snapshot below. However, for this task, he doesn't need the entire data. So he will have to pick what is required for the purpose. In other words, import specific columns as needed. For this use case, we are going to import columns B, F, G and H.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n\n\n[\/panel]<\/span>\n\nHe may choose to import the entire data set and remove unnecessary columns. But, what if the data set is huge (let's say there are about 50 columns), and the information we need is spread across? Add to that, he is to do this every day. It is definitely not what Evan would like to do repeatedly, especially if there is an automated solution to get this done.<\/span>\nUser-friendly solution: Automate with Sheetgo add-on<\/h3>\nAssuming that Evan has the Sales Information file on his Google Drive with read access, we will now try and configure the automation to import specific columns as required.<\/span>\n1. Start\u00a0Sheetgo and initiate an import link connection<\/h4>\n\n \t- Open the file that we want the data to import to.<\/span><\/li>\n \t
- If the Sheetgo add-on isn\u2019t installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application.\u00a0[panel type=\"default\"][ccj id=\"Install Widget\"]
![]()
[\/panel]<\/span><\/li>\n \t- Once we have it installed, navigate to Add-ons > Sheetgo > Start<\/strong>.\u00a0<\/span><\/li>\n \t
- Doing so will open the Sheetgo interface on the screen as a sidebar, as shown in the image below. Hover the mouse pointer over the green circle with a plus, and click on the Import<\/strong> option.\u00a0[panel type=\"default\"]Example<\/strong><\/span>\n[\/panel]<\/li>\n<\/ul>\n
2. Link source sheet with the destination file that we need to import the data from<\/h4>\nClicking the 'Connect' option leads us to the list of most recently updated files by default. If we don't see the file we want, we can use the search module to lookup a file within the Google Drive. For this example, we select \"Sales Information\" file for 'destination spreadsheet', and then for 'source sheet' choose \"Sheet1\".<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n\n\n[\/panel]<\/span>\n\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \"Automatic update<\/strong>\" section. We leave it to the default option,\u00a0'Daily', because Evan, receives the updated 'Sales Information' file every day.<\/span>\n3. Add the filter condition for selective data import, and create a connection<\/h4>\nTo do this, we may have to scroll down a bit on the sidebar until we see \"Filter by<\/strong>\" section. By default, it shows \"No active filter\". Click on 'edit<\/strong>' to add a condition. Choose 'Query Language<\/strong>' option, and key in the following statement.<\/span>\n\n[panel type=\"default\"]SELECT B, F, G, H<\/strong>[\/panel]<\/span>\n\nThe\u00a0\"Filter by\" section now shows \"SELECT B, F, G, H\". Finally, to establish the link that can\u00a0automatically export filtered data, we click \"CONNECT<\/strong>\" button.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n\n\n[\/panel]<\/span>\n\nDoing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \"Last update: Just now\".<\/span>\n\nCongratulations! We did import specific columns from the 'Sales Information' file! Let's check the \"Sales Analysis\" file to see if the data has flown in.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n\n\n[\/panel]<\/span>\n\nSure enough, it has, and rightly so! We see that Sheetgo creates a new sheet (name will be same as that of the connection), and accordingly pulls only B, F, G and H column data from 'Sales Information' file.<\/span>\n\nThe data import keeps happening automatically and periodically\u00a0once the appropriate connection is in place.\u00a0Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.<\/span>\n\nConnection name\u00a0<\/strong>(in this case \u201cSG_Sheet1\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update > edit<\/strong>.<\/span>\n\nClick on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.<\/span>\nAdvanced solution: Use composite Google Sheets formulas to import specific columns<\/h3>\nSeasoned Google Sheets users may comfortable using a combination of two built-in formulas, QUERY<\/a> and IMPORTRANGE<\/a>. To import specific columns into the destination sheet, we need to key in the following formula:<\/span>\n=QUERY(IMPORTRANGE(url,\"A:E\"), \"SELECT B, F, G, H\")<\/strong><\/span><\/pre>\nFor further reference on this approach, you may want to go through this excellent Stack Exchange<\/a>\u00a0discussion.<\/span>\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-2607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2607","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=2607"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2607\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Step 6: View filtered data<\/h4>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
- \n
- Single condition (OR)<\/li>\n<\/h4>\n
Let\u2019s say you want to filter our data relating to only Product 3. Simply follow the steps listed above, but this time, select the Condition<\/b> feature. Then click the Simple condition (OR)<\/b> option.<\/p>\n
Now filter your data by selecting the product column (column C), choose the criteria Text is exactly<\/b>, and write the name of the product (Product 3).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-9.jpg” alt=”import specific columns 6″ title_text=”Import columns \u2013 9″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]Once the process is finished, the specific data will be filtered and imported to a new sheet, like this:[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-10.jpg” alt=”import specific columns 7″ title_text=”Import columns \u2013 10″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
- \n
- Multiple condition (AND)<\/li>\n<\/h4>\n
Suppose that you want to filter this data more, specifically importing data relating to Product 3 that was also purchased in Indonesia.<\/p>\n
This time, choose the Multiple condition (AND)<\/b> option. First, filter your data by selecting the product column (column C), choose the criteria Text is exactly<\/b>, and write the name of the product (Product 3).<\/p>\n
Then, press Add condition<\/b>. To filter our location, select the city column (Column K), choose Text is exactly<\/b>, and enter your location (Indonesia).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-11.png” alt=”import specific columns 8″ title_text=”Import columns \u2013 11″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]As a result, Sheetgo will filter your data to only show the data relating to Product 3 that was purchased in Indonesia.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44981″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ custom_padding=”27px|0px|27px|0|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-12.jpg” alt=”import specific columns 9″ title_text=”Import columns \u2013 12″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
The Filter feature in Sheetgo<\/h3>\n
In the steps above, we have covered two of the filter features within the Sheetgo web app. There are 3 different filter features within Sheetgo, each designed to manage specific types of data or to fulfill different objectives.<\/p>\n
For a better understanding of each filter feature and when to use them, let\u2019s explore each in more detail and what they can do.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
1. Filter by Query<\/h4>\n
Sheetgo\u2019s Filter by Query feature uses query syntax similar to SQL that acts as an instruction for your spreadsheets.<\/p>\n
With a simple SELECT* query, you can filter down specific columns to import into your spreadsheet.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-1.jpg” alt=”import specific columns 3″ title_text=”Import columns \u2013 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
2. Filter by condition<\/h4>\n
The Filter by condition feature in Sheetgo allows you to filter your spreadsheet data in more detail.<\/p>\n
You can choose to filter by a single condition (OR), or multiple conditions (AND), the latter allowing you to filter your data with multiple requisites.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
- \n
- Single condition (OR)<\/b> – filter a column of data with a single condition. The data in the column either fulfills the condition or doesn\u2019t. Those that do will be imported to your spreadsheet.<\/li>\n
- Multiple condition (AND)<\/b> – filter a column of data with multiple conditions. The data in the column must fulfill all<\/b> of these conditions in order to be imported to your spreadsheet.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-2.jpg” alt=”import specific columns 11″ title_text=”Import columns \u2013 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
3. Filter by color<\/h4>\n
The Filter by color feature allows you to filter a column whose data is categorized using cell colors. You can choose to import a specific cell color into your spreadsheets.<\/p>\n
For example, we could filter our stock level<\/i> column by only importing the data with the green cell color (denoting \u2018high\u2019 stock levels).[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Import-columns-\u2013-3.png” alt=”import specific columns 12″ title_text=”Import columns \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Filter specific columns in Google Sheets<\/h3>\n
And there you have it! Sheetgo\u2019s filter feature has multiple functions that can automatically import specific columns or specific data within columns to Google Sheets in just a few clicks.<\/p>\n
If you would like to learn more about the cell color filter function, take a look at our article on How to filter by color in Google Sheets<\/a>.<\/p>\n
You can also discover more posts on how to solve with Sheetgo below![\/et_pb_text][et_pb_text _builder_version=”4.4.8″ background_color=”#f9f9ff” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n
\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” global_module=”44987″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Managing large amounts of data becomes a lot easier when using great spreadsheet tools, such as Google Sheets. Although Google Sheets has many features that help us to manage and analyze our data, there still isn\u2019t a feature to select or filter specific columns to import to another spreadsheet. Currently, the only way to import […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Evan is an analyst in the sales department of his company. One of the tasks he has to do as part his job is to analyze how each product is performing across regions.\u00a0Every day he receives previous day's sales information as shown in the snapshot below. However, for this task, he doesn't need the entire data. So he will have to pick what is required for the purpose. In other words, import specific columns as needed. For this use case, we are going to import columns B, F, G and H.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n
\n\n[\/panel]<\/span>\n\nHe may choose to import the entire data set and remove unnecessary columns. But, what if the data set is huge (let's say there are about 50 columns), and the information we need is spread across? Add to that, he is to do this every day. It is definitely not what Evan would like to do repeatedly, especially if there is an automated solution to get this done.<\/span>\nUser-friendly solution: Automate with Sheetgo add-on<\/h3>\nAssuming that Evan has the Sales Information file on his Google Drive with read access, we will now try and configure the automation to import specific columns as required.<\/span>\n
1. Start\u00a0Sheetgo and initiate an import link connection<\/h4>\n
- \n \t
- Open the file that we want the data to import to.<\/span><\/li>\n \t
- If the Sheetgo add-on isn\u2019t installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application.\u00a0[panel type=\"default\"][ccj id=\"Install Widget\"]
[\/panel]<\/span><\/li>\n \t
- Once we have it installed, navigate to Add-ons > Sheetgo > Start<\/strong>.\u00a0<\/span><\/li>\n \t
- Doing so will open the Sheetgo interface on the screen as a sidebar, as shown in the image below. Hover the mouse pointer over the green circle with a plus, and click on the Import<\/strong> option.\u00a0[panel type=\"default\"]Example<\/strong><\/span>\n
[\/panel]<\/li>\n<\/ul>\n2. Link source sheet with the destination file that we need to import the data from<\/h4>\nClicking the 'Connect' option leads us to the list of most recently updated files by default. If we don't see the file we want, we can use the search module to lookup a file within the Google Drive. For this example, we select \"Sales Information\" file for 'destination spreadsheet', and then for 'source sheet' choose \"Sheet1\".<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n
\n\n[\/panel]<\/span>\n\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \"Automatic update<\/strong>\" section. We leave it to the default option,\u00a0'Daily', because Evan, receives the updated 'Sales Information' file every day.<\/span>\n3. Add the filter condition for selective data import, and create a connection<\/h4>\nTo do this, we may have to scroll down a bit on the sidebar until we see \"Filter by<\/strong>\" section. By default, it shows \"No active filter\". Click on 'edit<\/strong>' to add a condition. Choose 'Query Language<\/strong>' option, and key in the following statement.<\/span>\n\n[panel type=\"default\"]SELECT B, F, G, H<\/strong>[\/panel]<\/span>\n\nThe\u00a0\"Filter by\" section now shows \"SELECT B, F, G, H\". Finally, to establish the link that can\u00a0automatically export filtered data, we click \"CONNECT<\/strong>\" button.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n
\n\n[\/panel]<\/span>\n\nDoing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \"Last update: Just now\".<\/span>\n\nCongratulations! We did import specific columns from the 'Sales Information' file! Let's check the \"Sales Analysis\" file to see if the data has flown in.<\/span>\n\n[panel type=\"default\"]Example<\/strong><\/span>\n\n\n\n[\/panel]<\/span>\n\nSure enough, it has, and rightly so! We see that Sheetgo creates a new sheet (name will be same as that of the connection), and accordingly pulls only B, F, G and H column data from 'Sales Information' file.<\/span>\n\nThe data import keeps happening automatically and periodically\u00a0once the appropriate connection is in place.\u00a0Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.<\/span>\n\nConnection name\u00a0<\/strong>(in this case \u201cSG_Sheet1\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update > edit<\/strong>.<\/span>\n\nClick on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.<\/span>\nAdvanced solution: Use composite Google Sheets formulas to import specific columns<\/h3>\nSeasoned Google Sheets users may comfortable using a combination of two built-in formulas, QUERY<\/a> and IMPORTRANGE<\/a>. To import specific columns into the destination sheet, we need to key in the following formula:<\/span>\n
=QUERY(IMPORTRANGE(url,\"A:E\"), \"SELECT B, F, G, H\")<\/strong><\/span><\/pre>\nFor further reference on this approach, you may want to go through this excellent Stack Exchange<\/a>\u00a0discussion.<\/span>\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-2607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2607","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=2607"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2607\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - If the Sheetgo add-on isn\u2019t installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application.\u00a0[panel type=\"default\"][ccj id=\"Install Widget\"]
- Multiple condition (AND)<\/b> – filter a column of data with multiple conditions. The data in the column must fulfill all<\/b> of these conditions in order to be imported to your spreadsheet.<\/li>\n<\/ul>\n
- Single condition (OR)<\/b> – filter a column of data with a single condition. The data in the column either fulfills the condition or doesn\u2019t. Those that do will be imported to your spreadsheet.<\/li>\n
\n
- Multiple condition (AND)<\/li>\n<\/h4>\n