Free MS Excel 2007 Domain Spreadsheet to help members get a little more organized for 2009. This is made for excel 2007, it will not work on previous versions.
I have made a very simple domain spread sheet that lets you keep track of the domains you own. It is designed around using the Auto Filter, the little down arrow on each of the column headings. This lets you with any column sort by order, or filter your domains based on the criteria you have entered. You can single out all the .com's you own, the .net's, all your .com's parked at one company, etc, etc.
Here are the Columns.
Ext - The Domain extension is automatically entered based on the domain name you enter in the "Domain Name" Column. This lets you sort and filter out domains with the auto filter based on extension for quick viewing. This field is locked and cannot be edited.
Domain Name - Once entered domains with different extensions will automatically show up with different colors to help differentiate them.
Creation Date - Domains Creation Date, must be entered 15-mar-09 dd-mon-yr . You can sort by creation date with the auto filter.
Expiration Date - Domains Expiration Date, must be entered 15-mar-09 dd-mon-yr. Domains expiring in the current month will Turn the cell red, Domains expiring the following month are highlighted Orange. You can sort by expiration date with the auto filter.
Parking / Usage - Lets you specify where it is parked or what it's usage is, lets you sort and filter your domains based on the parking/usage.
Type - Lets you specify the type of domain, ie) generic,typo,speical, etc, lets you sort and filter your domains based on the type you enter.
Registrar - The registrar where your domain is.
This also shows a total of the domains in your spreadsheet on the far upper right.
There is also a "Sold Domains" Tab that lets you keep track of your sold domains with the following fields.
Ext - Extension is automatically entered based on the domain name you enter, this lets you sort and filter out domains you have sold based on ext for quick viewing.
Domain Name - Domain name you have sold.
Price Paid - Price you paid for the domain.
Price Sold - Price you sold the domain for.
Sold @ - The venue you sold the name at ie) sedo, afternic, dnforum, private, etc, this lets you sort and filter out domains based on the venue.
Escrow / Bank Charges - this lets you enter any commission or fees you incurred for your sale.
Profit - This field automatically calculates your profit by subtracting the price you paid and your bank charges from the sale price.
Method - This lets you enter the method how you sold it, auction, $1 auction, buy it now, email, etc. this lets you sort and filter out different methods for selling letting you pinpoint where you have had the most success.
Date Sold - The date the domain was sold, enter as 10-mar-09 dd-mon-yr.
AS well on the far right of this section it totals your domain costs, revenues, bank charges, total profits, and total domains sold.
POST IN THIS THREAD THAT YOU WANT THE SPREADSHEET AND I WILL PM YOU THE DOWNLOAD LINK. If you notice any problems or have some suggestions feel free to drop me a PM.
Feel free to make changes that suit your needs.
Enjoy
I have made a very simple domain spread sheet that lets you keep track of the domains you own. It is designed around using the Auto Filter, the little down arrow on each of the column headings. This lets you with any column sort by order, or filter your domains based on the criteria you have entered. You can single out all the .com's you own, the .net's, all your .com's parked at one company, etc, etc.
Here are the Columns.
Ext - The Domain extension is automatically entered based on the domain name you enter in the "Domain Name" Column. This lets you sort and filter out domains with the auto filter based on extension for quick viewing. This field is locked and cannot be edited.
Domain Name - Once entered domains with different extensions will automatically show up with different colors to help differentiate them.
Creation Date - Domains Creation Date, must be entered 15-mar-09 dd-mon-yr . You can sort by creation date with the auto filter.
Expiration Date - Domains Expiration Date, must be entered 15-mar-09 dd-mon-yr. Domains expiring in the current month will Turn the cell red, Domains expiring the following month are highlighted Orange. You can sort by expiration date with the auto filter.
Parking / Usage - Lets you specify where it is parked or what it's usage is, lets you sort and filter your domains based on the parking/usage.
Type - Lets you specify the type of domain, ie) generic,typo,speical, etc, lets you sort and filter your domains based on the type you enter.
Registrar - The registrar where your domain is.
This also shows a total of the domains in your spreadsheet on the far upper right.
There is also a "Sold Domains" Tab that lets you keep track of your sold domains with the following fields.
Ext - Extension is automatically entered based on the domain name you enter, this lets you sort and filter out domains you have sold based on ext for quick viewing.
Domain Name - Domain name you have sold.
Price Paid - Price you paid for the domain.
Price Sold - Price you sold the domain for.
Sold @ - The venue you sold the name at ie) sedo, afternic, dnforum, private, etc, this lets you sort and filter out domains based on the venue.
Escrow / Bank Charges - this lets you enter any commission or fees you incurred for your sale.
Profit - This field automatically calculates your profit by subtracting the price you paid and your bank charges from the sale price.
Method - This lets you enter the method how you sold it, auction, $1 auction, buy it now, email, etc. this lets you sort and filter out different methods for selling letting you pinpoint where you have had the most success.
Date Sold - The date the domain was sold, enter as 10-mar-09 dd-mon-yr.
AS well on the far right of this section it totals your domain costs, revenues, bank charges, total profits, and total domains sold.
POST IN THIS THREAD THAT YOU WANT THE SPREADSHEET AND I WILL PM YOU THE DOWNLOAD LINK. If you notice any problems or have some suggestions feel free to drop me a PM.
Feel free to make changes that suit your needs.
Enjoy
Last edited:
