?>

Sometimes you’ll find yourself searching for large amounts of domains at a time, or scanning through a large list based on a search filter you’ve set up. Handling and keeping track of this activity isn’t necessarily difficult, but there are a few tips that can potentially make things more efficient for you.

While unassuming, Notepad is a brilliant program for helping your methodology along, offering an indispensable stripping directly connected to its intrinsic simplicity.

Getting Down to Data

As anyone who has blogged but written their text in Word instead of directly into the blogging platform knows, Notepad is the best and quickest way to strip formatting of all kinds out of a block of text data.

Programs tend to let you keep formatting if you like, usually with some degree of degradation, but Notepad is deliciously and purely limited in what it will retain.

So, for example, let’s say you search for domains while applying some kind of filter on whatever site you’re using (eg. 7 characters or less, between $100-500). Your search results, irregardless of platform, are likely to be a paginated (meaning results across multiple pages which you can navigate through) table of results.

These results may or may not be available in an easily exportable format like .csv for Excel. If you click and drag to select the data from this table and copy and paste it into Excel, you are likely to be carrying over the formatting of the page you’ve just copied, not only making the sheet ugly but potentially so ugly that basic Excel functionality like filtering becomes non-functional.

The De-Formatting Bridge

If you take your original click drag copy and paste it into a clean notepad file, it won’t look the same as what you’ve copied, but you will see that it already looks a bit more stripped down and table-organized. Now, copy and paste from Notepad into Excel and voila, clean table. At worst, you’ll need to slightly adjust one row or column, but for the most part, the job will be done.

There are likely other places where you will need to use Notepad in a similar way. Just get the thought process hard wired, such that if you ever find yourself in general trying to copy and paste from one area to another and it looks weird, your best bet may be to cross the Notepad bridge.

One warning, sometimes you will want a bit of the formatting you lose in the transition, for example some data being in bold type. As such, you will sometimes need to make a judgement call about what you gain versus what you lose.

Just remember, domaining is a data crunching numbers game, so do your best to keep not only your data as raw and usable as possible, but your process streamlined and quick as can be.

You must be logged in to leave a reply.