When importing objects, such as accounts, assets, or users, SPP expects the import file to be a Comma Separated Values (CSV) file.
A CSV file is a text file used to store database entries where each line is a unique record and each record consists of fields of data separated by commas. You must not add any trailing spaces in the properties you define in the CSV file. The easiest way to create a CSV file is by using a spreadsheet program such as Microsoft Excel; however, you can use any text editor, such as Notepad, to create a comma-delineated file, as long as you save the file with a .csv file type extension.
The order of the columns is not important, but the title of the column must match the property name.
To create a customized .csv file template
-
In the Import dialog, click Download Template to save a copy of the template properties table to a location of your choice.
-
Locate the downloaded template and add your specific information to the template.
-
Use the customized .csv file to import the objects.
For more information on columns, see Template CSV file.