A database, not a spreadsheet BASE
Records with typed fields, a row editor, saved views with filters and sorting, CSV import that shows its reasoning, and export that reads back.
Tables
Every column has a type, and the grid can say no to anything that does not fit.
Import a CSV
Each column's type is guessed and the reason shown. Nothing is committed until you have looked.
Drop a .csv here, or
What each column was taken to be
Table
Columns, sorting and filters
Columns
Add a column
Sort
Filters
How it works
BASE is a small database in your browser. Unlike a spreadsheet, where any cell can hold anything, every column has a type, such as text, number, date or a choice from a list, so records stay consistent. Edit rows in the grid or a form, save views with filters and sorting, import a CSV with each decision shown, and export a file that reads back in. Everything is stored on this device, with no account.
Doing this often? OBSCURA Pro saves the tables you keep here, along with the result of every other tool outside the Workspace, and includes the paid applications. Everything is US$9 a month or US$79 a year, 7 days free.