Skip to content

Releases: kohii/smoothcsv3

v3.0.0-beta.5

17 Feb 10:11
Compare
Choose a tag to compare

New Features

Filter by Selected Values 🎯

CleanShot 2025-02-14 at 08 27 26

Quickly filter rows using values in selected cells:

  • Select cells containing the values you want to filter by
  • Use context menu or Command Palette to select Filter Rows by Selected Values

Date/Time Types in SQL 📅

CleanShot 2025-02-14 at 08 12 09@2x

Support date/time types in SQL queries:

  • DATE
  • TIME
  • TIMESTAMP
  • INTERVAL

See SQL in Row Filter for details.

Copy selected cells as SQL INSERT statements.

Reveal in Finder/Explorer 🔍

Reveal the current file in Finder/Explorer from the context menu.

Copy as SQL Insert 📋

Improvements

Find Performance ⚡️

Optimized performance by deferring the calculation of search results until actually needed, instead of recalculating positions and counts on every keystroke.

Keyboard Shortcuts Updated ⌨️

Updated several keyboard shortcuts to be more intuitive:

Action New Shortcut (Windows) New Shortcut (macOS) Previously
Insert Row Below Ctrl+Enter Cmd+Enter -
Insert Column Right Ctrl+Shift+Enter Cmd+Shift+Enter -
Delete Selected Row Ctrl+Backspace Cmd+Backspace Ctrl+K
Delete Selected Column Ctrl+Shift+Backspace Cmd+Shift+Backspace Ctrl+Shift+K
Open Filter Widget Ctrl+Shift+F Cmd+Shift+F Ctrl+Alt+F

Default CSV Format 📄

Updated the default CSV format to conform to RFC 4180 specifications, ensuring better compatibility with other applications.

Bug Fixes

  • Fixed: Focus not returning to grid after closing filter widget
  • Fixed: Tab label not updating when saving as new file
  • Other minor bug fixes and improvements

Download

v3.0.0-beta.4

28 Jan 09:10
Compare
Choose a tag to compare

New Features

Filter Rows via SQL 🔎

406651713-62957811-cc76-4a86-bf81-23536a5bc852

Filter rows using SQL queries. By Apply Filter, non-matching rows are hidden.
You can also choose other actions:

  • Delete Non-Matching Rows
  • Delete Matching Rows
  • Extract Matching Rows to New Document

To filter rows,

  • use Ctrl+Alt+F (macOS: Cmd+Alt+F)
  • select Grid > Filter from the menubar
  • open the Command Palette (Ctrl+Shift+P or Cmd+Shift+P on macOS) and search for "Filter,"

For SQL specification, see SQL in Row Filter.

Hide/Show Rows/Columns 👀

Hide or show rows/columns via the context menu or Command Palette.
You can also delete all hidden rows/columns.

Move Rows/Columns ↕️

Move rows and columns using the context menu, Command Palette, or keyboard shortcuts:

  • Move Row Up: Ctrl+Shift+Alt+Up (macOS: Cmd+Shift+Alt+Up)
  • Move Row Down: Ctrl+Shift+Alt+Down (macOS: Cmd+Shift+Alt+Down)
  • Move Column Left: Ctrl+Shift+Alt+Left (macOS: Cmd+Shift+Alt+Left)
  • Move Column Right: Ctrl+Shift+Alt+Right (macOS: Cmd+Shift+Alt+Right)

Transform to Full-width/Half-width Characters 🔤

Transform selected cells to full-width or half-width characters.

Deduplicate Rows 👯

  • Deduplicate rows based on selected columns.
  • You can also clear duplicate cells in a selection.

Improvements

Extension Filter on Save (Windows) 💾

You can now filter the extension list in the Save dialog.
The selected extension will be automatically appended to the filename when saving.

Show error message when the file is too large to open

Previously, no rows were shown when opening a very large file (536,870,888 chars+) in Windows.
It will take a while to fix this issue.

