Active2 years, 10 months ago
What Is the Best Way to View or Edit Large CSV Files? Our clients have been frequency asking us for recommendations in opening large CSV files and easily split it into smaller parts while retaining column headers. A simple CSV editor for OS X. Download on the Mac App Store. The CSV format is a common used file format to store and exchange tabular data. Almost all spreadsheet and database apps (e.g. Excel and Numbers) support it. > What Is the Best Way to View or Edit Large CSV Files? What Is the Best Way to View or Edit Large CSV Files? Our clients have been frequency asking us for recommendations in opening large CSV files and easily split it into smaller parts while retaining column headers. CSV Editor is a must-have app for anyone who want to edit CSV documents on the Mac. It allows you to open any encoded CSV documents, automatically detect text encoding and parse any encoded text. CSV Editor for Mac OS X: Best alternatives Check out alternatives to CSV Editor for Mac proposed by our editors and user community.
Could anybody suggest a light (small, fast) text editor that can
- handle columnar view of csv files?
- save quote character to all fields, even if not 'necessary'
OpenOffice Calc is bit big for my old laptop. My favourite Notepad++ cannot present a columnar view. And it seems to me that Sharp Tools Spreadsheet cannot import CSV files. Google Docs converts some date fields by default, which I do not want and it is really slow.
slhck171k49 gold badges476 silver badges492 bronze badges
RadekRadek1,45917 gold badges44 silver badges74 bronze badges
closed as not constructive by slhckNov 1 '12 at 14:59
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
4 Answers
CSVed - at 1MB it seems pretty light.
Note that as of version 2.2.1 it has trouble opening large CSV files.
- a 4,000,000 row, 313 column, LF terminated CSV simply gives a 'File is empty' warning
- reduced to ~1000 rows it opens, but drops columns 227 - 313
- reduced to 1 row, it still drops columns 227 - 313
Community♦
RookRook17.1k28 gold badges112 silver badges181 bronze badges
I have written a product called Ron's Editor which you might want to look at. I am always interested in making it more useful/powerful so I would be interested in your feedback.
Ron's Editor is a powerful CSV file editor. It can open any format of separated text, including the standard comma and tab separated files (CSV and TSV), and allows total control over their content and structure.
With a clean and neat interface Ron's Editor is also ideal to simply view and read CSV, or any text delimited, files.
Ron's Editor is the ultimate CSV editor, whether you need to edit a CSV file, clean some data, or merge and convert to another format, this is the ideal solution for anyone who regularly works with CSV files.
Gaff16.3k11 gold badges50 silver badges65 bronze badges
Aaron StewartAaron Stewart
CSVed is a light weight editor specifically designed for editing CSV files on Windows. It's free.
Ian C.Ian C.Free Csv Editor For Mac
![For For](/uploads/1/2/6/3/126346703/678999241.png)
5,1182 gold badges25 silver badges28 bronze badges
You could use the Windows port of emacs and then use the CSV mode.
slhck171k49 gold badges476 silver badges492 bronze badges
spowersspowers