Choose Skin

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
  • Preparing your excel File with your domain list

  • 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
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
  • Preparing your excel File with your domain list

  • Save the excel file as .cvs file (pipe as field delimiter - see picture below)
  • Browse to select the cvs file.
  • Click Submit

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


Convert domain list Excel table to CSV file
Convert domain list from Excel file to CSV
DNHat: Bulk Import Domain Names from File. Image 1 of 3
DNHat: Bulk Import Domain Names from File. Image 2 of 3
DNHat: Bulk Import Domain Names from File. Image 3 of 3


All Articles