Skip to content

Table import

DasDuo edited this page Jun 14, 2026 · 1 revision

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.

Clone this wiki locally