Reference Table Manager
by FATIMODE
Create, manage, and look up reference tables in Excel. New: Optional AI-powered dataset analysis.
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.
App capabilities
- Can read and make changes to your document
- Can send data over the Internet