light text editor for csv file? (on windows)
I frequently need to open csv files just to have a look at what is inside and what its structure is. I also may need to find a text string and possibly edit a typographical error.
I can do this in excel or openoffice calc. I am looking for something that is almost instantaneous. Notepad would work if only it layed it out in columns. Openoffice calc always asks me what I want to separate by and guesses correctly but I do not know how to make it go ahead without making me deal with a dialog box.
Can you suggest a way to make openoffice faster or better yet direct me to a Windows program that is as lightweight as notepad but actually separates the fields into columns.