Best CSV Editors for Apache Parquet

Tad is an open-source desktop application available under the MIT License, designed specifically for the visualization and analysis of tabular data. This application serves as a swift viewer for various file types, including CSV and Parquet, as well as databases like SQLite and DuckDb, making it capable of handling large datasets efficiently. Acting as a Pivot Table tool, it facilitates in-depth data exploration and analysis. For its internal processing, Tad relies on DuckDb, ensuring rapid and precise data handling. It has been crafted to seamlessly integrate into the workflows of data engineers and scientists alike. Recent updates to Tad include enhancements to DuckDb 1.0, the functionality to export filtered tables in both Parquet and CSV formats, improvements in handling scientific notation for numbers, along with various minor bug fixes and upgrades to dependent packages. Additionally, a convenient packaged installer for Tad is accessible for users on macOS (supporting both x86 and Apple Silicon), Linux, and Windows platforms, broadening its accessibility for a diverse range of users. This comprehensive set of features makes Tad an invaluable tool for anyone working with data analysis.

CSViewer is a quick and free desktop application for Windows that allows users to view and analyze extensive delimited text and binary files, including formats like CSV, TSV, Parquet, and QVD. The application can effortlessly load millions of rows in just a few seconds and provides sophisticated filtering options alongside immediate profiling features, including aggregate functions, null counts, and outlier identification. Users can easily export their filtered datasets, save their analysis configurations, and create visualizations through charts and cross-tabulations. With a focus on facilitating exploratory data analysis without relying on cloud services, CSViewer ensures that all aggregates and visual elements refresh instantaneously whenever a filter is applied or modified. Each column's statistics, including null counts, unique values, and minimum or maximum values, are readily available for review. Additionally, users have the option to export their selected rows into a new file for sharing purposes or further analysis in other applications. The software also supports converting files between different formats, such as transforming CSV files into QVD format. When users choose to export to the native .dset format, their data is preserved alongside any applied filters and visualizations, ensuring that their work can be conveniently revisited later. This comprehensive approach streamlines data handling and enhances the user experience.