Overview of HCM Spreadsheet Data Loader (HSDL)

Overview of HCM Spreadsheet Data Loader (HSDL)

There are many ways of loading data into Oracle Cloud:

  1. HDL (HCM Data Loader)
  2. HSDL (HCM Spreadsheet Data Loader)

In this blog we are going to discuss about HSDL (HCM Spreadsheet Data Loader):

What is HCM Spreadsheet Data Loader?

HCM Spreadsheet Data Loader is a tool that enables you to create use-case specific bulk data loading spreadsheets for business users to use.

HCM Spreadsheet Data Loader loads HCM business objects from spreadsheets, which you generate from spreadsheet templates.

Steps for downloading spreadsheet template from system:

Navigation: My client GroupsàData ExchangeàHCM Spreadsheet Data LoaderàSpreadsheet Templates

spreadsheet templates

Now we will select and open the required template and we can download the template by clicking on Preview.

mobile number update

Steps For Uploading Spreadsheet Data Loader:

In this step, we will validate the template and upload the data.

Validate and Load the Data:

  1. Click Validate to validate the template.

You should not see any errors.

  1. Click Preview to generate a spreadsheet for the configured template. The GenericHdlSpreasdheet.xlsx file will be downloaded. Open it.

3. You must log in again. Click Yes.


Login with your user ID and password. The spreadsheet will be generated with each of the Selected Attributes in the template seen as a column in the spreadsheet.

4. To upload data with the spreadsheet you must first create a data set. Click Create Data

Set on the Spreadsheet Loader toolbar.

Click OK on any dialog pages displayed.

A data set will be created with a defaulted name, you can change this if you want.

Data Set

5. Double click in any of the cells in the first row under the column headings to initiate the row.

Column heading

6. Enter valid data for each of the empty cells in the row.
7. In the Spreadsheet Loader toolbar, click More > Upload.


8. Click Refresh regularly to refresh the spreadsheet row status.


The Upload Progress will change status until processing completes with a Success status.

9. Navigate to the Person Management task to ensure your new hires can be seen.

Advantages of using HSDL (HCM Spreadsheet Data Loader):

  1. The main advantage is the ease of using the tool for uploading the data. It is user friendly as excel is most used application for modifying, Updating and correcting the data.
  2. Upto 65 thousand data can be uploaded into the system in one go without any performance issues. If the data exceeds that number, we can upload remaining data in batches.
  3. The Load errors are displayed in the sheet with error message so that we can easily identify the errors, rectify and reuploaded.
  4. It has the flexibility of preparing our own template as per the business requirements and only consider the required number of columns.
  5. Predefined spreadsheet templates are already available for most of business needs, besides user can also define their own template as per requirement.

Leave a Reply

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info