New Features
Smarter Multi-row Headers 🏷️
SmoothCSV now handles tables with more than one header row much better. Stacked headers (a column-name row followed by extra rows for types or annotations) and hierarchical headers (e.g., 2026 spanning count, sum, avg) are detected automatically, with column names taken from the right rows.
You can also pick column-name rows yourself: select rows in the row-number context menu and run Use Selected Row(s) as Column Names. Combined headers like 2026 / count are generated automatically when you pick multiple rows.
Paste Transpose 🔄
The Paste As submenu has a new Paste Transpose command. Rows in the clipboard become columns (and vice versa) when pasted, like Excel's "Paste Special > Transpose".
Related issues: #206
Reference Open Files by Name in SQL
SQL queries can now reference an open file by its filename without the extension. Previously you had to use the full reference:
-- Before
SELECT * FROM "@file:/Users/me/data/customers.csv" WHERE region = 'JP';
-- Now
SELECT * FROM customers WHERE region = 'JP';Lookup is case-insensitive and only matches currently open documents. The @file:... and @untitled:... forms still work and remain the way to reference closed files or to disambiguate when more than one open file shares the same name.
Related issues: #207
Improvements
- More accurate header auto-detection - Headers are now detected more reliably in small tables where the header row and the first data row look similar in shape. (#209)
- SQL Console remembers the last save folder - The
Save to Filedialog now opens at the folder you picked the previous time. (#212) - Auto-backup for SQL Console results - Saving SQL Console results to an existing file now creates a backup first, so you can recover the previous version with
Restore from Backupif needed.
Bug Fixes
- Fixed SQL queries (Filter, Sort, SQL Console) failing when a column name contained a double-quote character.
- Fixed SQL Console's
Insert Table NameandInsert Column Namebuttons placing the cursor before the inserted text instead of after. (#211) - Fixed opening a file via OS file association not restoring the window when it was minimized. (#210)
- Fixed the title bar not responding to mouse dragging or double-click on Windows with older WebView2 runtimes. (#208)
- Other minor bug fixes and improvements.