Best CSV Editors for Mac

Excel learns your patterns, organizing your data to save you time. Easily create spreadsheets from templates or on your own and use modern formulas to perform calculations. New charts and graphs help you present your data in compelling ways, with formatting, sparklines, and tables to better understand your data. Easily create forecasts to predict trends with just a click. Share your workbook with others and always work on the latest version for real-time collaboration to help get work done faster. With Office 365, work within an Excel file from the mobile or desktop app, and the web. You now can add data to Excel directly from a photo. Using the Excel app, just take a picture of a printed data table on your Android or iPhone device and automatically convert the picture into a fully editable table in Excel. This new image recognition functionality eliminates the need to manually enter hardcopy data.

With its impressive tables and images, Numbers makes it possible to create beautiful spreadsheets and comes included with most Apple devices. Use Apple Pencil on your iPad to add useful diagrams and colorful illustrations. And with real-time collaboration, your team can work together, whether they’re on Mac, iPad, iPhone, or a PC. Numbers start you off with a blank canvas instead of an endless grid, so you have the freedom to move everything around your canvas at will and organize your data any way you choose. And everyone editing the spreadsheet has access to the same powerful features on iOS, iPadOS, and macOS. Drop your data into one of the gorgeous, ready-to-use templates, then customize your data any way you like. Select fonts and style cell borders. And add, resize, and apply styles to tables.

DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google and more. DbSchema is reverse-engineering the database schema from the database and visualize it as diagrams. You will interact with the database using diagrams and visual tools. DbSchema model is using its copy of schema structure, independent from the database. This allows the schema deployment on multiple databases, save the design model to file, store it in GIT and design the schema in a team, design the schema without database connectivity, compare different versions of the schema and generate SQL migration scripts.

LibreOffice is a free and powerful office suite, and a successor to OpenOffice.org (commonly known as OpenOffice). Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice is Free and Open Source Software. Development is open to new talent and new ideas, and our software is tested and used daily by a large and devoted user community. Your documents will look professional and clean, regardless of their purpose: a letter, a master thesis, a brochure, financial reports, marketing presentations, technical drawings and diagrams. LibreOffice makes your work look great while you focus on the content, thanks to its powerful styles system and structuring tools. LibreOffice is compatible with a wide range of document formats such as Microsoft® Word (.doc, .docx), Excel (.xls, .xlsx), PowerPoint (.ppt, .pptx) and Publisher. But LibreOffice goes much further with its native support for a modern and open standard.

​Easy CSV Editor is a powerful and intuitive application designed specifically for Mac users to efficiently manage and edit CSV files. Built entirely using native Apple technologies, it ensures seamless integration into the Mac environment, providing a familiar user experience with consistent shortcuts, a customizable toolbar, and right-click menus. It operates entirely locally, guaranteeing 100% privacy as no data leaves your computer, and it functions without an internet connection. Easy CSV Editor boasts super-fast loading, searching, and filtering capabilities, maintaining stability even when handling large files. It preserves data integrity by preventing unintended alterations, such as stripping leading zeroes. The column explorer feature offers a bird's-eye view of all columns, allowing users to drill down into specific statistics and details. Advanced filtering enables focusing on specific data subsets, with options to save and reload filter rules.

​Tablecruncher is a lightweight yet powerful CSV editor for Mac, designed to handle large datasets efficiently. It can open files larger than 2GB, containing over 15 million rows, with a 100MB CSV file loading in under 5 seconds on a dual-core MacBook Pro. It supports various encodings, including UTF-8, UTF-16LE, UTF-16BE, Latin-1 (ISO-8859-1), and Windows 1252, automatically detecting most CSV formats and encodings. Users can utilize JavaScript as a macro language to manipulate CSV files, accessing all cells for content changes and calculations. Tablecruncher allows exporting table data to JSON, producing an array of objects if a header row is present, or an array of arrays otherwise. The find and replace dialog supports pattern searches within the table or selected areas, with Regular Expressions compliant with the ECMAScript 5 standard. It offers four color themes, including a dark mode compatible theme, enhancing user experience.

​Tad is a free (MIT Licensed) desktop application for viewing and analyzing tabular data. It is a fast viewer for CSV and Parquet files and SQLite and DuckDb databases that support large files. It's a Pivot Table for analyzing and exploring data. Internally, Tad uses DuckDb for fast, accurate processing. Designed to fit into the workflow of data engineers and data scientists. Tad includes updates to DuckDb 1.0, the ability to export filtered tables as Parquet (as well as CSV), a fix for formatting numbers in scientific notation, and other minor bug fixes and dependent package upgrades. A packaged installer for Tad is available for macOS (x86 and Apple Silicon), Linux, and Windows.

​The CSV Editor plugin for JetBrains IDEs introduces CSV (Comma-Separated Values) as a recognized language, providing syntax definition, structured language elements, and associated file types (.csv/.tsv/.psv). This enables default editor features like syntax validation, highlighting, and inspections for CSV-like files. It supports customizable text and table editors, flexible table editing, syntax validation, customizable syntax highlighting and formatting, quick-fix inspections, and intentions such as quoting/unquoting and shifting columns. It accommodates various value separators, and tab, with support for custom separators and line comments. The table editor allows adding or removing rows and columns via context menus and supports key bindings for efficient navigation and manipulation.

Modern CSV is a tabular file editor/viewer with advanced editing features and large file handling. It makes up for the weaknesses of spreadsheet programs in handling CSV files while incorporating the strengths of the best text editors. Its features include: multiple cell/row/column editing, fast load times, customizable keyboard shortcuts, data analysis, light and dark themes, regex find/replace, and multiple encoding and delimiter handling.