Import from CSV

Search…

Import from CSV

Termius doesn’t allow importing data from a CSV file per se, but you can convert it to an ssh config file and then import it as ssh config.
To convert a CSV file, you need to ensure it's correctly formatted (see below).
Prepare the CSV File
A CSV file must accord with the following format:
It is a plain text file named source.txt
Each new line represents a new entry.
The file follows this pattern, and blank fields are ignored:
{Name},{Address},{Username}
Example of source.txt
1
Router,192.168.1.1,admin
2
Raspberry pi,192.168.1.15,pi
3
Home media center,192.168.1.16
4
Work,81.138.33.19
Copied!
Convert CSV to SSH Config
Use the following command to convert your CSV file to ssh config:
Linux
1
awk -F',' \
2
  '{print "Host " $1 "\n\tHostname " $2; if ($3) { print "\tUser " $3 } }' \
3
  < source.txt > ssh_config
Copied!
Example of ssh_config
1
Host Router
2
  Hostname 192.168.1.1
3
  User admin
4
Host Raspberry pi
5
  Hostname 192.168.1.15
6
  User pi
7
Host Home media center
8
  Hostname 192.168.1.16
9
Host Work
10
  Hostname 81.138.33.19
Copied!

Termius Handbook - Previous

Importing Data

Import from PuTTY

Last modified 1yr ago

Copy link

Contents

Prepare the CSV File

Example of source.txt

Convert CSV to SSH Config

Example of ssh_config