Asset Tool - Exporting and Importing Large Numbers

Reference Number: AA-01233 Views: 1700 Last Updated: 03-10-2023 03:52 PM 100 Rating/ 1 Voters

Netaphor SiteAuditâ„¢ Asset Tool Importing and Exporting Large Numbers

Open the SiteAudit Asset Tool

Export the CSV from the Asset Tool

Ensure that file name extensions are enabled

Open File Explorer

Step 1: Select the "View" button
Step 2: Select the "File Name Extensions" check box

Change the extension of the file from .CSV to .TXT by right clicking the icon and selecting "Rename" from the drop down list

Open Excel

Step 1: Select Open
Step 2: Select Browse
Step 3: Change the file type to "All Files (*.*)"
Step 4: Select the .TXT file
Step 5: press the Open button

The Text Import Wizard should now be open

Verify that "Delimited" is selected and press the "Next >" button

Change the delimiter to the correct locale.

For example:

  • Select "Comma" if in the United States
  • use "Semicolon" if in Europe

In this example, "Comma" will be used. 

Select "Comma" delimiter check box and then press the "Next >" button

Step 1: Select the Serial Number column
Step 2: Select the Text radio button, (Verify, the word "Text" appears above the "serial_number" box, which is highlighted in black in the image below)
Step 3: Select the "Finish" button

After selecting Finish, Excel should now open with large numbers displayed

Example of a large number displayed:

Once the necessary changes have been made to the file, then save the file as a .CSV

Change the file type to "CSV (Comma delimited) (*.csv)" and select the "Save" button

Once the CSV file has been saved, then the file is ready to be imported by the Asset Tool.