Split your CSV file into multiple files

Drop your file below

Drop your CSV file here or
File Split by column
MyDataFile.csv

Finished ZIP folder

MyDataFile_split-by_column.zip 0 files

Excel kind of sucks... at least sometimes.

Recently, I needed to generate multiple files from one large Excel sheet using a column's value. Should be simple, right? Not quite! There seems to be no built in way to do this (that I could find online) other than using VBA functions, and I'm not about to learn that.

So, instead of sorting the data by column, copying the appropriate rows, pasting those rows into a new document, and finally saving that file, I decided to just make this tool!

Did it probably take longer than just doing it manually? Probably! But hey, now I (and anyone who finds this) can do it painlessly.

The caveat is...

The file you drop below needs to be a CSV file and the files you get back will also be CSVs. That's just the format I needed... and thought would be easier to deal with 😊.