How do I update data by merging

Hello to all-

We are an organization that tracks our members purchases from many different vendors. These vendors send us excel spreadsheets that have our member name listed and then what their purchases for the month are.

Currently, we look at the excel spreadsheet, pull up the member's record in ZOHO and then update the field that holds the purchase amount for each vendor.

Is there a way to merge the spreadsheet so that automatically populates the member's record without having to manually each field by hand each week?

Thanks