Pricing Free
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
By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of AppSource is governed by separate terms and privacy.