Merge data from 2 CSV files

You may sometimes need to use two different sitemaps for complex scraping jobs, and you may need to later combine (merge) the results into one file.

Excel works great for this, and you can use either VLOOKUP or INDEX /MATCH.:
https://www.ablebits.com/office-addins-blog/2018/10/31/excel-merge-tables-matching-columns/
merge-tables-source-data