Skip to content
LICENSEWARE Help
Sign in

MEM template

File Upload

Use this template when a Microsoft License Statement does not carry the entitlement, or when you are loading entitlements without a statement. Download it from the data source: open Datasources, click MEM - Template, then Download Template. Download a fresh copy each time. Templates change.

The sheet has two parts. The top half names the columns and which of them are required. In the published example, product_family, product_name and version are required.

MEM template header rows, with the required and optional flags and a description of what each column holds

The lower half, under DATA LINES TO BE IMPORTED, is what gets imported. Example rows are there to show the shape. Remove them before you upload.

The MEM template DATA LINES TO BE IMPORTED section, with example entitlement rows

The naming follows the Microsoft License Statement. If a name is unclear, check it against a product name on Microsoft Deployment Overview.

Save the file, then upload it on that same MEM - Template data source. Open Datasources, click MEM - Template, and drag the file into the upload area or click Upload. How an upload is checked is Upload & manage data.

MEM - Template on Datasources, with Reset data, Download Template, Drag & drop files & folders here, Upload, the spreadsheet chips, and Runs, Files Uploaded, Validation Errors and Processing Errors

The position those rows feed is Microsoft Effective License Position. Microsoft Graph, for deployment rather than entitlements, is the API path on Microsoft Graph.