Take the 2-minute tour ×
Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. It's 100% free, no registration required.

I am looking for a program that can open and display nicely .csv files and gives you the ability to set the delimiter of each file.That's because most of the files I handle have some weird delimiters like £ or $.

I've been usind CsvEd for quite a long time but I was wondering if there are other "players" too.

OS requirements: Windows Vista/7 or Linux (especially Mint)

share|improve this question
    
Should the program also be able to save the files after editing? –  ComFreek Jun 9 at 8:00
    
not mandatory but sure, why not. My main problem is the viewing of the csv because most editors do not support custom delimiters –  dimzak Jun 9 at 8:01

3 Answers 3

up vote 6 down vote accepted

You can use OpenOffice (or LibreOffice, which is pretty much the same):

  • free and open source
  • Windows and Linux
  • specify the delimiter when importing the CSV:

enter image description here

share|improve this answer
1  
I guess I forgotten about the office family. That was because most .csv files are usually dumps from a procedure and are too big and fatty to be opened by those programs, but still this answer covers everything in my question. Accepting because I generally use OpenOffice and worked fine with a small csv I have :) –  dimzak Jun 9 at 17:51
    
For large CSV files I often dump them into a DB, or use 010 Editor but the latter does not display CSV nicely :/ –  Franck Dernoncourt Jun 9 at 20:05

For Windows, if you have Microsoft Office, you can use Excel. You have the ability to set a custom delimiter when importing text files:

Excel custom delimiter

share|improve this answer
1  
MS Office isn't gratis. There is a gratis trial of 30 days, though. –  Oriol Jun 9 at 19:14

You can use Google Drive (free, web-based). Create a new spreadsheet, go to File > import, then specify the delimiter:

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.