Article

How to query Excel files with DuckDB.

Excel files often start as simple spreadsheets and slowly become data sources. The problem is that manual filtering, formulas and copy/paste steps are hard to repeat.

Bendit makes this workflow simpler: import the Excel file, inspect the columns, write DuckDB SQL, preview the result and export a clean file.

Example

select
  trim(customer_name) as customer_name,
  try_cast(order_date as date) as order_date,
  try_cast(amount as decimal(18,2)) as amount
from imported_excel
where amount is not null;

Where Bendit fits

Bendit is a practical desktop layer around this workflow: import file, inspect columns, write SQL, preview result, export clean output.

Download Bendit →