Download an import template

Select the list you want to import data to and create an import template from that list.

시작하기 전에

Role required: admin.

프로시저

1. Navigate to any list, such as All > Self-Service > Incidents.
2. Right-click the column heading.
3. Select Import.
   주:

   Make sure columns are updated before importing them.
4. Select if you want to Insert or Update records.

   표 1. Import template

   Template	Description
   Insert	Use this template to add new records to a table.
   Update	Use this template to change values within existing records in a table. This template contains one row for each record in the list. The current list filter determines what records the template contains.

5. 옵션: Clear the Include all fields in the template? check box to include only columns that appear in the list in the template.

   Certain fields in the table are updated by system processes, and you cannot import values into them. An example is the Created by field, which is populated during import with the logged-in user who performs the import.

   Leave this check box selected to include all columns from the table in the template, even those columns that are hidden in the list.

6. Select the Export template format you want, either XLS or XLSX.
   XLSX is the preferred format, XLS is available for legacy support. The Export template format field appears only if the property glide.legacy.excel.export is true.
7. Click Create Excel template.

다음에 수행할 작업

Open the spreadsheet using your preferred application.

주:

Each template contains a Directions tab describing how to use the template.