I have the Airtable base of 10 000 companies - company’s name is used as primary field. The tax unique number of companies are in other field in Integer format.
Every week in Excel format I receive many companies data with their tax numbers with important information (status of work and comments) which is not updated in Airtable. Excel file is updated periodically with actual status and comments. To integrate this file to Airtable is not possible as it is managed by other company.
How to add important information (status of work and comments) about companies from Excel to Airtable base, using common identificator (tax number)?