Best way to import 1 lakh Records

[Prasannach]

Hi All,

We do have a requirement to convert the process(which is currently in Excel) to Automation in ServiceNow. Users collect the data in Excel which contains around 1 Lakh Rows should be imported in ServiceNow. 1 Lakh Records should be created in a table after which they will update each record with some values. This is 1 time activity per year.

We have to give one interface where they can upload the Excel file which should do import.

Can you please suggest a better approach to this requirement. Is there anyway to breakdown the rows and do the import in service now ?

[Anurag Tripathi]

100k is not a lot of records, you can run it in a non business hours it should be fine.

If you want to break, you can always break the excel into 2-3 parts and run the same in 2-3 batches.

[sanketpatil09]

To import 100k rows from an Excel file into ServiceNow, the best approach is to use the Import Set feature. Start by creating a temporary Import Set Table that mirrors the structure of the Excel file.

Next, allow users to upload the Excel file through a Data Source, which will load the data into the Import Set table. Afterward, create a Data Transformation to map the data from the Import Set table to the actual target table where the records should be stored.

To ensure the import process is efficient and does not overload the system, break the data into smaller batches. It is also advisable to create a simple user interface or Service Portal that allows users to upload the file.

Upon uploading, the import process should be triggered automatically. Additionally, implement error handling and logging to track the progress and notify users of any issues that may arise during the import. This method ensures efficient data import, minimizes system load, and provides an easy-to-use interface for users.