A CSV file is a spreadsheet saved in a simple format that Excel, Google Sheets, and Numbers can all write. With one, you can:
- Add many domains at once, each with its own price and settings.
- Change settings on domains already in your account (e.g., new buy now prices for 200 domains).
- Bring in a list you exported from another service, such as Afternic, Sedo, or Dan.com.
Only the cells you fill in change anything. An empty cell leaves that setting as it is.
Start with an export
The easiest file to start from is your own. On the "Added" tab of Domain names , select "Export". When the file is ready, select "Download CSV". It lists every domain in your account with every setting, in exactly the format the import reads back.
The export has two header rows. The first names each column; the second lists the values that column accepts. Edit the cells you want to change and save the file as CSV. Keep every column, even the ones you leave alone: a cell you do not edit changes nothing, and the full set of columns is how the import recognizes your file.
Import your file
- Go to Import domain names and select "CSV file upload".
- Under "Select CSV file to import", choose your file, then select "Preview".
- Check the preview, described below.
- Select "Add domains". Your file is processed in the background.
The preview
The preview shows the first rows of your file, one column of your file per line. Beside each, a menu says which setting it fills.
- For an export of your own with all its columns, every column is matched for you. For any other file, choose the setting for each column, and leave a column on "(none)" to ignore it.
- One column must be the domain.
- "Skip rows" is the number of header rows at the top of your file. Set it to 1 for a file with one row of column names, or 2 for an export of your own whose columns you changed. A complete export of your own skips its two header rows for you.
- "Display name casing" sets how each domain name is capitalized on your landers. Leave "Apply casing to" on "Only new domains" to keep the names of domains already in your account as they are.
- Each column label shows a check when its cells are valid. Select a label with a problem to see what is wrong, fix your file, and select "Preview" again.
"Add domains" appears once a domain column is chosen and the preview shows no problems. The preview checks only the first rows, so a problem further down shows up in the results instead.
Writing values
| In a cell | What it does |
|---|---|
| Nothing (empty) | Leaves the setting as it is. A new domain gets your account setting. |
(inherit) | Uses your account setting for this domain from now on. |
(disabled) | For prices and text: removes the value (e.g., removes a buy now price). For on and off settings, write no instead. |
(empty) | For text and lists: sets an empty value (e.g., clears a list of categories). |
yes or no | For on and off settings. true, false, 1 and 0 work too. |
| A whole number | Prices, in US dollars without cents (e.g., 4500). 0 turns the price off. |
| A percentage | "Min. offer BIN percentage", with the percent sign, from 1% to 100% (e.g., 50%). |
Settings with a fixed set of choices take these words, written exactly as shown:
| Column | Accepted values |
|---|---|
| For sale | for_sale, promote_only (off market, still promoted), unlisted |
| Accept offers | always, with_price, without_price, never |
| Price display | after (after email confirmation), before, standalone (straight to checkout) |
| Layout | dynamic (Auto), vertical (Narrow width), horizontal (Standard width), full_header |
| Payment logos | always, when_priced, never |
The second header row of your export lists the values for every other column.
What an import changes
- A domain that is not in your account is added and checked for verification, like on Add domains .
- A domain already in your account keeps everything except the cells you filled in.
- A domain you removed before is added back, with a warning so you can check it was intended.
- Domains that are not in your file are left alone. An import never removes a domain.
Check the results
After you select "Add domains", you land on the import's page. Its tabs sort each domain by what happened:
| Tab | Shows |
|---|---|
| New | Domains added to your account. |
| Updated | Domains already in your account whose settings changed. |
| Ignored | Domains already in your account with nothing to change. |
| Warnings | Domains to check (e.g., one you had removed before). |
| Errors | Rows that were not imported. The reason shows under the domain. |
"All" lists every domain in the import. Every import is listed on Imports , with how many domains were new, updated, ignored, had warnings or had errors. On an import's page, "Download original file" gives you the file back, and "Re-run import" runs the same file again. A re-run applies every value in that file again, so it undoes changes you made to those settings since.
File rules
- Save the file as CSV with commas between the columns, in UTF-8 (in Excel: "CSV UTF-8").
- The file can be up to 16 MiB.
- A row with a value that cannot be read is skipped as a whole and listed under "Errors". Fix it and import that row again.
- Every row needs a domain. The import stops at the first row whose domain cell is empty, or that has fewer cells than your columns, so remove empty rows at the end of your file.
