热门工具 按访问量与点赞数
加载中…
数据随访问与点赞实时更新
浏览历史 仅保存在本浏览器
加载中…
最多保留 50 条
我的收藏 仅保存在本浏览器
加载中…
在工具页点「收藏」即可添加
VLOOKUP Tool
Table 1 (lookup)
Tip: copy straight from Excel — Tab is the default separator
Table 2 (reference)
Tip: table 2 builds the lookup map; the last occurrence of a key wins
Merged result
About This Tool
Excel-like VLOOKUP online: paste two tables, pick key columns and merge with one click. Duplicate marking/removal, copy and CSV export included.
Data Security: This tool runs entirely in your browser. All data processing happens locally and is never uploaded to any server.
FAQ
How does it differ from Excel VLOOKUP? ▼
Same logic — match on the chosen key columns of each table and append non-key columns of table 2. No formula needed, just paste.
What if a key appears multiple times in table 2? ▼
The last occurrence wins when building the map. Duplicates are auto-marked to help you clean up.
How are columns separated? ▼
Tab (default when copying from Excel) or two or more spaces.
Is my data uploaded? ▼
No. Parsing and merging happen entirely in your browser.
