Not bad. Here is the Windows equivalent with Excel separator: PS> gsudo choco install sqlite3 PS > sqlite3 sqlite> .mode csv sqlite> .separato

Not bad. Here is the Windows equivalent with Excel separator: PS> gsudo choco install sqlite3 PS > sqlite3 sqlite> .mode csv sqlite> .separator ; \n sqlite> .import my.csv foo sqlite> SELECT * FROM foo WHERE name = 'bar'; For CSV that contain up to several 100k records native PowerShell solution is way faster and more practical: Get-Content my.csv | ConvertFrom-Csv | ? name -eq bar FYI, I maintain miller choco package: https://community.chocolatey.org/packages/miller https://community.chocolatey.org/packages/miller