Exporting and importing XLS spreadsheet data
Prerequisites
- Access to the Management > Collection tracking (SP004) menu.
- Previously created data collection.
Introduction
The .xls spreadsheet is used when it is necessary to acquire collection data in an environment without internet access.
In this case, the collection is exported, the information is filled out directly in the exported spreadsheet, and the spreadsheet information is imported into the system.
Through the spreadsheet, it is possible to fill out the samples and the collection information such as shift, operator, and machine, and to disable samples.
When the import is performed, if required information is missing, the system displays a screen with the pending information.
See below an example of how to export and import this spreadsheet.
Exporting a spreadsheet
1. Access the Management > Collection tracking (SP004) menu.
2. On the screen that will be opened, select the desired collection.
3. Click on the More > Export to XLS button.
4. Then, enter the name of the export file.
5. Select the desired format.
6. Lastly, click on the 
button.
Importing a spreadsheet
1. Access the Management > Collection tracking (SP004) menu.
2. On the screen that will be opened, select the desired collection.
3. Click on the More > Import XLS button.
4. Then, click on the Select file button.
5. Select the file with the collection data you wish to import.
6. Lastly, click on the 
button.
Conclusion
Thus, the data of the XLS spreadsheet has been successfully exported and imported!