Open a command prompt in your SQLite directory. Download the 'bundle of command line tools' for your operating system from the downloads page.Įxport both spreadsheets as CSV files and put them in the same directory as the SQLite exes you downloaded - it's just easier to reference in our examples without having to use fully-qualified paths. Import the Data into SQLiteįirst you need to download SQLite. Which email addresses exist in both? We'll figure it out quickly with SQLite. Here are two spreadsheets with fake data in them. It's even easy to script using Powershell. It's very popular and is often used as a file format. SQLite is fast, self-contained, lightweight, and is file-based. Stop looking at Excel formula reference websites and instead use the SQL statements that you already know and love. I find it easier to export my spreadsheets as CSV files, import them into SQLite, and run regular old sql queries. But I'm ditching it in favor of plain old sql. It's finicky and I feel like it never works right. I'm often asked to find rows in one list that aren't in another list (or some similar task) and I spend too much time with vlookup as a result.