Bug Fixes

  • Fixed: Error when there is no row/column.
  • Disabled auto text substitution on macOS. (Previously, " was automatically replaced with on macOS.)

Download

v3.0.0-beta.3

22 Dec 23:29
Compare
Choose a tag to compare

New Features

Auto Fill 📊

Fill cells with sequential data by dragging the fill handle:

  • Drag to extend series numbers
  • Double-click fill handle to auto-fill to the bottom
  • Works with both numeric and text patterns

Custom Delimiter Support 🔧

Specify any character as a delimiter when opening or saving CSV files:

  • Support for arbitrary delimiter characters
  • Enhanced delimiter auto-detection (| and : now supported)
  • Configure delimiter in CSV file format dialog

Mnemonic Shortcuts (Windows) 🔑

SmoothCSV now supports mnemonic keys for Windows to navigate menus. Alt key to focus on the menu and then press the underlined letter key to select the menu item.

Improvements

Enhanced Performance and Usability 🚀

  • Optimized rendering for large CSV files
  • Improved Command Palette filtering algorithm
  • Additional zoom shortcuts:
    • Zoom in: Ctrl+NumPad+, Ctrl+Shift+-
    • Zoom out: Ctrl+NumPad-

Bug Fixes

  • Fixed: Scroll position now maintains state when switching between tabs

Download

v3.0.0-beta.2

27 Nov 09:55
Compare
Choose a tag to compare

New Features

Zoom Control 🔍

You can now adjust the zoom level in SmoothCSV using:

  • View > Zoom In (+20%)
  • View > Zoom Out (-20%)

Keyboard shortcuts:

  • Zoom in: Ctrl+= (macOS: ⌘=)
  • Zoom out: Ctrl+- (macOS: ⌘-)
  • Reset zoom: Ctrl+0 (macOS: ⌘0)

Italian Localization 🌍

SmoothCSV now includes Italian language support, thanks to @lzambarda's contribution.

Copy as JSON 📤

New feature to copy selected data as JSON:

  • Array of objects (column headers as keys)
  • Array of arrays (raw data)

Bug Fixes

  • Fixed: "Quit" menu item now properly detects unsaved changes on macOS
  • Removed: Redundant Quote when: Never option from CSV format dialog
    • Users can achieve the same result by not specifying a quote character

Other Updates

Download

v3.0.0-beta.1

13 Nov 09:31
Compare
Choose a tag to compare

Important

  • This release changes the application name from "SmoothCSV 3" to "SmoothCSV".
  • For macOS, the application is now distributed as a single universal binary that runs natively on both Apple Silicon and Intel-based Macs.

New Features

Multiple Language Support 🌐

SmoothCSV now supports multiple display languages. The application interface is available in:

  • English
  • 中文(简体) - Simplified Chinese
  • Español - Spanish
  • 日本語 - Japanese

The display language automatically matches your operating system's language (when supported). To manually change the language:

  1. Open the Command Palette
  2. Search for "Configure Display Language"
  3. Select your preferred language
  4. Restart the application

Automatic Updates 🔄

CleanShot 2024-11-04 at 09 45 50@2x

SmoothCSV now includes automatic update checking and notifications for new versions.

Case Transformation ⬆️⬇️

CleanShot 2024-11-03 at 14 21 41@2x

Transform selected cells to various text cases:

  • Transform to Uppercase
  • Transform to Lowercase
  • Swap Case
  • Transform to Camel Case
  • Transform to Pascal Case
  • Transform to Snake Case
  • Transform to Kebab Case
  • Transform to Title Case

Cell Fill Operations ⬇️

CleanShot 2024-11-04 at 11 15 19

Quickly populate cells using values from adjacent cells:

  • Fill Down: Ctrl+D (macOS: ⌘D)
  • Fill Up: Ctrl+Shift+D (macOS: ⌘⇧D)
  • Fill Right: Ctrl+R (macOS: ⌘R)
  • Fill Left: Ctrl+Shift+R (macOS: ⌘⇧R)

Improvements

Refreshed Branding 🎨

macos-icon@2x

  • New modern application icon

Smoother macOS Installation 🔒

  • Application is now signed with an Apple Developer ID certificate
  • Eliminates the need for manual security bypass commands (e.g., xattr -r -d com.apple.quarantine "/Applications/SmoothCSV.app")

Enhanced Regular Expression Support 🔍

Added support for additional replacement patterns:

  • ${n}: Reference the nth capturing group
  • $&: Reference the entire match
  • $$: Escape the dollar sign

Bug Fixes

  • Fixed "Save" functionality when opening files from Finder/Explorer
  • Resolved "Save As..." issues on Windows
  • Fixed Open... command (⌘O) functionality
  • Other minor bug fixes

Download

v0.1.0-alpha.5

17 Oct 12:56
Compare
Choose a tag to compare

New Features

Windows support

Go to row/column (Ctrl+G)

Improvements

  • Add file extension "csv" by default on save dialog
  • Add help menu

Bug Fixes

  • Remove duplicated menu items on the context menu
  • Other minor bug fixes

For installation instructions, please refer to this page.

https://github.com/kohii/smoothcsv3?tab=readme-ov-file#download

v0.1.0-alpha.4

08 Oct 09:23
Compare
Choose a tag to compare
v0.1.0-alpha.4 Pre-release
Pre-release

SmoothCSV v0.1.0-alpha.4

This release mainly focuses on improving the performance of rendering for large files and adding some new features.
See this blog post for technical details:

New Features

  • Page up, Page down key to scroll
  • Copy and paste in Markdown table format
  • Auto-fit width for selected columns

Improvement

  • Improve the performance of scrolling and rendering (Especially for large files)
  • Improve the performance of writing large files

Bug Fixes

  • Fix the bug rows after 1,525,200 cannot be scrolled
  • Other minor bug fixes

For installation instructions, please refer to this page.

https://github.com/kohii/smoothcsv3?tab=readme-ov-file#download

v0.1.0-alpha.3

27 Sep 10:53
Compare
Choose a tag to compare
v0.1.0-alpha.3 Pre-release
Pre-release

New Features

Sorting

  • Sort from the column context menu
  • Advanced sorting options
  • You can also sort only the selected rows or cells.

Copy/Paste using File Format

Normally, data is copied and pasted using tab-delimited formatting for compatibility with Excel and Google Sheets.

Copy File Path to Clipboard

Improvements

  • Improved the performance of the CSV parser
    • Especially for large files over 200MB, where parsing time has been reduced to less than half.

Bug Fixes

  • Fixed an issue where the layout of the cell editor would become unstable
  • Other minor bug fixes

For installation instructions, please refer to this page.

https://github.com/kohii/smoothcsv3?tab=readme-ov-file#download

v0.1.0-alpha.2

19 Sep 10:53
Compare
Choose a tag to compare
v0.1.0-alpha.2 Pre-release
Pre-release

New Features

  • Header rows and columns can now be frozen

Improvements

  • Improved performance when scrolling through large files
  • Scrollbar is now always visible in the editor
  • Improved automatic encoding detection

Bug Fixes

v0.1.0-alpha.1

11 Sep 13:04
Compare
Choose a tag to compare
v0.1.0-alpha.1 Pre-release
Pre-release

Initial release