# SmoothCSV for Structured CSV Editing, SQL Queries, and Export

> SmoothCSV is a cross-platform desktop CSV editor for users who need more than a basic grid, including SQL queries, configurable parsing, comparison, transformations, and several export formats. This repository publishes releases and manages issues, but its license and source implementation are not identified here.

**kohii/smoothcsv3** — SmoothCSV is a powerful and intuitive tool for editing CSV files.

- Repository: https://github.com/kohii/smoothcsv3
- Website: https://smoothcsv.com/
- Stars: 1,353 · Forks: 20
- Language: Unknown
- License: not declared
- Published: 2026-10-16 · Updated: 2026-10-16 · Language: en
- Canonical page: https://hysenlabs.com/projects/kohii-smoothcsv3

## SmoothCSV Targets Repeated CSV Editing and Inspection

SmoothCSV addresses a specific gap between a plain text editor and a spreadsheet application. CSV files encode rows, delimiters, quoting, headers, and sometimes inconsistent values. Editing them as ordinary text gives precise control but little visual structure, while a basic spreadsheet grid may impose assumptions that do not match the file on disk. SmoothCSV presents CSV data as a spreadsheet-like grid while retaining controls over its serialization.

The intended users are people who work directly with CSV exports, tabular datasets, or files shared between systems. Its feature set includes row and column operations, multi-cell editing, filtering, sorting, aggregation, record view, and aggregation rows. It also supports SQL `SELECT` queries, visual filters, comparison between two CSV files, and import or export for `.xlsx`. These capabilities matter when a file is too large or too irregular for convenient manual editing, although the repository does not publish size limits or performance measurements.

The repository itself is not the application source tree. Its README says, "This repository is used for issue tracking and release management." That distinction is important for technical evaluation. The visible repository contains documentation, release links, contribution material, and assets, but the supplied information does not identify the implementation language or expose the internal parsing and query architecture. SmoothCSV is described as a cross-platform application, and its topics include Tauri, SQL, CSV, and spreadsheet tooling, but that topic metadata is not enough to describe the runtime structure in detail.

## Grid Editing, SQL Console, and Serialization Controls

The documented interaction model is a virtual-grid-style editor with spreadsheet conventions. Users can insert, delete, move, hide, and deduplicate rows or columns. Multi-cell editing provides a multi-cursor-like operation, while drag-fill detects patterns and drag-to-move or copy changes cell contents. A docked Cell Value View provides a separate field for the current value, and Record View turns one row into a vertical field list. Word Wrap is configurable per tab, which helps with long values that would otherwise be clipped.

Filtering can be performed with a visual condition builder or SQL-style filters. The SQL Console runs `SELECT` queries against the open CSV. The documentation does not say which SQL dialect or query engine is used, so query compatibility should not be inferred from the SQL label alone. The same restraint applies to transformations such as joins, splitting, casing conversions, transpose, and text replacement with regular expressions. The README confirms that these operations exist, but it does not define their edge-case behavior.

CSV serialization receives unusually detailed attention. Per-file settings can define delimiters, quotes, encoding, line endings, and flexible quote rules for headers, body rows, and individual columns. Quote Indicators show which cells will be quoted when saved. Render Whitespace marks spaces with a dot, making doubled spaces, trailing padding, and full-width spaces visible. File Format Presets and Rules can apply custom formats automatically. These controls matter because a visually correct grid can still produce a changed file if quoting or delimiters are applied differently. Copy with Options also controls delimiter, quoting, column names, alignment, indentation, and table name, with a live preview and named presets.

## Download and Complete a First CSV Editing Session

SmoothCSV does not document installation from a package manager, source tree, or command line in this repository. The README directs users to the GitHub Releases page for the latest version. Because the release assets are not listed here, the article cannot name an operating system package, command, checksum, or installation command without guessing.

Download the installer for the target operating system from the linked releases page. The README does not provide silent-install flags or documented post-install commands, so there is no reliable command to reproduce here. After installation, open a `.csv` file and inspect the grid before editing it. The grid is the primary interface documented by the project, and the README points to the website and the `docs` directory for additional documentation.

For a first substantive use, select a column and apply a sort or filter, then inspect the result against the original values. Enable Render Whitespace when the file contains padded text. Use the SQL Console only for a `SELECT` query, because the documentation does not claim support for data-changing SQL. Before saving a copy, check Quote Indicators and the configured delimiter, quote rules, encoding, and line endings. This sequence verifies both the editing operation and the file serialization without requiring assumptions about undocumented menus or defaults. The README also lists Auto-backup before overwriting, but does not document backup retention, storage location, or restore behavior.

## CSV Comparison, External Changes, and Read-Only Handling

SmoothCSV includes CSV Compare for identifying differences between two files, while Diff viewer is listed as a completed future plan. The distinction suggests that CSV Compare and a broader diff viewer should not be treated as the same feature. The documentation does not describe the comparison algorithm, whether it displays cell-level or line-level differences, or how it handles reordered columns.

