[et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
CSV files are a great solution to storing huge amounts of data in one place. Lighter than a spreadsheet, they offer a simple, tabular format that is convenient for handling lots of raw data. However, when it comes to managing and evaluating this data, a CSV file does not have any analytical capabilities. This is why often, it\u2019s best to open your CSV file in Excel or Google Sheets, where these analytical features are available. Unfortunately, in many cases, a CSV file is too large to open in Excel or Google Sheets. So, it\u2019s best to split the data within your CSV files into multiple Excel or Google Sheets files.<\/p>\n
Manually splitting CSV files into multiple files can be a long and tedious process, taking away precious time that could be spent on more important tasks. The solution? An automatic way to split CSV files into multiple files, using Sheetgo.<\/p>\n
In this article, we will walk you through a step-by-step process on how to automatically split CSV files into multiple files with the Sheetgo web app.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”why-split-csv-files-automatically” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Automatically splitting CSV files into multiple files is a great way to save time and effort in manually splitting and transferring large amounts of raw data from a CSV source to other files.<\/p>\n
What\u2019s more, splitting CSV files automatically using Sheetgo also offers even more benefits. Here are just a few:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Now that we understand the importance of splitting CSV files automatically, let\u2019s explore how to do this with the Sheetgo web app.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-split-a-csv-file-into-multiple-files-automatically” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Let\u2019s say I have a CSV file full of every single customer order in the last three years.<\/p>\n
It has tens of thousands of rows of data.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Split-CSV.png” alt=”split csv 0″ title_text=”Split CSV” align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The sales team needs all the 2021 order data in a new Google Sheet in order to analyze the results to create a report.<\/p>\n
Using the Sheetgo web app, I can split the data within my CSV file to create three new Google Sheets files that each contain the 2019, 2020, and 2021 orders. I can then share the spreadsheet with the 2021 order data with the sales team.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Sign up for Sheetgo by clicking the blue button below.<\/p>\n
Use your Google, Dropbox, or Microsoft account to sign in.<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SIGN 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” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Once you have the Sheetgo web app open, click Create workflow<\/b>.<\/p>\n
Make sure you label your new workflow clearly.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
To start building your workflow, click in From new connection<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Web-1920-\u2013-30-1.png” alt=”split csv 1″ title_text=”Web 1920 \u2013 30″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Here is where we will upload our CSV as our source file. Click Select file<\/b> to search for it in your storage.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Web-1920-\u2013-31-1.png” alt=”split csv 2″ title_text=”Web 1920 \u2013 31″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You can search for your file depending on where it\u2019s located (Google Drive, Dropbox, One Drive, etc).<\/p>\n
As my CSV file is located in my computer file, I need to select the Upload file<\/b> button.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Web-1920-\u2013-32-1.png” alt=”split csv 3″ title_text=”Web 1920 \u2013 32″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Now that I have selected my file and pressed Open<\/b>, my CSV file was successfully uploaded.<\/p>\n
Once you\u2019re happy with your upload, press Continue<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Split-CSV-\u2013-4.png” alt=”split csv 4″ title_text=”Split CSV \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Download Sheetgo to start the process of splitting your CSV file.<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SIGN 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” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Under the Send data<\/b> section, select the Files in a folder<\/b> option.<\/p>\n
This is how we can split our CSV data into multiple files.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Web-1920-\u2013-33.png” alt=”split csv 5″ title_text=”Web 1920 \u2013 33″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Choose the destination of your multiple spreadsheets. You can choose to create a new folder, or add the spreadsheets to an existing folder. Sheetgo also allows you to change the destination of your files, including Google Drive, Dropbox, and SharePoint. In this example, let\u2019s create a new folder in my Google Drive.<\/p>\n
Now it\u2019s also time to choose how to split your data. Simply choose a column containing the data that will determine the split of the data. In this example, I want to split the data by the order dates. Therefore, I will choose Column A. Sheetgo automatically creates a new spreadsheet for each category of data. So, I should have a separate spreadsheet for orders in 2019, 2020, and 2021.<\/p>\n
Once you\u2019re happy with your destination folder, the source column, you can also alter the name of your destination tab to your liking.<\/p>\n
Once everything is completed, press Finish and save<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Split-CSV-\u2013-6.png” alt=”split csv 6″ title_text=”Split CSV \u2013 6″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You should now be able to access new spreadsheet files containing your split data. I can access my new folder in Google Drive, and I now have 3 spreadsheets containing order data from each year.<\/p>\n
Here are all of the 2021 order data in one spreadsheet, ready to send to the sales team.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Split-CSV-\u2013-7.png” alt=”split csv 7″ title_text=”Split CSV \u2013 7″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”new-way-to-split-data-with-sheetgo” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#e4f4f9″ custom_padding=”20px|20px|20px|20px|true|true” border_color_all=”#6ae8ff” border_width_left=”5px” border_color_left=”#00b6ff” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Sheetgo\u2019s new release offers a new Split feature that makes splitting data from a single file even easier. The new feature allows users to send selected data from a file to up to 80 spreadsheets at once. You\u2019ll have even more control and flexibility with the way you split your data. Learn more.<\/a><\/p>\n [\/et_pb_text][et_pb_text module_id=”csv-splitter” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you have it! Using the Sheetgo web app, you can automatically split a large CSV file into multiple files via the dynamic data within your spreadsheet.<\/p>\nCSV splitter<\/h3>\n