Use case

Clean messy Excel files locally with DuckDB.

When an Excel file has inconsistent dates, merged-looking data, empty rows, bad number formats or manual fixes hidden everywhere, Bendit gives you a repeatable SQL-first cleanup workflow.

Typical cases

• Supplier exports with odd headers
• Finance files with decimal commas and text amounts
• Operational sheets with blank rows and inconsistent dates

Example SQL

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

How Bendit helps

1. Import the file directly into the local workbench.
2. Inspect columns, types and preview rows.
3. Transform with DuckDB SQL.
4. Export a clean CSV or Parquet result.