Create, store, and manage reference tables inside your Excel workbooks. Build formulas and dropdowns in seconds, not minutes.
Up and running in under a minute
Add columns and rows manually, or import directly from an existing range in your workbook.
Use the Formula Builder to generate XLOOKUP, INDEX-MATCH, or VLOOKUP formulas — no memorising syntax required.
Create dropdown lists from any column in your reference tables with one click.
Push reference tables to visible Excel Tables on any sheet, and keep them in sync as your data evolves.
Every feature is designed to save you time on repetitive lookup tasks
Create tables, add rows, import from ranges, edit inline, and delete — all from the task pane without switching context.
Generate native XLOOKUP, INDEX-MATCH, or VLOOKUP formulas that reference published Excel Tables. Choose your formula style.
Build dropdown lists from any reference table column. Apply them to single cells or entire ranges instantly.
Publish reference tables as native Excel Tables on your worksheets, and synchronise changes back when data is updated.
Select any range on a worksheet and import it as a new reference table, or export table data back out to a range.
All data is persisted in the workbook via the Excel Settings API. Your tables travel with the file — no external database needed.
Start free, upgrade when you need more
Store your reference data once, use it everywhere in the workbook. Try Reference Table Manager today.
Get It on AppSource