Every now and then you have to deal with tabular data files that are larger than average. I, for one, occasionally have to deal with CSV files as large as 500MB – 1GB each (e.g. 10000 rows, 30000 columns). If you already had the doubtful pleasure of using Excel to handle such files you know that it can fail even to display them (16384 columns limit), not to mention any editing. Recently I became so desperate about Excel’s incompetence that I wrote my own tool specifically for browsing large CSV files. It’s called FastTable and features data display in tabular form with constant width/height of the cells. It has very low memory overhead, essentially the only thing that is loaded and kept in memory is the CSV file itself, plus very little cached information about positions of different cells in the file. Everything else required for the display is efficiently computed on the fly. You can open CSV files either by dropping them on the main window or using Open File dialog. At the moment only semicolon-separated files are supported and no semicolons within cells. Give it a try. Thanks to FastTable I was finally able to instantly get an overview of all those big CSV files without Excel’s shiny interface squirming in agony of processing 1GB of data.
DOWNLOAD (Win32 binary): fasttable.zip
SOURCE CODE (BSD-old licensed): fasttable_src.zip