4 min read
Import content from an Excel file to the Mystery Shopping list
You can import content from an Excel file and consolidate it to the existing data in the Mystery Shopping list. To import content from an Excel file to the Mystery Shopping list:
- In Full Admin, click Domain Admin, Domain Settings.
- Under Applications Lists, click Domain List Admin.
- Select Mystery Shopping List, and on the page that appears, click Import List Items.
Note
You can sort the data in the Mystery Shopping list either in descending (highest to lowest score) or ascending (lowest to highest score) order. To do so, click the inline
Edit icon in the Mystery Shopping list, and in the
Sort by JSON Property Name field, enter the variable
score Desc for descending order or
score Asc for ascending order.
- Select the Excel file that contains the content that you want to import, and then click Import.
Note
In the Select How You Want to Import Data dropdown, ensure that the Upload File (,.xlsx,.rxr,.csv) option is selected. The other options let you enter the data based on their description. For example, if you select Comma Separated (list contains comma separated values per line), you need to manually enter the data per line and ensure that each value is separated by a comma.
- Click Map Columns to map the columns in your Excel file to the existing columns in the system. To convert the scores from decimal to percentage, click the Parse Value Field as Percent checkbox.
- When the system has finished mapping the information, click Import and Save.