What are the maximum number of record can we import from excel into servicenow Table?

[Harish Bainsla]

Hi @Ankit Kumar6 

Consider import sets under 100,000 records as a guideline. For example, importing 10 sets of 100,000 records completes faster than one import of 1 million records even though the total data imported is the same. Rows imported using import sets must not exceed the maximum row size

https://www.servicenow.com/community/devops-forum/what-is-the-maximum-size-limit-of-excel-file-that-....

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0518655

if my answer helps you mark helpful and accept solution

[Sohail Khilji]

Hi @Ankit Kumar6 ,

Whats the business use case here ? There are other attributes like perfomace which needs to be consideration while loading huge data. 

[Community Alums]

Hi @Ankit Kumar6 ,

A guideline to consider is importing sets with under 100,000 records. For instance, importing 10 sets of 100,000 records is faster than importing one set of 1 million records, despite the same total data being imported.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak