Import Data to a Spreadsheet

To populate a spreadsheet with data for upload, you can either enter the data manually or import it from a file. This topic describes how to import data to a spreadsheet from a file.

Follow these steps:

1. If the spreadsheet isn't already open, then open it and sign in when prompted.

2. You import data to a data set. You can either create the data set or use an existing data set.

   • To create a data set, click Create Data Set on the Spreadsheet Loader toolbar. A name is assigned automatically to this new data set. You can overwrite the data set name.

   • To use an existing data set, select its name in the Search section of the spreadsheet and select a Search Mode value. Click Search in the Spreadsheet Loader toolbar.

3. On the Spreadsheet Loader toolbar, click Import File. The Import from File dialog box opens.

4. In the Import from File dialog box, select one of File Type values shown in this table.

   File Type	Description
   Comma separated values	Comma-separated (.csv) file
   Pipe separated values	Delimited data (.dat) file
   Other file type	Text file (.txt) with a user-specified separator
   XML file type	XML file

   Tip:

   You can download CSV and XML file templates from a spreadsheet template. Use them to load data to a spreadsheet generated from the same template.

5. For file types other than XML file type, indicate whether the file contains a header.

   The header provides the names of the attributes for which the file contains values. In this case, the attribute order in the file doesn't have to match the spreadsheet column order. If you deselect Header included, then the order of the values in the file must match the order of the columns in the spreadsheet.

   In an XML file, the XML tags used for the attribute values must use the attribute keys configured in the spreadsheet template.

6. Click Browse to select the file to import.

7. For file types other than XML file type, expand the Advanced File Options section. Complete the options as shown in this table for the selected file type. You can use the default values where supplied.

   File Type	File Separator	Escape Indicator	Newline Indicator
   Comma separated values	Not applicable	1 - 10 characters	1 - 10 characters
   Pipe separated values	Not applicable	1 - 10 characters	1 - 10 characters
   Other file type	1 - 10 characters	1 - 10 characters	1 - 10 characters

   The Newline Command field shows the newline command constructed from the supplied Escape Indicator and Newline Indicator values.

8. Click OK to import the data from the selected file. After the data is imported, you can edit any of the imported attribute values.

Note:

Some validation of the imported data occurs. Any errors appear automatically in the Progress and Message columns of the Spreadsheet Line Status section of the spreadsheet. Correct any errors before you attempt to upload the data.

Here's a tutorial to shape and import files using a HCM Spreadsheet Data Loader template: Import Files into HCM Spreadsheet Data Loader Spreadsheets