Splitting up large CSVs

posted Dec 21, 2010, 10:37 AM by Ezra Kenigsberg   [ updated May 17, 2011, 9:00 AM ]
#DataTipOfTheDay 2010-12-21

Q: "How do I break a large CSV into smaller files?"

A: I've found CSV Splitter (http://tinyurl.com/CSVSplitter) mighty handy--it's a straightforward Windows app that turns a single CSV into multiple child CSVs, giving you the power to determine how long each child CSV should be.  It also preserves the headers in each child file it creates.