To handle this easily, you can simply: Open the spreadsheet. Insert a new column A before the URL path. Put your domain n cell A3 (assuming B2 contains your domain which oddly is the only URL to display completely) so you don't cick the lower right corner of the Shadow Making cell with your newly added domain to copy the domain to the bottom of the spreadsheet. Select the data from columns A and B (the domain and the path) and copy it into Notepad. Select everything in Notepad. Paste it in column B and delete column A. You now have the same list but Shadow Making with the full URL. Get the data in Gephi Here we will upload the source/target CSV file that we created earlier and named working.csv. This will create the edges and nodes that Gephi needs to build the graphics. (For our purposes here, a node is a page and an edge represents the link between pages.)
To import the spreadsheet, simply open Gephi and go to: File > Import Spreadsheet. A new window will open where you will select your file and select (since we are importing connections between pages). It will look like: Import edges into Gephi In the next screen Shadow Making you will see a few options (very limited in this example). Just make sure the box is checked and click Next. Import edges into Gephi Assuming it opens to the Overview tab (which it should on first use), you'll be presented with something that looks like: Imported Gephi A little messy, and Shadow Making we're not going to clean it up yet. First, we'll head to the data lab and export the nodes (read: pages). Gephi Data Lab Once in the data lab, make sure you are looking at the nodes by clicking on the Nodes button in the top left.
Once there, simply export the table to have a csv of all your nodes. When you open the csv it should have the following columns: ID Label Time setting You'll Shadow Making add a fourth column named after the metric you want to extract. Here I will extract the referring domains as shown in Search Console, so I will label the fourth column (D)referring domains. The fifth will be D2 (just below the column D header), enter the following formula: =IFERROR(INDEX('search console'!$C$2:$C$ 136 , MATCH(A2, 'search console'!$A$2:$A$ 136 , 0), 1) In my Shadow Making example here, there are 136 rows in my Search Console data. Yours may differ, in which case the 136 in the above formula should be replaced with the number of rows in your list. Also, if you want to list your link counts and not list the domains, you need to change the Cs to Bs so that the search is in column B instead of C.