Import profiles from a table

Fifty accounts already live in a spreadsheet, and entering them one by one is fifty identical sets of decisions. The path is Profiles → From a spreadsheet → Choose a file → Create profiles. Nothing is created until you have seen which column became which field.

Prepare the file

A CSV from Excel, from a sheet or from your supplier. Commas, semicolons and tabs are all read, the byte order mark Excel writes is dropped, and a quoted cell may hold commas and line breaks.

Download an example writes a file with the column names the importer already knows.

Which columns are understood

Name, group, use case, fingerprint template, notes, tags and the two-factor key are matched by meaning rather than by an exact string, in several languages at once.

A column that matches nothing is listed as left out. Guessing would produce profiles that look right and behave wrong.

The proxy may arrive one way or two

A single proxy column in the seller's own notation is read, and so are separate host, port, protocol, proxy login and proxy password columns.

Only column names that say proxy are taken as the proxy's credentials. A bare Login or Password column in a table of accounts belongs to the account.

A named but unknown protocol is reported

An empty protocol column is a fair guess and becomes http. A column that says something else is a reason to tell you rather than to quietly downgrade the connection.

Run the import

The first screen is a preview and creates nothing.

1
Press From a spreadsheet
On the toolbar above the list of profiles.
2
Press Choose a file
The file name and the number of rows appear.
3
Read the column map
Columns left out are named and so are rows read only in part.
4
Press Create profiles
It reports how many were made and how many proxies went to the library.

Bringing back an exported file

Export all writes your profiles to a file, and Import reads it back. A restore keeps each profile's number wherever it can, because the number is the seed of the fingerprint.

When you are signed in the account issues the numbers instead, so some profiles come back as a different machine and the app says how many.

What the import does not carry

A spreadsheet holds no cookies, so imported profiles start logged out. What keeps a profile logged in travels in a transfer file or through a shared folder instead.

What this does not do

It does not guess a column. What cannot be matched is named and left out.
It does not create anything before you press the button. The preview is the whole point of the first screen.
It does not bring sessions with it. A table holds settings, and settings are not logins.

Where this is decided

Each step above is one place in the code and one stand.

The reader handles the shapes a real spreadsheet arrives in: apps/desktop/test/csv-import.js
A bare Password column is never read as the proxy password: apps/desktop/test/csv-proxy-columns.js
Rows carrying a group are not silently dropped: apps/desktop/test/csv-import-groups.js
A two-factor key survives an export and an import unchanged: apps/desktop/test/config-import-2fa.js

Questions

My file is semicolon separated.: That is read. The delimiter is taken from the header line and counted outside quotes, so a quoted heading with commas does not confuse it.
My column names are in Russian.: They are matched by meaning in several languages, so Название, Группа and Прокси are understood as they are.
What happens to a broken row?: Rows read only in part are listed by line number, and one checkbox skips them instead of stopping the whole import.
Can the table set the operating system?: Yes. Words like windows, linux, android and tablet resolve to the matching template, in Russian too.

Next to this

Bring your table in

The free plan gives two profiles, with no time limit and no card.

Download ARMANOS Knowledge base