English is the formal text of this page. A 繁體中文 reference translation is available.

Megizi Studio

DataMatch

No-code Excel lookup & matching workspace

Bring chosen columns back from a lookup table into your main table, without writing formulas.

Processed entirely on your device — your data stays private

This app never uploads your files. No account is needed.

How it works

1. Import two tables. Add the main table (it receives new columns) and the lookup table (it holds the values to bring back). One Excel or CSV file each.
2. Set up the lookup. Choose the key column in each table and the columns to bring back from the lookup table. Keys must match exactly.
3. Choose which rows to keep. Keep all main rows (unmatched cells stay empty), or keep matched rows only.
4. Check, then export. Preview the result, then save it as Excel or CSV. The result keeps the main table’s row order.

Free and Pro

Free exports up to 200 rows per output table. Pro removes that limit. Everything else works the same in Free. Subscriptions and purchases

Requirements

• Mac: macOS 13 or later
• iPhone: iOS 16 or later
• iPad: iPadOS 16 or later

More information

• Support
• Privacy Policy
• Terms of Use
• Subscriptions and Purchases