tips Excel Tips for Domainers

[cocaseco]

I've been wanting to start this thread for awhile, so here goes.

I know many of us use Excel to manage portfolios, big and small. Mine has developed over time as I learned new functions to implement. I thought it would be handy to have a central repository of those tips that anyone could use and not have to reinvent the wheel. Hopefully, there are some Excel masters that can share what they do. I do assume at least a basic level of Excel familiarity here.

I'll start with a way to automatically separate out the TLD into its own column.

So like probably everyone, my first column is the full name of my domain, including TLD. I realize I could do one column for name and another for TLD manually, but I like to have my spreadsheet do as much automatically as possible. The reason for having these two columns is that sometimes I want to look at full names, and sometimes I want to analyze my portfolio by TLD composition.

To do this I use the "Right" command written like this: =RIGHT(A19,LEN(A19)-FIND(".",A19)) This formula would be in cell B19 and the full name would be in A19.

The Excel RIGHT function extracts a substring from a string starting from the right-most character.
The Excel LEN function returns the length of the specified string. So I am using the DOT as the starting point
The Excel FIND function returns the location of a substring in a string. The search is case-sensitive.

In common language, this string starts on the right of the entry and moves inward until it finds a dot. Then it captures everything in between the end and the dot and uses that data to fill the cell.

So now, when I enter the full name in the first field, the second field is automatically populated with just the TLD.

That's my tip, hope it helps someone....I hope others have more to share.

 

[korganian]

Came across this thread, it's been quite long since last post here. I think many still use Excel, though. I'm adding a couple tips I find useful (valid for MS Excel 2007):

1. Select your column with Expiration date, go to Home tab -> press Conditional formatting in Styles buttons group -> Color Scales -> select 1st color option. Names will get color marked, in a green-red range. The sooner name expires, the redder it will appear.

Show attachment 33334


2. When adding some descriptive tags to the name, that should be picked from a list, add a listbox control to pick them from a pre-established list. Say, you have a column named "Planned use" (@cocaseco , your example). Select the corresponding range, in that column, go to Data tab -> Data Validation ->Data Validation - > Settings tab, select "List" option in the "Allow" field. In "Source" field, type in the list you want, separated by comma or semicolon (depends on your Excel settings). Example: Hold, Sell, Brand, Develop. Press OK. When selecting one of the cells, you will be able to pick a tag, out of your list:

Show attachment 33345

If anyone needs more, just let me know.

Regards

Thanks. Everyone without MS Office can use free Google Sheets instead because these same commands work with it as well.

 

[GBA]

Don't you always get MS Access when you get Excel?

Access is FAR better suited for the things you guys are going, and SQL code is (mostly) transportable to other platforms.

I'd say it all depends on your needs. Excel and Access are not interchangeable:

Excel is good for storing simple data, with comprehensive analyzing tools.
Access is good for storing complex data, with simple analyzing tools.

I used both, and for domaining needs, Excel is more than enough, imo.

For the ones still choosing, here are some highlights in Excel vs Access:

https://support.office.com/en-us/ar...nd-Excel-c435ade4-be8d-4809-81b0-b4a78b3cde3a

 

[Name Trader]

Or LibreOffice if you use Linux.

 

[vivaldi]

Google Sheets, Libre Office and Open Office might cover very simple needs. As soon as it gets just a little bit complicated all those apps fail over and over again. It's like comparing a Trabant to a Tesla.

 

[vivaldi]

Don't be shy everyone, share your awesome excel tips

 

[CJ6]

Should I see I have a spreadsheet program for my avatar computer? I think I have a Word-like program. Not sure about spreadsheet, though.

 

[barcher]

I know this is an older thread, but can I ask for a copy of your Excel template too please. I have sent you a PM. If that's possible, I would very much appreciate it.

Per this - previously in thread -

Wow. That's amazing one. Would it be possible for you to give out the excel sheet you've been using ( without your data ofcourse )

Sure, I think I could do that. Might take me a few days until I can trim it down. PM me.

Thank you very much, in advance

 

[vivaldi]

If you want a quick WHOIS check without third party code you can use this:

=HYPERLINK("https://gwhois.org/"&A4&""&B4&"+dns", "WHOIS")

The name and extension are split into two cells, just remove "&B4&" if you have the full domain in one cell.

 

[Domains - Wanted]

...To do this I use the "Right" command written like this: =RIGHT(A19,LEN(A19)-FIND(".",A19)) This formula would be in cell B19 and the full name would be in A19...

Great thread
Sadly, above seems incompatible with OpenOffice Calc, though (returns Err:508). Has anyone made this work in Calc?