Import Domains (file)
Importing domain list from Excel (CSV) file is similar to adding a long list of domain names to the portfolio/marketplace database, except the domain list is compiled in a table with the form fields represented by columns, while each row of the table holds a domain name and relevant data. The data fields can be empty. The table is then saved as .csv file, ready to be imported. An example of such file can be found here.
Steps to Bulk Domain names from Excel File
- Prepare the excel sheet data/table and save it as .csv format
- Each row of the table represents a domain.
- When saving the file as .csv, you must indicate (use) | as Field delimiter. The delimiter character is called pipe - see picture
- Enclosure is also a must. Enclosure is a character that specifies the field enclosure character. It should be "
- The columns in the file you want to import must match the columns of the table on the database server. In all there are 29 columns and only Column3 -Domain name (lower case) - is compulsory. All others can be empty.
- "Leave Empty"Â field - will be automatically generated by the program.
- "Optional"Â field - you may select or enter the value(s) to be used if the field is empty. For example, in your file you can leave the domain category field empty, and then select from the drop-down list.
Your excel file columns must have ALL the columns and STRICTLY be in this order:
| Column1 | - Category (number), for multiple categories, separate the numbers by comma. For example: 1, 5, 6 | - optional |
|---|---|---|
| Column2 | - Domain name First Letter | - leave empty |
| Column3 | - Domain / LowerCase. Must be unique. No repeatition. lower case e.g. mydomain.com | -Â required |
| Column4 | - Domain name (upper case) | - leave empty |
| Column5 | - Domain name (camel case) camel case e.g. MyDomain.com | - optional |
| Column6 | - Domain name (slug) | - leave empty |
| Column7 | - Domain name extension | - leave empty |
| Column8 | - Domain name length (number of characters) | - leave empty |
| Column9 | - Domain Keywords | - optional |
| Column10 | - Domain Description | - optional |
| Column11 | - WHOIS Data. Domain Updated Date | - leave empty |
| Column12 | - WHOIS Data. Domain Created Date | - leave empty |
| Column13 | - WHOIS Data. Domain Expires Date | - leave empty |
| Column14 | - WHOIS Data. Domain Registrar | - leave empty |
| Column15 | - WHOIS Data. Domain DNServer(s) | - leave empty |
| Column16 | - WHOIS Data. Domain Age | - leave empty |
| Column17 | - Domain name statistics (visitors per day, CPC value etc.) | - optional |
| Column18 | - Cost Price - number without currency sign) The price for which you purchased the domain. By default - $12, i.e. registration fee. For internal use only, will not be displayed to the public | - optional |
| Column19 | - BIN Price (Buy It Now price, i.e. the price for which you want to sell the domain without bidding or negotiation - number without currency sign) | - optional |
| Column20 | - Minimum Bid Price (number without currency sign) Default - 20 | - optional |
| Column21 | - Auction type (digit) can have one of three values: 0 - BIN Only (Default) 1 - Make Offer Only 2 - BIN + Make Offer | - optional |
| Column22 | - External MarketPlaces (number), for multiple External MarketPlaces, separate the numbers by comma. For example: 3, 5, 6, 9 External marketplaces where the domain has been listed. For references only, serves as a reminder to remove the listing from the platforms after the domain has been sold. For internal use only, will not be displayed to the public | - optional |
| Column23 | - Re-direct buyers to External MarketPlace: Optional. If a domain is listed on external marketplace, you can re-direct buyers from your website to the domain page on the external market. Buyer will complete the purchase there. Be ready to pay sales commission to such marketplace. If the external marketplace is not in the list, then add it (or ask the Admin to do so) - by clicking necessary item on the left sidebar menu. | - optional |
| Column24 | - Analog sales comparison (market data) | - optional |
| Column25 | - Domain display status (1, 2 or 0) If empty 1 will be used, meaning active/display to the public. 2 - domain sold and will be displayed with SOLD, action buttons not active | - optional |
| Column26 | - Domain is featured or premium (1 or 0) If empty 0 will be used, meaning it's not featured nor premium. The domain will be displayed along the general lsit and not the feature domain block on the main page | - optional |
| Column27 | - Domain image file (if you want to display an image or logo as background for the domain) | - optional |
| Column28 | - Hits. Number of views/hits/type-in traffic domain has received since publication - 0 | - leave empty |
| Column29 | - Date when added to the database | - leave empty |
- As you can notice, only the domain name is strictly required. However, All the columns must be present and in the order specified above.
Upon submission, before adding them to portfolio/marketplace DNHAT will read the domains and calculate necessary input for the empty fields, eg. uppercase, extension, first letter, whois data etc. - You can download sample files here
- Save the excel file as .cvs file (pipe as field delimiter - see picture)
- Browse to select the cvs file.
- Click submit or upload.
- Once you see the success message after importing, then the data is successfully imported
Preparing your excel File with your domain list
| File with domains to import: | |
|---|---|
| Extract WHOIS data for the domains after submission? | Yes No If Yes, during addition of domain name to your portfolio, DNHat automatically connects to WHOIS remote server to extract vital data about the domain(s): registrar name, DNS, domain registration and expiration dates, domain age, etc. The information is appended to the domain profile before submitting and saving it to the database. You can connect and update domain(s) WHOIS data at any time. |
- As you can notice, only the domain name is strictly required. All the columns must be present, though.
- You can download sample files here
- Save the excel file as .cvs file (pipe as field delimiter - see picture below)
- Browse to select the cvs file.
- Click Submit
Preparing your excel File with your domain list
If necessary, after submission you may proceed to Active domain list Domains (Active) to edit each domain properties.
See also: How to add/edit Domain Logo/watermark. Special Notes
