TSV to SQLITE
Turn TSV spreadsheet files into SQLite database files on your own Mac, Windows or Linux computer. Asteria is free, works offline, and never uploads your files.
How to do it
- Download Asteria and open it. It's free and needs no account.
- Drop your TSV files onto its window, or press ⌘O (Ctrl O on Windows) to choose them. Drop as many as you like.
- Type csv to sqliteand press Enter. A database with one table and typed columns.
- Press ⌘↵ (Ctrl ↵ on Windows) to save. The SQLITE files appear next to the originals, which stay exactly as they were.
What it needs
Nothing. This conversion is built into Asteria, so it works the moment the app is open, even offline.
How it was tested
A real TSV file was converted on macOS on Apple silicon and Linux, and the SQLITE that came out was opened and checked with Python sqlite3 to make sure it is what it says it is.
Download Asteria
Free for Mac, Windows and Linux. Other systems and first-launch help