question Excel Imports in Community Central forum

Excel Imports

cyberfox — Thu, 15 May 2025 15:21:47 GMT

Hi,

I'm still new to ServiceNow, I'm trying to create visual metrics for information on an excel sheet that is about vulnerabilities, how long they have been vulnerability, projected patch date, and mitigations. The goal is to create metrics for how long it has been vulnerable and the project patch date.

Can I upload this excel sheet to ServiceNow and create metrics for it?

Re: Excel Imports

BrianProvencher — Thu, 15 May 2025 15:35:55 GMT

You would need to import the excel sheet, run it through a transform map into a new table in ServiceNow, and then you could report on the metrics in that table.

Re: Excel Imports

Zach N — Thu, 15 May 2025 17:23:54 GMT

Hello!

Do you have Vulnerability Response setup and configured in your platform? Or are you just trying to use ServiceNow's reporting capabilities?

ServiceNow can only build reports off of information in its own tables, so if you aren't using something like Vulnerability Response, you'll likely need to create a custom table to import this data into.

Hope that helps! Let me know if you have any other questions.

Re: Excel Imports

cyberfox — Fri, 16 May 2025 18:22:07 GMT

Thank you! I don't know much about ServiceNow yet, I'm still going through the Associate PM training, so I haven't gotten to that topic. I will definitely look into the Vulnerability Response function!

My goal is just to show metrics of how long the vulnerabilities have not been compliant for and to to possibly show when the projected date on when they should be compliant by. This is something my boss has assigned me. Thanks again!

Re: Excel Imports

cyberfox — Fri, 16 May 2025 18:22:39 GMT

Thank you! I will try that!

Re: Excel Imports

Zach N — Mon, 19 May 2025 17:59:10 GMT

Of course! Happy to help.

Vulnerability Response is a separate product in ServiceNow, so if that's something your company hasn't already purchased, then likely it won't be an option unfortunately (Though you can always reach out to your account rep about what this might cost). That being said, this likely has all the features you need OOTB. For example, the Remediation Target can be configured based on your severity, and can be used to show when the vulnerability needs to be remediated by, and if the target was missed or met.

If this data absolutely needs to be in ServiceNow (and VR isn't an option), than you will likely have to create a custom table (and import it via a Transform Map/Import Set), as there aren't any OOTB tables or fields that can support this data for ITSM, etc. Note that this will eat into your custom table allocation/licensing.

Honestly unless there is a major business requirement to have this data in a report or dashboard in ServiceNow, managing via an Excel spreadsheet and sharing via a Knowledge article might be the cheapest/quickest option.