Table import

Table import

ShuttleX can generate the JSON from a spreadsheet — handy when you manage many servers. Settings → Table import → "Import table…".

Expected columns

Order doesn't matter; the header row is detected automatically, and German/English names are recognized.

User	Server DNS	Server IP	Cluster	Stage
deploy	web01.prod.example.com	10.0.1.11	web	Prod

Format

• CSV, TSV, or Excel (.xlsx). The , and ; delimiters are auto-detected. CRLF line endings (Google Sheets exports) are handled.
• Google Sheets: just export as CSV or Excel (File → Download).

Options (chosen before importing)

• Connect via DNS name or IP address. If the chosen value is missing in a row, ShuttleX falls back to the other.
• Name: the "Server DNS" (or "Name") column is used verbatim as the display name — it doesn't have to be a real DNS.
• Mode: Merge updates entries with the same name and adds new ones (manual servers preserved); Replace overwrites the JSON file completely.

Grouping

One group is created per combination as Stage · Cluster (e.g. "Prod · web"), keeping the menu tidy.

Safety

Rows whose server fields contain unsafe characters (spaces or shell symbols) are skipped and reported in the import sheet. Combined with shell-quoting at launch time, importing an untrusted spreadsheet cannot inject shell commands.

A sample file lives at examples/servers-sample.csv.