SAP Knowledge Base Article - Public

2358156 - How to query data using the MS Excel Add-In from Successfactors


This KBA helps us understand the employee delta export using MS Excel Add-In provided by successfactors.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Successfactors SFAPI CompoundEmployee - Employee Delta Export Add-In


  1. Goto Successfactors admin center, click on Employee Files and choose Employee Delta Export

             employee delta export.png

       2. Download the Excel Add-In and the Work Book from the instance.

            excel workbooks and addin.png

       3. Open the Excel Add-In and install it.

       4. Open the work book and start with the configuration, in the drop down list choose "EC_COMPANY"


       5. Now enter the API URL specific for the instance (according this KBA), the company ID and username (for setting permissions for this user refere section 4.1.1 API Endpoint URLs for Employee Delta Export of Guide

Using the Employee Delta Export Add-In for Microsoft Excel), please do not enter password.

           NOTE:  An user created for SSO purpose cannot be used here.


       6. Goto Selection sheet and fill in the details. Then choose successfactors add-in in the ribbon section.

           Selection screen.png

       7. click on Get Data.


       8. You will be prompted for the password, now incorporate the password and click on log on button.


       9.  Following screens appear once the log in is perfectly done.

            logging on.png

            retreiving data.png

            post processing.png

          records being processed.png

     10. Finally after the records are processed, if there are any warnings it would bring up this pop up

         if any warnings.png

     11. Following is an example of the data screen


See Also

Employee Delta Export Add-In documentation - SuccessFactors


Query using Employee Export Tool, MS Excel Add-In CE Query , KBA , employee delta export , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-CE , Compound Employee API , How To


SAP SuccessFactors HCM suite all versions