DuckDB logo

DuckDB in Excel!

xlSlim now supports running DuckDB queries right in Excel using the new DuckDbQuery() Excel function.

DuckDB is a very powerful query engine that supports efficient querying from many data sources - csv files, json files, databases, etc. DuckDB allows disparate data to be easily filtered, joined and pivoted. Data can be read from local and remote (https, S3, etc) sources. See the docs for details of DuckDB's functionality.

 

 

 This new functionality was used to analyse the well-known NYC taxi data set in Excel:

 

 

Back to blog

Leave a comment