A spreadsheet gets slow and awkward once a CSV has many thousands of rows and you want totals, filters or joins. SQL is made for those questions, and you do not need to install and configure a database server to use it. Here are three simple ways, using an example file called orders.csv with the columns order_id, customer, category, amount and order_date.

Option 1: SQLite command line

SQLite can import a CSV into a temporary database in a few commands.

sqlite3 :memory: .mode csv .import orders.csv orders .headers on SELECT category, SUM(amount) AS total FROM orders GROUP BY category ORDER BY total DESC; 

Note that every imported column starts as text, so cast numbers when you calculate, for example SUM(CAST(amount AS REAL)).

Option 2: DuckDB

DuckDB can query a CSV file directly, without an import step.

SELECT customer, COUNT(*) AS orders FROM 'orders.csv' GROUP BY customer HAVING COUNT(*) > 3 ORDER BY orders DESC; 

DuckDB detects column types automatically, which saves the casting step.

Option 3: In the browser

If you only have a file and want a quick answer, a browser tool that runs SQL on a CSV is the fastest route, because there is nothing to install.

Three queries worth knowing

-- Monthly totals (SQLite) SELECT substr(order_date, 1, 7) AS month, SUM(amount) AS total FROM orders GROUP BY month ORDER BY month; -- Duplicate order ids SELECT order_id, COUNT(*) AS copies FROM orders GROUP BY order_id HAVING COUNT(*) > 1; -- Top 5 customers by spend SELECT customer, SUM(amount) AS spend FROM orders GROUP BY customer ORDER BY spend DESC LIMIT 5; 

Before you start

  • Check the delimiter and the encoding of the file first.
  • Make sure the header row has clean column names without spaces.
  • Keep dates in one format, such as YYYY-MM-DD, so that sorting works.

Disclosure: I work on SnipFerry, a set of free browser-based JSON, CSV and SQL tools (https://snipferry.com). The commands above work with SQLite and DuckDB on your own machine.