CSV File Splitter is a lightweight Windows application which splits huge comma separated values files into a multiple sheet spreadsheet. Allowing further data analysis in Excel with its 1,048,576 row limit. The app will work even if Excel isn't installed.
I am regularly the recipient of data files which contain upwards of 20,000,000 rows and these simply cannot be opened for analysis in Excel with it's 1,048,576 row per sheet limit. I initially found a simple program online to split data files into multiple smaller data files, but this still involved manually copying the many data into separate new sheets in a single Excel spreadsheet.
I decided to write CSV File Splitter to automate the entire process. The app has options to create a single spreadsheet containing multiple sheets, multiple spreadsheets containing a single sheet, or multiple smaller data files. For a bit of added flexibility I also built in the ability to change the delimiter and customise the column data types ready for conversion to Excel.
The app is free to download at the moment and I intend to extend the free period into July while I get the product fine tuned after hopefully receiving feedback. If you have any constructive feedback I'd be grateful for it. Things I'm mainly interested in are: Do you find the product easy to use? Do you wish it had some extra features?
Report
This is so helpful! 👌
Report
Reviews
No reviews yetBe the first to leave a review for CSV File Splitter