Can I connect Excel spreadsheets to iDBQuery?
Yes. iDBQuery reads Excel spreadsheets directly — upload an .xlsx file and it detects sheets, headers and data types, then lets you ask questions in plain language. Your spreadsheet becomes a queryable source you can blend with databases and other files, with cited answers throughout.
Excel is a fully supported source in iDBQuery. You upload your workbook and iDBQuery parses each sheet, identifies headers, infers column types, and turns the data into a queryable model — no formulas to rewrite and no manual schema definition.
- Multi-sheet support — every sheet in the workbook becomes available to query.
- Automatic typing — dates, numbers, currency and text are detected so aggregations and filters just work.
- Plain-language questions — ask things like "total revenue by region last quarter" and iDBQuery writes the query, runs it, and cites the exact rows behind the answer.
- Blend with everything else — your spreadsheet can be joined to MySQL, Postgres, MongoDB, CSVs, PDFs and APIs in one live model.
This turns a static spreadsheet into something you can interrogate conversationally, build charts and live dashboards from, and include in shareable reports. A common pattern is to combine an Excel budget with figures pulled from a database to reconcile or forecast. Because every answer is cited, you can always trace a number back to the precise cell it came from.
Updated 2026-06-22