The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Unable to convert xls to xlsx file format via ServiceNow

Shamma Negi
Kilo Sage
Kilo Sage

Hi All,

 

I am using excel parser which only supports xlsx. But my client is sending xls.

 

Is there anyway to convert xls to xlsx?

 

Please suggest.

 

Thanks,

Shamma

Regards,Shamma Negi
4 REPLIES 4

Dipen Wadhwana
Giga Guru

Hi @Shamma Negi ,

 

ServiceNow  primarily supports Excel files in the XLSX format  because the platform is designed to work with the newer XLSX format and doesn’t have built-in support for converting older XLS files.

Here’s a general guideline on how to handle this situation:

  1. Open the XLS File: First, open the XLS file in Microsoft Excel or a similar spreadsheet program.

  2. Save As XLSX: In the spreadsheet program, use the “Save As” or “Export” feature to save the file in the XLSX format. This typically involves selecting “XLSX” from the format options in the save dialog box.

  3. Upload to ServiceNow: Once you’ve saved the file in XLSX format, you can now upload it to ServiceNow without any issues. ServiceNow should be able to handle XLSX files without any problems.

Keep in mind that if you have a large number of XLS files to convert to XLSX and this process is repetitive, you might consider automating this conversion using scripting or a third-party tool, especially if it’s part of a larger workflow within your ServiceNow instance.

If you encounter specific issues while working with XLSX files in ServiceNow, it’s advisable to check ServiceNow’s documentation, consult your organization’s ServiceNow administrator, or reach out to ServiceNow support for assistance with troubleshooting and resolving the problem. 

 

Please mark it helpful if it helped you.

Ankur Bawiskar
Tera Patron
Tera Patron

@Shamma Negi 

no way to convert xls to xlsx file within ServiceNow

you will have to use custom solution for handling this, possibly using mid server

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

okay. any script or solution on mid server you know?

Regards,Shamma Negi

Shamma Negi
Kilo Sage
Kilo Sage

No way to convert the file by any function or class in ServiceNow. hence notjing can be done on this.

 

Thanks,

Shamma

Regards,Shamma Negi