what is the maximum number of rows or size of file limited through easy import?

[pavan_yakkala]

Hi,

Can any please guide me about limit or maximum number of rows can upload from excel or csv file to Service Now tables?

or is there any limit of excel or csv file size to upload through easy import into Service Now tables?

Please help me on this information, it is urgent.

Thanks in Advance!

Regards,

Pavan.

[Mike Allen]

Increasing the Export Limit

[pavan_yakkala]

Hello Mike,

I think My understanding from Anurag's reply and link provided by you is all about exporting limit (exporting data from service now tables to excel).

But my requirement is reverse of this scenario i.e importing data from external excel file to Service Now tables through easy import option in SN and need to know maximum limit of data should import to Service now

Can you please provide me any help if you are aware of same

Thanks,

Pavan.

[Mike Allen]

I have never been limited when I have attempted to import.   I think the maximum number of records I've imported is on the order of 1,000,000, or something in that area, and I have had no issues.

[akzm]

Hi Pravan,

One clarification: Easy Import "only" imports Excel (.xls) files and not CSV files. You can however convert any CSV file into XLS and import it using Easy Import.

Having said that, 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.

When needed, instances can be configured to import even larger size files but this can potentially degrade instance performance.

Hope this helps.

Azfar

[seanpmcclean]

B

Hi Pavan,

Looking through the system I see a set of properties for BOTH import and export.   I checked both Fuji and Geneva Instances for this...

Based on this it looks like there are (adjustable) limits on the memory committed to an update, but that this is adjustable.

Additionally, there are notes in the Wiki suggesting that there are limits to max size for a single row of data

Importing Data Using Import Sets - ServiceNow Wiki

(check section 2 - Maximum Row Size)   says that it will simply skip this row

Lastly, I found some notes on the Apache Client - some limitations for size there, but this should not affect you.   You might try allocating more memory percentage to see if you can then load larger batches - if so then I would imagine that's the limitation.

Do take a moment to mark this or any other answers helpful if you find that they've helped - I'll keep an ear out and post if I find any more information.