Skip to content

Bulk import from a CSV

If your inventory already lives in a spreadsheet, you don’t have to retype it. Map your columns to TermZ session fields, then produce the import JSON envelope — any small script or spreadsheet formula can do the conversion.

Spreadsheet column Session field Notes
Name name Required. Display name (also used for dedup).
Host / IP host Hostname or IP.
Protocol kind ssh, telnet, raw, serial, or local.
Username username Login user.
Folder folder_path POSIX-style, e.g. /Datacenter/Core. Missing folders are auto-created.
Device type equipment_type Router, switch, firewall…; custom types allowed.
Tags tags An array — see below.
Credential credential Name of a stored credential to link.
Notes notes Freeform.

Spreadsheets usually keep tags in one cell (e.g. prod;core;dc-east). Split that string on your delimiter into a JSON array:

"tags": ["prod", "core", "dc-east"]

Emit one object per row inside the sessions array:

{
"version": 1,
"sessions": [
{ "name": "core-rtr-01", "host": "10.0.4.1", "kind": "ssh", "username": "netadmin", "folder_path": "/Datacenter/Core", "equipment_type": "router", "tags": ["prod", "core"], "credential": "netadmin-prod" }
]
}