Starting from version 3.1.8.2, XL-Connector gives you the ability to download and upload custom metadata records.

Downloading All Records From a Custom Metadata Object

  1. Click on Other Tools -> Load Custom Metadata -> Download Custom Metadata:
  2. A dialog box will be displayed allowing you to select a custom metadata object and download all records from it.

Updating Existing Custom Metadata Records

  1. Once custom metadata has been downloaded, you can edit the field values right in the spreadsheet and then update them in salesforce by clicking on either Other Tools -> Load Metadata -> Update Selected Rows or Update All Rows.

Creating New Custom Metadata Records

You can also use the downloaded custom metadata sheet to create new metadata records:

  1. Add new rows at the end of the data populating all the fields you want to upload.
  2. Create them in Salesforce by selecting the new rows and clicking on either Other Tools -> Load Metadata -> Update Selected Rows.