How to split a CSV file and save the files to Google Drive

The easiest way to split a CSV file and save the files to Google Drive

SplitCSV.com is the easiest way to split a large CSV file (with a file extension of .csv) file into multiple files. If you have a CSV file that is too large to open in a specific program (like Excel or Google Sheets) because it uses too much memory or hits the row/column limit, SplitCSV.com can help you break it apart into smaller files and save it to Google Drive, so you can share it with your team. Here is the easiest way to split a CSV file and save it to Google Drive.

  1. Go to https://www.splitcsv.com/Open SplitCSV.com in a your browser
  2. Click the Choose File button and upload a CSV file or Excel file. Once the file is uploaded and processed, select the Split Options button to continue.Upload a CSV file
  3. Once the Split Options page loads, select your split options: below, we are splitting by value. Click the Output Details button to continue.Split by Value
  4. On the Output Details page, click the Individual CSV Files button. Selecting the Individual CSV files option
  5. You can then click the Drive button to open the Google Drive picker and select the destination folder to write the files to. Once you've selected the folder, click the Select button.Selecting the Google Drive output location
  6. The Output Details page will now show the output location. You can click the Advanced Options button to continue.Selected Google Drive output folder
  7. You can now select any advanced options, including dropping specific columns, re-ordering the output column order or adding new additional columns. Select Confirm Order to verify your selections.Advanced Options
  8. Once your selections are verified, click the Split button.Verify options and split!
  9. On the confirmation page, the split will be executed.Completing the split
  10. Once the split is complete, you can click on the View button to open the Google Drive folder.Completed split
  11. And your files in your Google Drive!Google Drive

Happy splitting!