Ad hoc analysis for audit & compliance

Spreadsheet simplicity.
Database power.
AI insight.

Open CSVs, Excel exports, and live Oracle or MySQL tables side by side — then filter, join, and pivot the whole population in seconds. Describe the test in plain English and the answer lands on screen as a table you can keep working in.

Book a 30-minute call Read the overview

Windows desktop · reads Oracle, SQL Server,
MySQL, CSV, XLS and HTML tables

Tabular IQ analysing an AP audit project: Ap_hist joined to Vend_mast with the SQL console open

Ap_hist × Vend_mast → 15-row vendor summary · 0.16 s

0.16 s

Grouped vendor summary across two joined tables

Billions

of rows per table — no file size limitation

formats open at once, linked like one database

ETL requests, import projects, or waiting

01 — The reason to switch

AI analysis that runs against your live data

Describe what you want in plain English. Tabular IQ builds the query, runs it against your live data, and puts the result on screen. Not quite right? Say so, and watch it adjust. Each answer is a starting point for the next question.

01 Build filters and formulas from a plain English description

02 Shape pivots and joins across files and databases

03 Reconcile datasets with AI-assisted matching

Console — AI ap_hist · live

> Show me payments where the same amount went to two different vendor IDs in the same week

Done. I joined the payment table to itself on amount and week, kept rows where the vendor IDs differ, and put the result on screen. 14 pairs found.

> Pivot those by vendor and month

Here is the pivot. Two vendors account for 11 of the 14 pairs, all in March.

02 — Capabilities

Real analysis rarely starts with clean data in one system

It starts with a CSV from one department, an Excel export from another, and a database you are only allowed to read. Tabular IQ opens them all side by side, links them like tables in a single database, and lets you filter, group, and pivot across the whole population instead of a sample.

01 Direct Data Access

Plug and play for data — no staging, no conversion step.

Open CSV files directly from the web

Import HTML tables with a single click

Link to data in MySQL and Oracle

Bookmark data files for easy access

02 Instant Analytics

Answers in a snap, against the full population.

Create ad hoc calculations instantly

Match related records from different files

Integrate data dynamically

Filter or search for data with a click

03 Simple Reporting

Turn the finding into a document worth circulating.

Lay out data as easily as in a spreadsheet

Create quick reports in a single step

Print directly from MySQL and Oracle

Save reports in PDF format

03 — Performance

Built for heavy lifting

Designed for data usability, not data management. Freedom from file size limitations, with billions of rows per table.

Pivot and group millions of rows in seconds

Grouping is interactive, so the next question costs nothing.

Join files and exports with live database tables

A CSV, an Excel export, and an Oracle table, treated as equals.

Clean and standardize messy fields

Built-in functions for the reformatting every dataset needs first.

Automate repeat analysis with scripting

Run the same test next quarter without rebuilding it.

04 — Who it is for

Built for analysts, IT, and internal audit

Tabular IQ™ is an ad hoc data analysis and reporting tool built for people who work with, manipulate, and analyze structured data — from business analysts and IT professionals to internal auditors.

Access data from anywhere (Oracle, SQL Server, CSV, XLS, etc.)

Freedom from file size limitations (billions of rows per table)

Speed, flexibility, and agility — designed for data usability, not data management

05 — Feature set

Everything serious data work demands

Open huge tables instantly, relate data across sources, calculate, group, and report — all without waiting on an import project.

Access Data from Anywhere

Oracle, SQL Server, MySQL, CSV, XLS and HTML tables.

Rich Data Environment

Many tables open at once, kept side by side on one screen.

Built-In Database

A local engine for tables that outgrow a spreadsheet.

Report Writer

Lay out data as easily as a spreadsheet, then save to PDF.

Dynamic Calculations

Ad hoc columns and formulas, evaluated against live data.

Group Analyzer

Group and pivot millions of rows in seconds.

Data Relationships

Link files, exports and tables like one database.

Query Builder

Compose filters and joins without hand-writing SQL.

Data Bookmarks

Save the files and connections you come back to.

Custom Extensions

Script repeat analysis when you need it automated.

A CSV, an Excel export, and an Oracle table open together in Tabular IQ

06 — Every format

Bring every format into one view

The hardest part of most analysis is not the analysis. It is that the data lives in five places and four formats. Tabular IQ treats a CSV, an Excel export, and an Oracle table as equals: open them together, match and reconcile records across them, and summarize the result.

The work that used to mean an ETL request and a week of waiting happens in one afternoon, on your own desktop.

See Tabular IQ against your own data

The fastest way to judge a power tool is to hand it your hardest file. Pick a 30-minute slot and bring one — we will open it live.

Book a 30-minute call Start with the overview

Or reach us directly

support@tabulariq.com

Phone

+49 7031 925 2650

Address

fopen GmbH
Gartenstr. 12, 71155 Altdorf, Germany

Spreadsheet simplicity.Database power.AI insight.