Como importar colunas específicas para o Planilhas Google?

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’t a feature to select or filter specific columns to import to another spreadsheet. Currently, the only way to import specific columns to Google Sheets is to import the entire spreadsheet of data and then manually delete the columns we don’t need.

This can take up hours of your time. So what’s a more efficient way?

You can automatically import specific columns into Google Sheets using the Filter feature in Sheetgo’s web app.

This is a great tool to use within business operations where you’re dealing with vast amounts of data that you want to filter and transfer to other files. For example, let’s 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.

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!

Como importar colunas específicas para o Planilhas Google

The Sheetgo web app has different types of filter features depending on how much you want to filter your data. Let’s 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.

How to import entire columns to Google Sheets – Query feature

Using the example mentioned at the beginning of the post, let’s import columns C, I J & K from our Sales records sheet into a new Google Sheets file.

Etapa 1: Instalar o Sheetgo

Open the Sheetgo web application by clicking the button below. Sign up with your Google, Microsoft, or Dropbox account.

Etapa 2: Criar fluxo de trabalho

No aplicativo da Web Sheetgo, clique em Criar um novo fluxo de trabalho 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.

Quando terminar, pressione Continuar.

Step 3: Filter your data

Next, Sheetgo will ask you to choose a next step. Under the Processo seção, selecione Filtrar.

Agora, selecione o Consulta feature. This is the easiest function to use to filter our data by entire columns.

Step 4: Use the Query editor

As you can already see, Sheetgo has made this process easier by already starting your query.

Simply click on the columns that you want to filter. Once completed, press Continuar.

Step 5: Select destination file

It’s time to import your columns to your new sheet. Under the Enviar para section, choose whether to import your data into a single spreadsheet or multiple files. Then, customize your file settings to your needs.

In this example, let’s create a new file in Google Sheets for our columns. Once finished, press Concluir e salvar.

Step 6: View filtered data

You’ve successfully imported your specific columns to Google Sheets. Your new file should now show these chosen columns.

How to import specific data within columns to Google Sheets – Condition feature

Let’s say you want to import data relating to a specific product within our spreadsheet. In this case, you would use the Condição característica.

Depending on how many aspects you want to filter, you can use either the single condition or the multiple condition.

Single condition (OR)

Let’s say you want to filter our data relating to only Product 3. Simply follow the steps listed above, but this time, select the Condição feature. Then click the Simple condition (OR) opção.

Now filter your data by selecting the product column (column C), choose the criteria O texto é exatamente, and write the name of the product (Product 3).

Multiple condition (AND)

Suppose that you want to filter this data more, specifically importing data relating to Product 3 that was also purchased in Indonesia.

This time, choose the Multiple condition (AND) option. First, filter your data by selecting the product column (column C), choose the criteria O texto é exatamente, and write the name of the product (Product 3).

Em seguida, pressione Add condition. To filter our location, select the city column (Column K), choose O texto é exatamente, and enter your location (Indonesia).

The Filter feature in Sheetgo

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.

For a better understanding of each filter feature and when to use them, let’s explore each in more detail and what they can do.

1. Filter by Query

Sheetgo’s Filter by Query feature uses query syntax similar to SQL that acts as an instruction for your spreadsheets.

With a simple SELECT* query, you can filter down specific columns to import into your spreadsheet.

2. Filter by condition

The Filter by condition feature in Sheetgo allows you to filter your spreadsheet data in more detail.

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.

• Single condition (OR) – filter a column of data with a single condition. The data in the column either fulfills the condition or doesn’t. Those that do will be imported to your spreadsheet.
• Multiple condition (AND) – filter a column of data with multiple conditions. The data in the column must fulfill all of these conditions in order to be imported to your spreadsheet.

3. Filter by color

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.

For example, we could filter our stock level column by only importing the data with the green cell color (denoting ‘high’ stock levels).

Filter specific columns in Google Sheets

And there you have it! Sheetgo’s filter feature has multiple functions that can automatically import specific columns or specific data within columns to Google Sheets in just a few clicks.

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.

You can also discover more posts on how to solve with Sheetgo below!