Unable to convert xls to xlsx file format via ServiceNow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 07:02 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 07:14 AM
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:
Open the XLS File: First, open the XLS file in Microsoft Excel or a similar spreadsheet program.
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 07:18 AM
no way to convert xls to xlsx file within ServiceNow
you will have to use custom solution for handling this, possibly using mid server
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 08:56 AM
okay. any script or solution on mid server you know?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2023 04:04 AM
No way to convert the file by any function or class in ServiceNow. hence notjing can be done on this.
Thanks,
Shamma