How to download Import Set error logs as Excel (Response file) immediately after uploading the file.

[DamandeepS]

Hi Community,

When I import data into ServiceNow using an Import Set, the system generates error logs if some records fail. Right now, I have to manually check the import logs to see the errors.

My requirement is:

• After running an import, I want to immediately download the error logs in Excel format as a response file (similar to how some systems provide a direct error report after upload).

• Ideally, the file should contain details like row number, error description, and any field-level issue.

Has anyone implemented this before? Is there an out-of-the-box option in ServiceNow, or do I need to build a custom script (maybe using transform scripts, Data Source, or Scheduled Job) to generate and download the Excel file?

Any guidance or best practices would be much appreciated.

Thanks!