---
id: AA-01233
title: "Asset Tool - Exporting and Importing Large Numbers"
url: http://netaphor.com/kb/AA-01233/asset-tool-exporting-and-importing-large-numbers
product: "Asset Tool"
type: "How-to & configuration"
updated: 2023-03-10
access: public
---


# Asset Tool - Exporting and Importing Large Numbers

## 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

![](http://netaphor.com/kb/media/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

![](http://netaphor.com/kb/media/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

![](http://netaphor.com/kb/media/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

![](http://netaphor.com/kb/media/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

![](http://netaphor.com/kb/media/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

![](http://netaphor.com/kb/media/AA-01233/wizard-3-of-3.png)

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

Example of a large number displayed:

![](http://netaphor.com/kb/media/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

![](http://netaphor.com/kb/media/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.