I've found this tool to be very powerful and helpful...and I almost couldn't find it again after recently upgrading to a new computer. To prevent future heartburn, I'll document it here.
From the csvkit web site:
csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats.