https://store-images.s-microsoft.com/image/apps.31333.238a915b-46ef-4e8d-bcee-534ce19701b0.5cbbc2df-587f-4d1a-ab7a-ce53b5ed67ad.d0722e9d-111a-40d1-95d9-ba53fe238ebc.png

SQLookup

by Zoomer Analytics GmbH

The SQLOOKUP function allows you to query data in your Excel workbook using SQL (SQLite dialect).

SQLookup is an Excel add-in that gives you access to the SQLOOKUP function. The SQLOOKUP function allows you to query data in your Excel workbook using SQL (SQLite dialect). The add-in is free and works with Excel on Windows, macOS, and web. Here's an example query:

=SQLOOKUP("SELECT * FROM a", A1:B10)

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://store-images.s-microsoft.com/image/apps.42149.238a915b-46ef-4e8d-bcee-534ce19701b0.5cbbc2df-587f-4d1a-ab7a-ce53b5ed67ad.6f321be6-1099-411f-9911-6758750ee2c6.png