What you're creating: with SQLite, a database is just one file on your computer (like portfolio.db) holding your tables. Where you type: a free desktop app called DB Browser for SQLite — its Execute SQL tab is where SQL like the example below gets typed, and its menus (File → Import → Table from CSV) do the importing for you. Name the imported table with a _raw suffix (the untouched original — clean into a copy later, never the original), then verify with a row count. Want the full click-by-click walkthrough? Follow the companion guide: Set Up a SQL Database for Beginners — it takes about 15 minutes, and step 1 hands you a file to download if you do not have one yet. Got a file too big for Excel? See How to Handle Large Datasets. Want a second take? This AI walkthrough answers this lesson's two recall questions in depth: CSV to Queryable Table: Steps & Verification.

Related guides