Data 9 min read
Turn a CSV or Spreadsheet Into a SQLite Database You Can Query
A spreadsheet stops being useful somewhere around the third nested VLOOKUP. Converting it to SQLite gives you real joins and real GROUP BY - and column type inference decides whether your postcodes survive the trip.
Read article