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’s 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’s best to split the data within your CSV files into multiple Excel or Google Sheets files. 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.
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.
Why split CSV files automatically?
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.
What’s more, splitting CSV files automatically using Sheetgo also offers even more benefits. Here are just a few:
- Automated workflow: Sheetgo creates an automated workflow that handles all of your processes from start to finish.
- No human error: There’s no need to manually transfer your data, not only saving time but eliminating any room for human error.
- Control over sharing: Have full control of where you split your CSV files and who you share the automated workflow with.
Now that we understand the importance of splitting CSV files automatically, let’s explore how to do this with the Sheetgo web app.
How to split a CSV file into multiple files automatically
Let’s say I have a CSV file full of every single customer order in the last three years.
It has tens of thousands of rows of data.
The sales team needs all the 2021 order data in a new Google Sheet in order to analyze the results to create a report.
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.
Step 1: Sign up for Sheetgo
Sign up for Sheetgo by clicking the blue button below.
Use your Google, Dropbox, or Microsoft account to sign in.
Step 2: Create new workflow
Once you have the Sheetgo web app open, click Create workflow.
Make sure you label your new workflow clearly.
Step 3: Upload your CSV file
To start building your workflow, click Connect files.
Here is where we will upload our CSV as our source file. Select the CSV or TSV file, then click Select file to search for it in your storage.
You can search for your file depending on where it’s located (Google Drive, Dropbox, One Drive, etc).
As my CSV file is located in my computer file, I need to select the Upload file button.
Now that I have selected my file and pressed Open, my CSV file was successfully uploaded.
Once you’re happy with your upload, press Continue.
Step 4: Split your CSV file into new destination files
Under the Send data section, select the Multiple destinations in folder option.
This is how we can split our CSV data into multiple files.
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’s create a new folder in my Google Drive.
Now it’s 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.
Once you’re happy with your destination folder, the source column, you can also alter the name of your destination tab to your liking.
Once everything is completed, press Finish and save.
Step 5: Open your new files
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.
Here are all of the 2021 order data in one spreadsheet, ready to send to the sales team.
New way to split data with Sheetgo
Sheetgo’s 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’ll have even more control and flexibility with the way you split your data.
Head to our support page to find out more information about the Sheetgo distribute feature coming soon.
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.
Looking to merge CSV files together instead? Discover our blog post on How to merge and combine CSV files automatically!
Alternatively, check out more related blog posts below!