Range recodes export is slightly different from exporting regular recodes. In this case export file will only contain already defined Ranges, so you need to have at least one to export a file, otherwise you will get an empty spreadsheet. After clicking "Export .XLSX" Analyze will generate an excel spreadsheet with thee columns. Columns "A" and "B" contain the information about the range of the recode, while column "C" has labels of recoded ranges. You can edit this file and then import it back to Analyze.
Import:
Click "Import .XLSX" and choose an excel file that you want to import. You have to remember a few rules:
ranges defined in columns "A" and "B" cannot overlap, if they do you won't be able to import it,
Analyze reads the first column until first empty cell,
recoded labels in column "C" are case sensitive (it matters whether you use uppercase or lowercase letters).
Exported file
Imported file
After you import new mapping, Analyze will inform you about the number of found recodes:
Found 8 recode(s) in file. - this message means that Analyze found and applied 8 recodes.
