Watcher - ICCID Duplicated on Export

Resolving Duplicate ICCID Column Export Issues in Watcher Utility

When utilizing the "Watcher" utility from the Manufacturers Toolbox (https://mfg.armordata.io), users may encounter an issue where ICCID column exports appear as duplicates. To address this problem, a specific adjustment within Microsoft Excel settings is recommended. Follow the steps outlined below to ensure proper handling of .csv file exports, thereby preventing unwanted data conversions that could lead to duplicate entries.

Steps to Adjust Excel Settings for .csv Files

1. Access Excel Options:

   • Open Microsoft Excel.
   • Navigate to "File" in the top menu.
   • Select "Options" from the list to open the Excel Options dialog box.

2. Modify Data Settings:

   • In the Excel Options dialog, click on the "Data" category to view data-related settings.

3. Adjust Additional Options:

   • Scroll down to find the "Additional Options" section.

4. Enable Notification for Data Conversions:

   • Look for the setting labeled "When loading a .csv file or similar file, notify me of any automatic data conversions."
   • Ensure this option is checked. This setting prompts Excel to notify you before any automatic data conversion occurs when opening a .csv file, allowing you to opt-out of such conversions.
5. 

6. Save Changes and Exit:

   • Click "OK" to save your changes and close the Excel Options dialog.

7. Reopen Your .csv File:

   • Close the .csv file if it is currently open.
   • Reopen the file in Excel. You should now receive a prompt regarding data conversion.
   • Opt to NOT convert the data when prompted. This action preserves the original data format, effectively preventing the duplication of ICCID columns.
8. 
   
9. 
   
   • By following these steps, you can ensure that your ICCID column exports from the "Watcher" utility are correctly represented in Excel, free from unwanted duplications. This adjustment only needs to be made once and will apply to future .csv file openings in Excel, streamlining your workflow with the Manufacturers Toolbox.