UPDATE: A new version of DKM which requires information from Ahrefs.com will be available in February of 2020. This original version will still be available as well.
This post will only make sense to a few hundred people in the world, but that’s okay. It’s for those special hundreds that this post is being written.
To those of you who know who you are, you’ve already seen the following explanation in video form, but you might also appreciate it in mostly-text form with a few images thrown in for good measure.
Making a Copy of DKME
I (and others) often refer to DKME as just DKM. I think this is because 4 letters just feels too long, especially when virtually all the other related acronyms are 3 letters long or less.
The full name of this tool, as shown below, is Diamond Keyword Miner Elite.
If, when you visit the page that hosts the original version of DKM, you don’t see something very similar to the above – in particular, the main menu that includes “File” – then you probably accidentally clicked the arrow at the far right that hides some of this information.
To reveal it again, click that arrow (which would now be pointing down) again. You’ll see your own avatar at the upper right (where mine is now) and probably several other colorful circles representing other users. They may not be the same animals shown in the screenshot above.
This original version is, as indicated in the blue button, a “view only” copy. You can’t play with it as you need to until you make a copy for yourself.
To make a copy, click the File menu and select “Make a copy”.
Since this is a Google spreadsheet, Google will place the copy into your Google Drive. (I’m assuming you have a Google account by this time and won’t go into details of creating one here.)
At this point, you have the option of renaming this spreadsheet to anything you want. You can also accept the default (as shown) and change the name later.
After you click the blue OK button, the DKM sheet will open in another tab within your browser. You can leave it open or close it and find it again later in your Drive.
Importing a CSV into DKM
When you’re ready with your special CSV file “in hand”, you will go to Drive and open the DKM sheet you made a copy of earlier. (Or if you still have it open, just go to that browser tab.)
The CSV you got from what is affectionately called TE, is very likely in the Downloads folder on your computer. This is true whether you have a Windows PC or an Apple Mac.
Note: Sometimes a computer system will automatically open a related program when it acquires a new file it can read. For example, when you download a CSV file from TE, your computer may attempt to load it into Excel (on a Windows PC) or Numbers (on an Apple Mac).
If your computer does this, just close the program without saving the file. You want an unadulterated CSV for the steps below.
You’re going to import this CSV into your DKM sheet.
The import function is also under the File menu of your DKM sheet.
After you click Import, click the Upload “tab” on the Import file window that pops up.
At this point, I always click the blue “Select a file from your computer” button, but you can drag a file here too, like it says. The file you want is the CSV you downloaded earlier from TE.
Notice that you didn’t do (or shouldn’t have done) anything to the DKM sheet – other than possibly changing the name – before importing the CSV. In particular, you don’t want to move the spreadsheet’s cursor away from cell A1. Leave that blue outline around the word “Position” just as you got it. This will be important for an upcoming step.
After you select (or drag) your CSV file, you will see this next popup.
The one change to make here (above) is to click “Replace data at selected cell”, as I have already done above. The selected cell must still be A1 as noted earlier.
Then click the blue (Notice how Google is consistent with the blue buttons?) Import data button.
Your CSV should populate your DKM after a few seconds. You may notice a small, gray progress bar in the upper right of the sheet. When it’s done, you’re done!
Enjoy your latest DKM creation.