It depends what is the nature of data and what do you want to do with this data. If its highly quantitative in nature. Excel may be the right solution. Solution applies if you have excel 2010 or 2013(professional addition). 2010- Download power. If you're looking to open a large CSV file, CSV Explorer is the simplest and quickest way to open big CSV files. The Difficulty with Opening Big CSVs in Excel Spreadsheet software, like Excel and Google Sheets, work by loading entire files into a computer's high speed memory (RAM). It depends what is the nature of data and what do you want to do with this data. If its highly quantitative in nature. Excel may be the right solution. Solution applies if you have excel 2010 or 2013(professional addition). 2010- Download power.
Matt Birchler:
Basically, BBEdit was remarkably fast at opening the file, being 4x faster than Visual Studio Code and 20x faster than Sublime. And then in terms of saving changes to the file, most apps were in the same ballpark, which I assume is because this is reliant on my SSD’s ability to save the data, not the app doing anything special.
Patrick Seemann:
ed: immediately
emacs: ~6s
vi: ~8s
I’d like to see the results for Excel, Numbers, and TextEdit.
Previously:
Update (2019-08-06): Greg Hurrell:
Vim takes 8s to open a 1.5GB CSV file.
Matt Birchler:
I updated the post with the 3 apps you listed 🙂
Venkat:
Regarding the csv loading, Numbers can’t load more than 255 columns of data, which annoyed me frequently in the past few weeks. Google sheets and Excel had no problem with lots of columns.
Friedrich Markgraf:
Numbers does not support more than 65k lines. Current versions at least warn about that after the long import. Last year it just silently dropped lines.
FWIW, Querious has spreadsheety editing of CSV files in terms of rows and columns (with regex, splitting columns, joining columns, reordering etc) something like Numbers, but you know... actually works. Even on multi-gigabyte files. It's not blazing fast to open like raw text, but you get more out of it...
I'd be curious to see Hex Fiend tested.
Tried Hex Fiend on a synthetic 1.5GB CSV file, and opening was instantaneous.
Just tried it on Numbers.app, and it took ~230 seconds to open it… but it truncated to 65536 rows, which is the maximum number of rows for Numbers.
BBEdit remains an exemplar of software design and implementation at its finest. I've long been in the habit of opening large CSV files in BBEdit as a first choice for quick review instead of Excel, Numbers, or other tools. BBEdit remains the one app that always is open on my Mac, aside from a web browser.
I'll give honorable mention to another commercial text editor, UltraEdit by IDM Computer Solutions. It's not quite as elegant of a Mac app as BBEdit, but that's because it is truly cross-platform, with nearly identical Windows and Linux versions. I just tried dragging and dropping a 150 MB CSV file onto a few open applications, and the file felt like it snapped open in UltraEdit, possibly even beating BBEdit by a whisker. Impressive.
I just opened a 2.1GB csv in BBEdit, then did a search and extract for a common string using grep syntax. I didn't time it exactly, I think it took BBEdit a minute or so, but it did it just fine, and it's quick to navigate around both the original file and the new one created by the extract.
BBEdit. It doesn't suck.
Those numbers (65536 row limit, opening time) for Apple's Numbers are ridiculous.
I hate modern day Apple, where everything that doesn't lead to increased revenue in the next quarter (read iPhone) is done half-assed at best, if at done at all. :(
Stay up-to-date by subscribing to the Comments RSS Feed for this post.
Leave a Comment
CSV file is a commonly used format that contains numbers and texts in a spreadsheet format. The datasets are in text form and each of the new lines is separated by commas that signify a new row of the database. It’s simple and helps share huge amounts of data allowing you to view them from any location across the world.
However, to edit these files you would need a CSV editor that are spreadsheet software. This type of software allows you to change the files into cells that help transfer data among different databases. While there are many CSV editors available these days, not all are free.
Therefore, we have shortlisted some of the best CSV editors for Windows that are a mix of the free and paid.
CSVed
CSVed is a free program that can handle any type of CSV file with any type of separator. It has the ability to add, remove, edit, and include items, import and export data, delete duplicate data, connect and break columns, insert, remove, or re-align columns, and more.
It comes with a fully packed interface that features a navigation sidebar, chief document view above the compact editing window, and a four in one toolbar. This easy to use program offers a font manager, and also a portable version.
Price: free
CSVStar
CSVStar is again a freeware that helps prepare, edit, and take care of CSV files. The interface represents function areas using colors and offers help through a PDF file with instructions. While creating templates, it’s much easier to modify the Headers and Trailers with the help of the simple wizards.
Moreover, it offers several functions that help generate the CSV file fields automatically, based on conditions. You can also manage the templates easily that enables you to prepare more such identical files like that of the template. Furthermore, it works with multiple data varieties for its fields such as int, string, enum, etc.
Price: free
iMatrixitor
If you are looking for a CSV editor with comma and tab limited fields, iMatrixitor can be great for you. It works with Unix / PC formats of Text and binary files that are stored both on the native hard disk and on the remote FTP server. The program can open /change/store local and FTP files and also provides support for “save as” files between local and FTP. The program works with an external define file to format a kind of data file.
The program displays all fields and headers using external define file. It also offers a shared read/write mode, and also allows you to unlock while opening a file. It provides support for Windows and Unix format of new line and number. Moreover, it also offers a function that helps to open and save files from local disk and FTP server. Best of all, it automatically refreshes the opened files both on local disk and FTP server.
Price: free
CSVPad
A small and handy CSV editor and similar files, CSVPad is available to download for free. The program provides support for all types of formats that includes tab separated, colons, semicolons, pipes, dollars, etc. What’s interesting is, that it takes care of the details as CSVPad automatically identifies and uses the accurate format all on its own, by default.
It opens the target files in a table, where you can browse or start searching on it, instantly, edit separate fields, and even prolong the file with updated records. For situations where the file structure isn’t correct, you can also rearrange rows by adding new rows or columns, make copies or switch them, drag and drop, copy and paste them, or just shift your chosen rows/ columns to some new position.
It also comes with some surprise bonus features, such as “Snapshot” that saves a table in JPG format, “Search Online” option that opens a web page with the Google search results for the selected cell. Once you are finished, the file can be stored in CSV format or with the other compatible separators, for instance, tab/ colon/ semi-colon, and more, or exported as XLS, ODS, XML or HTML.
Price: free
LibreOffice Calc
LibreOffice is another free CSV editor that’s responsive and easy to learn. It also features an extended range of advanced features liked by professionals across the world. It comes with integrated wizards that walk you through selecting and using wide range of advanced functions. It also allows you to download templates from the LibreOffice template library, for off-the-rack spreadsheet tools.
It makes it convenient for you to apply flexible cell formatting options, and other options like freely rotating contents, borders, templates, and more, using the different styles and direct formatting functions. It also lets you reuse the pre-made sheets and concentrate on the current work using the templates with integrated functions.
Price: free
CSVFileView
Although CSVFileView is just an editor, it still offers a lot more than anticipated. It’s a simple and a free tool that lets you view and modify CSV files, despite a neat spreadsheet around. The tool has the ability to open CSV files, automatically identifying the delimiter and quote characters as an option, and also inserting few or all the lines.
The best part is, it puts up the file in a table, where you can sort, rearrange, or hide the columns based on your requirement. Moreover, the tool can also save your data in form of an HTML report, tab or a comma-delimited file, or in XML format. It also features some advanced options like in-depth control over the data you want to view. It also features a command line interface that helps automate the file conversions and other processes.
Price: free
CSV Buddy
CSV Buddy is a completely free CSV editing application that enables you to keep your CSV files ready to import using different types of software. This tool loads, saves, or exports files with multiple delimiters and using many other options. The best part is, it does not need a software to be installed. All you need to do is to extract the content in the zip file to your preferred folder.
You run the .EXE file from this new folder. You can then create a desktop shortcut for the tool for your convenience or on your start menu. This program can be freely shared online in an uninterrupted form.
Price: free
Apache Open Office
Apache Open Office Calc is a spreadsheet program that’s a lot similar to the LibreOffice suite. It’s a highly responsive and easy to learn software, especially for the beginners. However, it’s equally suitable for professionals who simply love the wide range of advanced features.
Among its major features are:
- DataPilot – a leading technology that makes it easy to extract in raw data from corporate databases.
- The Natural language formulas – allows you to make formulas using words like “sales – costs”, for example.
- Intelligent Sum Button – helps add a sum function or a subtotal automatically, based on context.
- Wizards walk you through how to select and use a wide range of leading spreadsheet functions, or download templates from the Templates library, and more.
- Styles and Formatting – make it easy to apply flexible cell formatting options.
- Scenario Manager – allows “what if …” investigation just as you touch the button.
- Solver component – lets you solve optimization problems where the optimum value of a specific spreadsheet cell has to be calculated.
- Multiple users support – allows teamwork on spreadsheets.
- Allows you to save the spreadsheets in OpenDocument format.
You can also send results to those who don’t have a spreadsheet program installed. They can simply use the .pdf and there’s no need to buy or install any added software.
Price: free
Ron’s Editor Lite
Ron’s Editor Lite is a dynamic tool that helps you view, look up, and edit files. The application can be used a plain grid. You can simply drag and drop a CSV file into the application and it shows up in a spreadsheet style view. You can then scroll along it, choose files, lines or columns, arrange the documents by particular fields, and much more.
It comes equipped with a filter system and a dynamic search tool that allows you to get deep down to the information you are looking for. Apart from basic editing (start typing in a field as required, or simply right-click for the options like edit rows, delete rows or columns, insert rows, etc., it also offers some bonus features that includes useful Cell Fill tools.
Price: free
CSVForm
CSVForm is another great free software to edit CSV files. It’s a lightweight tool that’s also portable. The only limitation is that it allows you to edit the only file at a time. Moreover, the software allows you to insert and delete data, input values, edit values, and much more. Best of all, it does not need to be installed and can be used out-of-the-box.
Price: free
ReCSV
ReCSV is a perfect tool to edit CSV files, as well as files with fixed width. One of its major advantages is that it automatically marks revelation for CSV files with single records. What’s more? You can also Fixed Width file and Multi-Record CSV / Fixed width files with the help of a XML Schema. However, the editing capacity for XML and PO files is limited.
How To Open Csv Files
Price: free
CSv files are regularly used and so, you would need a powerful tool to help you work around with it. While there are any tools available these days, we have listed the best in the business. Choose the one suits your requirement the best, and get done with any complexity while handling CSV files.
Microsoft Notepad
Open Csv Files Free
Microsoft Notepad is one of the powerful and leading text editors available that’s used for basic programming. This lightweight tool is also used for editing text format files. Although it’s useful for basic functions, being a text editor, it still allows you to change the font, size, and script, and text. Moreover, it’s handy for coding HTML and other formats. This integrated tool in the Windows is compatible with different files formats that include CSV, HTML, and CFG. Best of all, it can view and change contents saved in a CSV file format.
Price: free
Corel Quattro Pro
Designed by Corel, the Corel Quattro Pro program is now known as WordPerfect Office. It’s a spreadsheet tool and is specially made for the professionals who investigated spreadsheets on a daily basis. While it features basic tools used for calculation, it’s also a trusted CSV editor. Moreover, some of its features viz., the Perfect Expert Wizard and Quick-Fit are perfect to create on-the-go spreadsheets.
The software also comes packed with features like Precise Import and Export, PDF Creation with Fillable Fields for forms, Template-Preview, and so on. This software is a great option for office professionals and home user alike.
Price: free trial available; pro versions start from $43.90
I find passion in writing Tech articles around Windows PC and softwares