So before moving ahead make sure you already know how to download the whois database file from whoisdb.co dashboard.
After you are done with downloading the whoisdb.co file in excel now here are some simple steps on how to filter out the excel data according to your needs.
- Step1: Open you downloaded excel sheet of whois db and apply filter in the first row. Check the below screenshot-
- STEP 2: Hide or Delete Columns : C-J & AD – BF
Very Important step , this will ensure you don’t have any unnecessary data to complicate your leads excel file and thus makes it difficult for calling or emailing guy to get the marketing started.
Also if you delete the columns the processing of data in the excel sheet gets very fast. Few customers have complaint us that the file opens slowly. Well if you have a desktop or laptop with SSD hardisk and minimum of 4GB RAM then this wont be an issue. Else just delete the unnecessary data columns to make your file lighter.
Note: Yes you can delete the columns since as per now none of our customer requires this data but if you do well you always have the file to download again from the portal. - STEP 3: Filter the Data to Remove the rows with name, phone number and email ids hidden (or privacy protected)
- Some of you are confused why are so many rows have data hidden in that case kindly read out our blog to know why Domain Registrant details are hidden in some case.
Filter Your whois Database excel to remove Privacy protected dummy data :-
Below are the top privacy protection companies that you can remove from your data sheet –
| Privacy service provided by Withheld for Privacy ehf |
| Contact Privacy Inc. |
| REDACTED FOR PRIVACY |
| PrivacyGuardian.org llc |
| Privacy Protect LLC (PrivacyProtect.org) |
| Dynadot Privacy Service |
| whoisproxy.com |
| Whois Privacy Protection |
| Privacy Protection |
| Private by Design LLC |
| DOMAIN PRIVACY SERVICE FBO REGISTRANT |
| Data Protected |
| Knock Knock WHOIS Not There LLC |
| Domain Protection Services Inc. |
| Private Person |
| GDPR Masked |
| DATA REDACTED |
| Identity Protection Service |
| Domain Privacy Service FBO Registrant. |
| PRIVACYPROTECTION.COM LLC |
| Proxy Protection LLC |
| Whois Privacy Protection Service |
| WhoisSecure |
| whoisproxy |
| Domain International Services Limited |
| Statutory Masking Enabled |
| Whois Privacy Protection |
| Private Registry Authority |
| GreenHost |
| Whoisprotection.biz |
| NameBrightPrivacy.com |
| Whoisprotection.cc |
| Domain Data Guard |
| Whois Privacy Protection |
| Data Privacy Protected |
| GLOBAL DOMAIN PRIVACY SERVICES INC |
| Domain Whois Protection Service |
| www.DropCatch.com |
| Moniker Privacy Services |
| Privacy protection service – whoisproxy.ru |
| Domain Privacy Trustee SA |
| GKG.NET Domain Proxy Service |
Related Posts
Many of our customers are asking how to use the bonus tools and the...
The protection of domain registrant details has become a central point of discussion in...