Improvments have been made to the format of the export / import process, please follow the below guide.
Step 1 - Export the data
The output will open in a new excel window.
Step 2 - Save this output to your desired path with a friendly file name.
Because this export gets saved to a temporary path you will need to save it to somewhere you can locate it afterwards.
File -> Save As
Step 3 - Editing
The 9 editable columns have been highlighted green for your convinence.
When done editing SAVE THEN CLOSE the excel file.
Do not remove / add or re-order columns
Step 4 - Importing
When Importing you will now be give a dialog to select the file to import.
You will also be given a progress bar while importing. There are two parts to the import (Reading & Writing).
Do not do anything else while importing.
Once finished you should be given a dialog that the import was successful.
Step 3 - Check
Check some of the changes you've made to make sure the data has been imported correctly before submitting.