In MS Excel, use the Metadata Add-in for Excel that you can use to create new data sheets.
In Microsoft Excel, click File | Options.
The Excel Options dialog box appears.
Click Add-Ins.
Select Excel Add-Ins from the Manage list, and then click Go.
The Add-Ins dialog box appears.
Click Browse.
Navigate to the Standard-Addin.xlam file located in the following directory:
C:\Program Files\erwin\Data Modeler
r9\MetaIntegration\conf\MIRModelBridgeTemplate\MIRMicrosoftExcel\Standard-AddIn.xlam
Click OK.
In the Add-Ins dialog box, verify that Meta Integration Standard Add-in is selected, and click OK.
Microsoft Excel displays the Metadata ribbon that you can use to configure a mapping specification.
For example, pressing the button 'Models' will add a blank sheet in MS Excel with the proper format for the
Models data to be input
The attached sample worksheet and model (2021 R1 version) shows how the Excel worksheet was formatted for two entities and multiple attributes and datatypes so you may use that as a guide to input your worksheet to form your model.
Note: Please use the import bridge named, "Metadata Excel Format" as stated in the Title and not "Excel File (XLSX)"