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
![](https://support.netaphor.com/admin/media_store/2/AA-01233/file explorer steps.png)
Change the extension of the file from .CSV to .TXT by right clicking the icon and selecting "Rename" from the drop down list
![](https://support.netaphor.com/admin/media_store/2/AA-01233/csv to text.png)
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
![](https://support.netaphor.com/admin/media_store/2/AA-01233/open text in excel.png)
The Text Import Wizard should now be open
Verify that "Delimited" is selected and press the "Next >" button
![](https://support.netaphor.com/admin/media_store/2/AA-01233/wizard 1 of 3.png)
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
![](https://support.netaphor.com/admin/media_store/2/AA-01233/wizard 2 of 3.png)
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
![](https://support.netaphor.com/admin/media_store/2/AA-01233/wizard 3 of 3.png)
After selecting Finish, Excel should now open with large numbers displayed
Example of a large number displayed:
![](https://support.netaphor.com/admin/media_store/2/AA-01233/large number example.png)
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
![](https://support.netaphor.com/admin/media_store/2/AA-01233/save as csv.png)
Once the CSV file has been saved, then the file is ready to be imported by the Asset Tool.