CSV Editor – CSVed
CSV Editor or CSVed is a free, powerful CSV file editor. CSV Editor doesn’t have spreadsheet capabilities like Microsoft Excel or OpenOffice Calc but it can open much larger files than either of these. We’ve opened files with over 5 million records. CSV Editor is a great tool for sorting and manipulating our phone lists. To learn more about CSV Editor and to download it visit the CSVed site.
Notepad++ is free software that is similar to the Notepad program that comes with Microsoft Windows. It’s better than Microsoft’s Notepad because it will open very large CSV files quickly. While it doesn’t give you the sorting capabilities of Excel or CSV Editor you can use it to very quickly copy and paste to create sub-files, or delete many lines of records quickly. You can also use Notepad++ to look at the raw data to determine if there are any problems with the file’s format. To learn more about Notepad++ and to download it visit theNotepad++ site.
FileSplitz is free software that lets you take a file and split it into smaller files. This is helpful for dealing with the really large state files. You could take a huge file, like say California Residential and split it into 5 or 10 files of equal size that would be much easier to manipulate than the whole state file. You can download FileSplitz here.