Asteria

CSV to SQLITE

Turn CSV 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

  1. Download Asteria and open it. It's free and needs no account.
  2. Drop your CSV files onto its window, or press ⌘O (Ctrl O on Windows) to choose them. Drop as many as you like.
  3. Type csv to sqliteand press Enter. A database with one table and typed columns.
  4. 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 CSV 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.

More from CSV

More to SQLITE