Photo by Stuart Miles
Bossman got you facepalming on your latest project? Working with large subscriber or customer information lists can be a headache. You may run into a project where you have to combine several types of lists with different column information and they don't match up with your new system. You might have to prune, merge, cut or otherwise make sure a huge list is clean/tidy. Microsoft Excel can handle csv files, but keep in mind that Excel does have its limitations:

Microsoft Excel has size limitations:

Here are some alternate tools and information I've run into to help maintain your larger lists:

CSVed
For managing large CSV files (think super-excel):
http://csved.sjfrancke.nl/

CSV Splitter
For splitting huge CSV files (can keep header and apply to split files):

Combine using Command Prompt
How to combine several CSV files into one file using cmd: