Import specific cells from xls file

[nowguru]

I have inventory xls that contains cmdb information on various hardware equipment.  This xls file has been formatted to look "nice" from a human readable perspective.  There is information about when, where, and who performed the inventory in first few rows excel file.  There is also footer information that I also want to capture in separate objects.

My question - is there a import template feature that I can define specific cells to map to specific fields?  I am familiar with Sheet Num and Header Row fields in Data Source configuration, but this is really designed ingest data from all rows (after Header Row) and all columns in the specified sheet.  I would like to have more granularity on the import (vs post processing of all ingested data).

[dmathur09]

Hi Nowguru,

You can use transform map while importing the excel data, in the mapping you can only map the required field. Hence you would not be required to alter the excel sheet.

Regards,

Deepankar Mathur

[Allen Andreas]

Hi,

Unfortunately, you aren't able to specify cells in that granular of level (like saying H13-H25), etc.

You'd need to do a bit of cleanup on that document to get it ready for importing versus taking the user friendly version and running that through.

It's all about the columns and headers as far as the data processing goes.

You can load it through and see what happens on a staging table with it, then in the transform map you can ignore other pieces of data by simply not mapping it, etc.

Without more specifics from you, I'm having to address this from a high level. My apologies for that.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[nowguru]

Thanks Allen.  I was already heading down that path and creating a "shadow" worksheet that had all the data arranged in separate columns.  It would be nice if Data Sources/Transform Map was enhanced to do more granular extraction.

[Allen Andreas]

Hi,

I agree. Feel free to submit this idea to the Idea Portal and ServiceNow may add this to a future version.

That's great though that you've been working on a shadow document. Nice work!

If my reply ended up guiding you Correctly, please also mark it as Correct.

Thanks and take care! 🙂