How to Open a Csv File on a Mac
Tablecruncher
The lightweight, yet powerful CSV Editor for your Mac.
Tabular data is everywhere and developers, data scientists or e-commerce managers have to deal with sometimes very large CSV data sets. But the Mac lacks an editor, that is capable of handling these CSV files in a fast and user-friendly way. Tablecruncher is the tool to open, edit, convert, export and save all kind of CSV files, no matter how large they are or what encoding they use.
Download Free Buy Now!
Version 1.6.0
requires Mac OS X El Capitan, macOS Sierra, High Sierra, Mojave, Catalina or Big Sur (Intel/ARM64)
News Tablecruncher is now natively running on Apple Silicon (ARM) Macs
Features
Open files bigger than 2GB and containing more than 15 million rows. Opening a 100MB CSV file with more than 500,000 lines takes less than 5 seconds on a dual-core Macbook Pro.
Use Javascript as a macro language to manipulate your CSV files. A simple API gives you access to all cells and you can change cell content as well as do abitrary calculations.
Export your table data to JSON. The exported JSON is an array-of-objects if there's a header row present in your CSV data. Otherwise you'll get an array-of-arrays.
Automatically detects most CSV file formats and file encodings for you. If you want, you can easily override the automatic detection and choose the appropriate CSV parameters.
Open and save CSV files with one of these encodings: UTF-8, UTF-16LE, UTF-16BE, Latin-1 (ISO-8859-1) and Windows 1252 files. (These list will be extended in future updates.)
Use the powerful Find and Replace dialog to search for patterns in your table or in a selected area. Regular Expressions according to the ECMAScript 5 standard are supported.
Enjoy crunching your data with four beautifully designed color themes, including a dark theme that fits well with the Mac's dark mode.
Flag rows manually or with the Find and Replace dialog and export flagged rows as a new CSV file.
Modify your CSV data grid easily. You can sort lines alphabetically or numerically, move columns right or left or delete columns. Or set your first CSV row as a header row.
FAQ
At the moment 1.6.0 is the most up-to-date version. This version has been released on 29 Aug 2021.
CSV files are text files containing tabular data. The fields of the tables are separated by a special character, usually a comma, while a line break denotes a new record. The abbreviation CSV stands for Comma Separated Values.
There is no formal definition, it's an ad-hoc-format. There exists an RFC 4180 that describes a best practice approach, but it's in no way an official formal definition.
Yes, the application runs on macOS 10.14 Mojave as well as on the new macOS 10.15 Catalina. Dark mode is supported, but the appropriate theme has to be chosen manually.
Yes! Since version 1.5 Tablecruncher is macOS Big Sur compatible.
Yes! Since version 1.5.1 Tablecruncher runs natively on Apple Silicon (ARM64).
Tablecruncher is written in C++14, using the GUI framework FLTK. UTF-8 handling is provided by UTF8-CPP and Boost Locale. Duktape is the Javascript interpreter for the macro language and the JSON export routines are from Niels Lohmann's JSON libary.
To achieve the best possible performance, I decided to use C++ and the extremely fast FLTK toolkit. So, Tablecruncher is not written with an Apple-only tech stack. Result is a really fast application, but I know it never will win any design price. It aims to be a tool and like real tools it's not necessarily beautiful.
Just send an email to info@tablecruncher.com. I'll be happy to include it on my ever growing list of planned features, but make no promise that it'll ever be implemented.
What others are saying
Not convinced yet? Just download Tablecruncher for free and use it a fast CSV viewer – forever! Download Free
Blog
How to Open a Csv File on a Mac
Source: https://tablecruncher.com/
0 Response to "How to Open a Csv File on a Mac"
Post a Comment