Issues with attachment file size in Import Set load data

[ankurc2]

I am trying to upload an excel sheet with 45000 rows in Import Set. The upload is failing and I am getting an error. I checked the Import Log and found out this error - 

File /glide/nodes/ven069459_16037/bin/../tmp/ids22e8500efb3fb6509bbaf9ce45efdc82.tmp is too large (19433054) to be loaded on this instance. 

Has anyone faced this before ? How to solve this ?

[Jaspal Singh]

Hi,

Did you check for file size and attachment limits for the platform

[Deepak Shaerma]

hi @ankurc2 

you can reduce the excel size by converting it to csv instaed of xlsx, or split your 45000 records into two excel sheets.. to load the data.... 

if still facing issue, go to sys_properties.LIST and search for com.glide.loader.excel.max_file_size , and increase the limit,,, if not found create a new one .

Happy to help! ‌‌
To help others in the community find this solution, kindly mark this response as the Correct Answer ‌‌ and Helpful‌‌.
Warm Regards,
Deepak Sharma
Community Rising Star 2025

[lochuynh33]

Hi @ankurc2 

Please refer to the following ServiceNow Knowledge Base article for detailed information on this issue:
🔗 KB0852523 – https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0852523

Resolution:
Split the large Excel file into multiple smaller files and import them sequentially into the same target table. This helps avoid file size and performance limitations during the import process.

If this response was helpful, please consider marking it as Helpful and/or Correct.
You may mark more than one reply as an accepted solution.

Thanks!

[Tanushree Maiti]

Hi @ankurc2 

Probable Solutions for Large File Imports: 

• Split the File: Break the large Excel workbook into multiple smaller files and import them individually into the same target table. //Refer: Excel file imports size limitation 
• Use CSV Files: Converting large Excel files to CSV usually reduces file size significantly and is processed more efficiently by ServiceNow's import sets. //Refer: Export stopped due to excessive size. Use CSV for a complete export 
• Adjust Memory (If self-hosted/app-specific): Check the glide.excel.max_memory_percent  property if you have access to modify the percentage of memory allowed for imports.  //Refer : Import of Excel file fails with error: file is too large to be loaded on this instance 
• Attachment Limits: If this is happening on a Service Portal, note that attachments over 25MB might fail, whereas backend form uploads allow for larger files (up to 1024MB default). //Refer : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0598301