What is the maximum (size) limit of excel file that can be imported through Import Set?

[The Matrix]

Hii, 

im curious about how much size of Excel sheet can be imported through import set. 

[Community Alums]

Hi @Siddharam Takali ,

As a best practice Break a very large data set into multiple, smaller jobs for faster results. 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.

A single row in a database may not contain more than 8126 bytes of data. The size of each row is determined by the amount of content in all fields, as well as the character set for text fields. For example, a row with 10 text fields each containing 1000 characters using a French character set takes 15360 bytes.

Attempting to import more data to a single row than the maximum size causes the import to skip that row. Any rows that were skipped for this reason are listed in the import log.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi @Siddharam Takali ,

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[eumak]

Hii @Siddharam Takali 

ServiceNow does enforce a max limit on Excel file imports but it is based on file size (not rows or columns). In out of the box instances, you should be able to import an xls file of up to 50mb.

For more information you can have a look into the official doc below-

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/refe...

Mark my answer correct & Helpful, if Applicable.

Cheers..!
Happy Learning:)
Tushar

[Community Alums]

Hi Tushar,

I said the same thing, please read the replies by others before you answer to any question.

Thanks.