5

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)

|improve this question
  • Should the program also be able to save the files after editing? – ComFreek Jun 9 '14 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 '14 at 8:01
6

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

|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 '14 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 '14 at 20:05
6

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

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

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

enter image description here

|improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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