...
Search for the import XML that you wish to use from the Customer import or System import articles
Paste the example line into notepad
Make sure there are at least 4 lines. It needs opening and closing tags and at minimum 2 rows of data for Excel to recognize it correctly
Opening tag
Data row 1
Data row 2
Closing tag
Save the file with extension of .xml
Locate XML format required or file created above (Note: this requires MS Office for Windows. The Mac Office equivalent apparently doesn't support XML well and was found unusable to open standard XML files)
Open XML file in excel by right clicking on the file.xml
Click 'Open in Excel'
Paste in data as required
Click 'Save As' option
Note: if you have a column / field blank in Excel, when you SAVE AS, it will actually create an XML file that is missing that column altogether. That column needs to exist in the XML even as Column="" where there is no data between the double quotes. To get around this, add a period . or some other character in Excel. On export, open the file in notepad and do a FIND / REPLACE to set Column="." to Column="", save the file, then continue
Select 'XML Data'
Click Save
Import the XML in the AdminPortal, see KB Article Data Migration Utility - Configuration and Use for instructions