Excel is still the final mile for most business data. EQQ understands this: every result grid has a one-click Export → Excel that preserves column types, dates, and your active sort order.

What you get in the .xlsx

  • Typed columns - numbers stay numeric, dates stay dates.
  • Frozen header row with the filter dropdowns Excel users expect.
  • Auto-fit column widths.
  • Metadata sheet with query name, user, run time, and parameter values. Perfect for audit attachments.

Large result sets

Excel caps at 1,048,576 rows per sheet. EQQ handles larger results in two ways:

  1. Pagination - split across multiple sheets automatically.
  2. Background job - if the run is predicted to exceed a threshold, EQQ queues it as a background task, then notifies you when the download is ready.
After a query runs, the result grid offers Excel / CSV / JSON export.
After a query runs, the result grid offers Excel / CSV / JSON export.

Formatting tips for polished exports

  • Set column labels in the query designer - they become the Excel headers.
  • Use EQQ functions like fQQ_FormatCurrency to pre-format numbers before export.
  • For repeatable cuts, save a View with the right columns and order, then reuse.

Want to see it live? Book a 30-minute demo - we connect EQQ to your database and build a query with you. Book a Demo →