Can we upload an external Excel sheet and fill ServiceNow Time sheet Portals ?

[AbdurRahmanSnow]

Can we upload an external Excel sheet and fill ServiceNow Time sheet Portal? Is it possible? 

Is it possible to have an excel template of the (time_card) record that the user can complete multiple of and then have them uploaded into ServiceNow Time sheet Portal ?

[AbdurRahmanSnow]

Yeah Sir, correct. It will take days to achieve this. It is not Out of the box (OOB) requirement. Lot of Transform Map, UI action, etc, will be required.
I have informed them.

[Ankur Bawiskar]

@AbdurRahmanSnow 

you can ask users to upload an excel template, submit a catalog item and add that file and then perform the data load using transform map, field map etc

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Murtaza Saify]

Steps to Upload Excel Data into ServiceNow Time Sheet Portal

1. Prepare the Excel Template

• Create an Excel template that matches the structure of the time_card table in ServiceNow.

• Include columns for all required fields, such as:

  • user (User Sys ID or User Name)

  • week_starts_on (Start date of the week)

  • hours (Number of hours worked)

  • task (Task or Change Request Sys ID, if applicable)

  • comments (Optional comments)

• Ensure the template is easy for users to fill out.

2. Upload the Excel File

• Users can fill out the Excel template with their time sheet data.

• Save the file in a supported format (e.g., .xlsx or .csv).

3. Use Import Sets to Load Data

• Import Sets allow you to load external data into ServiceNow staging tables.

• Follow these steps:

  1. Navigate to System Import Sets > Load Data.

  2. Upload the Excel file.

  3. Map the columns in the Excel file to the corresponding fields in the time_card table.

4. Create a Transform Map

• A Transform Map is used to transform and move data from the staging table to the target table (time_card).

• Follow these steps:

  1. Navigate to System Import Sets > Transform Maps.

  2. Create a new transform map for the staging table.

  3. Map the fields from the staging table to the time_card table.

  4. Use scripts (if needed) to handle complex transformations or validations.

5. Automate the Process (Optional)

• If users frequently upload time sheets, you can automate the process:

  • Create a Service Portal widget or UI Action to allow users to upload Excel files directly.

  • Use a Script Include or Flow to process the uploaded file and load it into the time_card table.