Two exports never name their columns the same way. Paste both headers and get the field mapping plus the pair to join on.
Paste the header row of each file — tab, comma or one column per line. Adding one or two data rows helps with columns that share a name but not a meaning.
Only the headers and samples you paste are sent to the model. Your files stay on your computer — the mapping is meant to be used here or copied into your own script.
Match Columns Between Sheets
The mapping appears here: which columns pair up, which pair to join on, and what will not line up.
Tools people usually need next, in the same workflow.
Load two Excel or CSV files and find the rows that do not match: missing entries, extra entries and changed values. Both files are read in your browser.
Pull columns from one table into another by a shared key — the VLOOKUP you always wanted. Both files stay in your browser.
Check that the same customer, item or employee looks identical in every sheet of the workbook.
Match two lists whose names are written differently — pick a column on each side, set a threshold, and get the pairs plus what is left over.
We use cookies with Google Analytics to measure traffic and improve the product. You can accept or reject — rejecting keeps every feature working. Privacy