Auto-Refresh reloads a file after external modification. Read-Only Mode reduces the risk of accidental changes, and Auto-backup creates a copy before overwriting. These controls address different failure modes. Auto-Refresh is relevant when another process changes the file, Read-Only Mode protects against editing, and Auto-backup protects against an overwrite. None of them is documented as a transactional system.

External edits can still create a practical conflict. The documentation does not state whether an unsaved grid change blocks reload, prompts before replacement, or can be merged with the changed file. It also does not document recovery when a file disappears, encoding cannot be decoded, or a custom quote rule produces an invalid result. Users who edit the same CSV through multiple applications should verify Auto-Refresh behavior with a disposable copy rather than assuming conflict handling exists.

Open Hyperlinks can launch URLs found in cells. This is convenient for URL columns, but it also means cell contents should be treated according to the application's link-opening behavior. The README does not describe URL validation, confirmation prompts, or schemes that are rejected.

## Extension Plans and Unsupported Data Formats

The project has clear boundaries around future functionality. Browser availability, an extension system, CSV schema and validation, additional formats such as JSON, Avro, and Parquet, and AI assistance are all unchecked plans in the README. They should not be presented as available capabilities. The existing SQL Console is for querying CSV data, not for importing arbitrary database connections or executing schema-changing operations.

The lack of documented schema validation is a significant limitation for workflows that depend on column types, required fields, or accepted values. SmoothCSV can detect or set headers, sort text, numbers, dates, and lengths, and it can calculate sums, averages, minimums, maximums, and counts. Those operations do not establish that it validates a CSV schema before editing or export.

Join and Split operations may also require careful review for files with nested delimiters, multiline cells, or inconsistent quoting. The README does not specify whether joins preserve original field contents, how duplicate column names are resolved, or whether split operations can be reversed. A visual tool can make these operations easier to perform without eliminating ambiguity in the underlying data. The SQL feature has a similar boundary: its presence is documented, but its engine and full syntax are not.

For teams that need a browser editor, plugin architecture, schema enforcement, or formats beyond `.csv` and `.xlsx`, SmoothCSV's roadmap does not currently meet those requirements. The absence of a documented extension system also means that custom parsing or validation cannot be assumed to fit into the application through plugins.

## Release Cadence, Licensing, and Upgrade Cost

The repository is not archived, and the last push was on 2026-09-23. Recent releases include `v3.25.1` on 2026-09-21, `v3.25.0` on 2026-09-12, and `v3.24.0` on 2026-08-16. Those dates indicate recent repository and release activity, but the README does not provide a compatibility policy, migration guide, changelog format, or upgrade procedure. The repository is primarily for issue tracking and release management, so an upgrade may be delivered through a downloaded installer rather than through source changes visible here.

The README links to a licensing purchase page and says that buying a license supports continued development. However, the repository information does not identify a license identifier. Consequently, this article cannot confirm the distribution terms, whether source code is available under an open source license, or whether the commercial license changes with upgrades. Users should inspect the terms associated with the downloaded release and the licensing page before organizational deployment.

Upgrade cost is therefore partly operational. Users must obtain the new release, confirm that saved file-format presets and custom keyboard shortcuts remain available, and verify that files containing custom quoting, encoding, or line-ending rules still save correctly. The documentation does not state whether presets can be exported or backed up independently.

## Conclusion

SmoothCSV fits users who repeatedly edit, inspect, compare, query, or export CSV files and want control over delimiters, quoting, encoding, and line endings. It is less suitable for users who require an open source license, a documented extension system, or repository-based builds, because none of those details are established by this repository. Before adoption, download the release for the target operating system, inspect its commercial licensing terms at smoothcsv.com, and confirm that its SQL and custom file-format behavior matches the datasets you need to process.

## FAQ

### How do I install SmoothCSV?

The README directs users to the project's GitHub Releases page for the latest version. It does not document installation through a package manager or provide commands in this repository.

### Can SmoothCSV run SQL against a CSV file?

Yes. The documented SQL Console runs `SELECT` queries on CSV files, and SmoothCSV also provides SQL-style filters. The README does not identify the SQL dialect or query engine.

### Does SmoothCSV support JSON, Avro, and Parquet files?

Not as documented current features. JSON, Avro, and Parquet appear in the README under future plans, while the listed current formats focus on CSV and `.xlsx`.

### Can SmoothCSV customize CSV delimiters and quoting?

Yes. The README documents per-file delimiters, quotes, encoding, line endings, quote rules by header, body, and column, plus File Format Presets and Rules. Quote Indicators show which cells will be quoted when saved.

### Is SmoothCSV open source?

The repository information does not identify a license identifier or provide enough licensing terms to classify it as open source. The README links to a purchase page, so the terms should be checked before adoption.

## Sources

- [Issues](https://github.com/kohii/smoothcsv3/issues)
- [kohii/smoothcsv3 on GitHub](https://github.com/kohii/smoothcsv3)
- [Project website](https://smoothcsv.com/)
- [README](https://github.com/kohii/smoothcsv3/blob/main/README.md)
- [Releases](https://github.com/kohii/smoothcsv3/releases)

---

Hysen Labs editorial analysis, written from the project's own repository and release notes. Cite the canonical page: https://hysenlabs.com/projects/kohii-smoothcsv3