Data can get scrambled or mismatched on upload due to several factors. The biggest culprit is incorrect sorting or filtering of data. Gopher for Chrome uses Google's unique Device ID in column AM, which is hidden by default when updating device information, not the Serial Number. This scenario is why keeping the complete row data intact when sorting and filtering your data is so important.
To prevent scrambled data, ensure the following guidelines are followed:
- If filters are OFF, click the funnel icon to turn them on.
- When you sort or filter your data, you should use the filter icon next to the column headers.
- Once you have your data the way you want it and kick off the upload, the sidebar must remain open until the upload is complete. Also, do not make other changes or sort the data while processing the update. It is best to leave the sheet alone until the upload is complete.
| Document Version | Date | Description of Change |
| 1.0 | 8/21/2024 | Minor text updates, reverify |