IT.COM

discuss Are we making excel sheets correctly?

NameSilo
Watch

NetPark

Established Member
Impact
99
Sometimes we intend to bid on own domains on marketplaces. It is important for domainers easily manage own portfolio in case of inventory of hundreds, thousands domains. We have to quickly find appropriate domain in our portfolio. For example, if broker is annonsing request of 5L domain, we have to quickly find that domains to offer him. There are different applications to manage such a big portfolios.

But I think most of us using excel for this job. But are we making excel sheets correctly? Are we arranging domains correctly by gtlds, categories, languages, renew dates, calculation revenue by sales, etc?

I would like to everyone share their experience and tools under this tread. It is also useful to share screenshot of excel sheets.
DomainsSheet.jpg
 
Last edited:
3
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
It's a good start.
What is important is to keep track of each domain and anniversary dates.
Anything else is an extra.

But I prefer to use a database. It's easier to make queries like, for example to find names matching certain patterns.
Extracting TLD or length is easy to do with formulas in Excel. But more sophisticated operations such as finding brandables like CVCVV is easier in SQL possibly combined with regex.

I also like to categorize domains when I can, along with tags and relevant keywords

If you have a large portfolio you could also combine it with a synonyms directory.
For example if you have a request for security-related domains, you could fetch domains with compatible keywords like guard or protection, and thus broaden the search.
 
9
•••
Thank you @Kate for your thougts and suggestions. Could you advice any database software for that works?
 
0
•••
It's a good start.
What is important is to keep track of each domain and anniversary dates.
Anything else is an extra.

But I prefer to use a database. It's easier to make queries like, for example to find names matching certain patterns.
Extracting TLD or length is easy to do with formulas in Excel. But more sophisticated operations such as finding brandables like CVCVV is easier in SQL possibly combined with regex.

I also like to categorize domains when I can, along with tags and relevant keywords

If you have a large portfolio you could also combine it with a synonyms directory.
For example if you have a request for security-related domains, you could fetch domains with compatible keywords like guard or protection, and thus broaden the search.

Would you recommend to learn how to use a database?
 
1
•••
2
•••
It's a good start.
What is important is to keep track of each domain and anniversary dates.
Anything else is an extra.

But I prefer to use a database. It's easier to make queries like, for example to find names matching certain patterns.
Extracting TLD or length is easy to do with formulas in Excel. But more sophisticated operations such as finding brandables like CVCVV is easier in SQL possibly combined with regex.

I also like to categorize domains when I can, along with tags and relevant keywords

If you have a large portfolio you could also combine it with a synonyms directory.
For example if you have a request for security-related domains, you could fetch domains with compatible keywords like guard or protection, and thus broaden the search.


You can use regex in Excel too. You just need to create a custom formula using VBA and then call your custom formula within the cell. :xf.wink:.

I do agree a database is better though. Excel performance is poor with large amounts of data and SQL is better for data analysis.
 
4
•••
I wrote a simple software to record these tables, use SQLite, a small database.
 
3
•••
SQLite is cool :)
Otherwise there is Access for those who are stuck on windows.
 
6
•••
I have a small portfolio and use excel.
I mark creation date, expiration date, registrar, min price and bin I expect to get.
I also mark if I plan to develop it as website and its DA.
I also mark where I upload it (GD, Flippa, Afternic etc).
And I also use color scheme: red if I dont plan to renewal it, yellow maybe, green means my personal domains.
 
Last edited:
4
•••
....
 

Attachments

  • upload_2018-11-18_18-5-34.jpeg
    upload_2018-11-18_18-5-34.jpeg
    461.5 KB · Views: 56
Last edited:
3
•••
Set up a database - in the long run it will save you so much time, especially as the core data remains consistent.

Spreadsheet formats work better when you need to totally replace the data on a regular/daily basis, but for "mostly consistent" data, a simple database and saved queries will work best.
 
6
•••
Back