Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
+1 Interesting question because I've always just used Excel. –  hanleyp Oct 12 '09 at 16:38

2 Answers 2

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

share|improve this answer

CSVed is all you need:

CSVed is an easy and powerful CSV file editor, you can manipulate any CSV file, separated with any separator.

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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