The Scenario
The hardware refresh is done. The data center team handed you an Excel workbook with 120 Linux servers: hostname in column A, IP address in column B, OS version in column C, environment in column D. IT asset management needs all 120 of them in the ServiceNow CMDB as configuration items before the audit next Tuesday. You have been told this is "just a data entry task."
The bad version:
- Open ServiceNow, navigate to the CMDB, select the Linux Server class, click New, fill in the hostname, IP, OS version, environment, classification, save.
- Repeat 119 more times.
- Discover on record 43 that the environment field uses a different value set than what is in the workbook, so those rows will need to go back for correction.
This is not a data entry task. This is a data entry task that someone handed off because they did not want to spend their afternoon doing it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your asset list and creates each one as a CMDB configuration item in ServiceNow — no form navigation, no class-by-class selection.
For each row in this workbook, create a Linux server CMDB CI in ServiceNow using the hostname in column A, IP address in column B, OS version in column C, and environment in column D, then write the sys_id into column E
What You Get
- One Linux server CI record per row created in the ServiceNow CMDB
- The sys_id for each new CI written into column E
- Validation errors surfaced per row in column E so you can identify and fix the exceptions
- The full batch submitted in one operation — not 120 separate UI interactions
What If the Data Is Not Quite Ready
The environment values in column D do not match the CMDB environment field options
Your workbook has "Production," "Staging," "Dev" but ServiceNow expects "Production," "Stage," "Development."
Before creating CIs, normalize the environment values in column D — Staging to Stage, Dev to Development — then create a Linux server CMDB CI for each row using the hostname in column A, IP in column B, OS version in column C, and normalized environment, writing the sys_id into column E
Some hostnames in column A already exist in the CMDB and should be updated, not created
You do not want duplicate CIs for servers that were already partially entered.
For each row, check if a Linux server CI with the hostname in column A already exists in the ServiceNow CMDB — if it does, update its IP, OS version, and environment fields; if not, create a new CI — then write the sys_id and action taken (created or updated) into columns E and F
The operational status needs to be set to "Operational" for all new CIs
The default for new CIs is "Non-Operational," which breaks reporting.
For each row in this workbook, create a Linux server CMDB CI in ServiceNow with hostname from column A, IP from column B, OS version from column C, environment from column D, and operational status set to Operational, writing the sys_id into column E
Full kill chain: normalize fields, check for duplicates, create or update, and set relationships
For each row, normalize the environment value in column D, check if a Linux server CI with that hostname already exists in the CMDB, create or update the record accordingly, set the operational status to Operational, look up the support group sys_id from the group name in column F and assign it, then write the sys_id and action into columns G and H
One prompt handles the deduplication, the normalization, and the relationship assignment in a single batch.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook your data center team handed over, then ask it to push all 120 servers into the ServiceNow CMDB at once. For pulling CI data back out, see the export-cmdb-configuration-items spoke or return to the ServiceNow hub.