Reference Table Manager

Reference Table Manager lets you create, manage, and look up reference tables stored directly inside your Excel workbooks — no external database needed.

NEW IN v1.5: AI-POWERED DATASET ANALYSIS

Click "Analyse Dataset" and let AI scan your worksheet to identify columns that should be extracted as reference tables. The analyser detects code-to-description pairs (like "AU" → "Australia"), low-cardinality categorical columns (statuses, regions, categories), and multi-column entity groups that belong together. Each suggestion comes with a confidence score and a one-click "Create in RTM" button.

- FREE users get rule-based analysis at no cost

- PRO users get 5 AI-powered analyses per day

- ENTERPRISE users get unlimited AI analyses

CORE FEATURES

- Create reference tables: Define lookup tables with column headers, data types, primary keys, and mandatory fields — stored inside your workbook

- Formula builder: Insert VLOOKUP/XLOOKUP/INDEX-MATCH formulas that reference your tables, with configurable "value not found" behaviour

- Data validation dropdowns: Apply dropdown lists from any reference table column to worksheet cells

- Sheet Sync: Publish tables to formatted Excel Tables and keep them synchronised

- My Tables library: Save and share table templates across workbooks

VIRTUAL TABLES (v1.4+)

- Connect to live JSON/CSV data from any HTTPS URL, OneDrive, or SharePoint

- Add custom calculated columns alongside source data

- Saved feeds and pinned versions for SCD Type 2 workflows

AI DATASET ANALYSIS (v1.5 — NEW)

- Scans formatted Excel Tables or raw worksheet data

- Detects reference table candidates using AI (Azure OpenAI) and rule-based heuristics

- Suggests table names, primary keys, mandatory columns, and estimated row counts

- One-click creation directly into RTM

- Powered by Azure OpenAI — your data is never used for model training

TIERED PRICING

- FREE: 3 tables, 50 rows each, rule-based analysis

- PRO: 50 tables, 10,000 rows, 5 AI analyses/day, virtual tables, custom columns

- ENTERPRISE: Unlimited everything, priority support

Works on Excel for Windows, Mac, and Web.