{"id":25384,"date":"2020-06-22T12:08:55","date_gmt":"2020-06-22T10:08:55","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=25384"},"modified":"2020-06-22T12:08:55","modified_gmt":"2020-06-22T10:08:55","slug":"como-filtrar-csv-a-otra-hoja-de-calculo","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/how-to-solve-with-sheetgo\/how-to-filter-csv-to-another-spreadsheet\/","title":{"rendered":"C\u00f3mo filtrar CSV a otra hoja de c\u00e1lculo"},"content":{"rendered":"

[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

CSV files are useful when you want to extract, store and share large volumes of data from multiple databases and different types of software.\u00a0Similar to “flat files”, CSV files are a simple, plain text file with a tabular format. If you’re moving information from one database to another, CSV files provide a smooth way to move data without reformatting. But when you want to “read” that data, or combine and process information for reporting and analysis, you need to extract your data from CSV and into a spreadsheet or filter CSV data into specific workbooks or sheets.\u00a0<\/span><\/p>\n

CSV is compatible with Excel and Google Sheets, meaning you can open the file, but the data will probably need some adjustments. If you open a CSV file in Excel, the data may be difficult to read with formatting problems and errors with codes beginning with zero. It’s possible to manually adjust the Excel settings<\/a> each time you import a CSV file but you can automate this process, and you can also select exactly which data you want to import. Here’s how to filter CSV data to another spreadsheet:<\/span><\/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″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

How to filter CSV to another spreadsheet<\/h3>\n

Sheetgo allows you to transfer specific data from a CSV file(s) to Excel, Google Sheets or another CSV file. The original CSV file remains intact, and your selected data will flow into the other spreadsheet automatically without copy-pasting. Follow these steps to get started:<\/p>\n

Step 1: Install Sheetgo<\/h4>\n

Click the blue button below to install Sheetgo.<\/p>\n

[\/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

Once you\u2019re inside the web application, click on\u00a0<\/span>+Create workflow<\/strong>\u00a0and then\u00a0<\/span>Connect<\/strong>\u00a0to start creating your filtered CSV connection.<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Step 2: Select CSV as your source data<\/h4>\n

Click on +Select file(s)<\/strong> to search for the CSV file in your cloud storage.<\/p>\n

As you can see in the example screenshot below, my data source is a CSV file called “Major League Ball” that I have selected from my Google Drive.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Filter-CSV-data-1@2x.png” alt=”filter CSV 2″ title_text=”Filter-CSV-data-1@2x” align=”center” _builder_version=”4.17.4″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Step 3: Filter CSV data<\/h4>\n

Click on Continue<\/strong> to go to the next step and apply filters to your CSV file data. There are 3 options here: filter by condition, filter by query, and filter by color.<\/p>\n

In this case, let’s use the filter by condition feature.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Filter-CSV-data-2@2x.png” alt=”filter CSV 3″ title_text=”Filter-CSV-data-2@2x” align=”center” _builder_version=”4.17.4″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Sheetgo’s connection editor allows you to choose from a range of conditions to create your own custom filter. Select which column you want to apply the filter to, and which criteria the data should match.<\/p>\n

In this example, I will filter out teams that are in the top 3 of the League.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/Filter-CSV-data-3@2x.png” alt=”filter CSV 4″ title_text=”Filter-CSV-data-3@2x” align=”center” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][\/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″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Step 4:\u00a0Select your data destination<\/h4>\n

You can send the filtered data from the CSV file to any other spreadsheet type supported by Sheetgo: Google Sheets, Excel, or another CSV or TSV file.<\/p>\n

I have chosen to send my CSV data to an Excel file. You can select an existing file, or Sheetgo will create a new one for you automatically.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/Filter-CSV-data-4@2x.png” alt=”filter CSV 5″ title_text=”Filter-CSV-data-4@2x” align=”center” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Click\u00a0Finish and save<\/strong>\u00a0to filter CSV to another spreadsheet. You will see a new tab appears in your destination file, containing the imported data. Sheetgo saves the connection as a workflow<\/strong>. You can add more connections to build on the workflow and create a larger system.<\/p>\n

Step 5: Automate your workflow<\/h4>\n

On the floating menu bar of your workflow, click\u00a0Automate<\/strong>. Here, you can schedule automatic updates to run hourly, daily, weekly, or monthly. Filtered data will be transferred automatically at these times, without you having to open a spreadsheet.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/Filter-CSV-data-5@2x.png” alt=”filter CSV 6″ title_text=”Filter-CSV-data-5@2x” align=”center” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Filter CSV data to your spreadsheets automatically<\/h3>\n

That’s how to filter CSV to any other spreadsheet using Sheetgo. And with automatic updates, you can get the data you need, whenever and wherever you need it.<\/p>\n

Want to save more time when working with CSV and Excel files? Learn how to link CSV to Excel files automatically<\/a>\u00a0and create more automated workflows to manage and share data across your team.<\/p>\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":"

CSV files are useful when you want to extract, store and share large volumes of data from multiple databases and different types of software.\u00a0Similar to “flat files”, CSV files are a simple, plain text file with a tabular format. If you’re moving information from one database to another, CSV files provide a smooth way to […]<\/p>\n","protected":false},"author":40,"featured_media":25687,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-25384","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\/es\/wp-json\/wp\/v2\/posts\/25384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=25384"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/25384\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/25687"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=25384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=25384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=25384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}