I'm occationaly dealing with CSV files. I was wondering if there's a program that displays the CSV nicely in an Excel-like format (bonus for enabling sorting and searching) on the fly without saving the CSV to file and then opening it in excel. Preferably, it should be able to fetch the data from the clipboard and display it in an Excel-like format

My current workflow is: look at CSV piece of data in a text file -> copy it to Excel -> click on "convert text to rows" menu -> select comma as separator -> examine data. If there's a piece of software that would save me the trouble that would be nice.

link|improve this question

62% accept rate
+1 Interesting question because I've always just used Excel. – hanleyp Oct 12 '09 at 16:38
feedback

2 Answers

up vote 2 down vote accepted

CSVed is a free program that allows you to edit, merge and convert these files with ease.

Here's what it can do:

  • column sort and global sort
  • edit, add, insert and delete items
  • import
  • change separator
  • add, delete columns
  • rearrange column order
  • save selection of rows and columns
  • save filtered items
  • save with double quotes
  • search and replace
  • filter items
  • remove duplicates
  • append and merge files
  • add prefix and suffix
  • split and join columns
  • export to HTML, Excel, Word, XML and more
  • column search

alt text

link|improve this answer
feedback

CSVed is all you need.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.