Using Xenu Link Sleuth to Spot and Improve External Links in a Domain - Exporting data and analysis

(Page 3 of 4 )

The next thing to do is to export the Xenu data into some kind of a spreadsheet. If you are using MS Excel as a spreadsheet, this is easy to do, as compared to Open Office Calc.

To export the data, click File--- ?  Export Page Map to Tab Separated File , and type any file name you want. Do not include extensions as part of the file name; Xenu will do this automatically for you. Also make sure that "save as type" is a text file (*.txt).

You can save the exported data to your desktop. After that, to open the file in spreadsheet format, right click on the exported file, and then "Open With" Microsoft Excel. You should see five columns. They are:

• OriginPage
  
• LinkToPage 
  
• LinkToPageStatus 
  
• LinkToPageTitle 
  
• OriginPageDate

The LinkToPage is the URL target of the external links in your domain that can be found in OriginPage.

LinkToPageStatus will tell you if the URL is an external or an internal link. If it is an external link, it will show "Skip External." The other two columns are not very important for the analysis: LinkToPageTitle and OriginPageDate.

For easy analysis, rename the column name "OriginPage " to "Location of External Links" and "LinkToPage" to "External link URL."

You can then filter column C, "LinkToPageStatus," using MS Excel. To do that you will have to click data ? filter - ? autofilter , and then in column C select "Skip  External." Column C should now show all links going out to external domains.

Finally, select the area of the filtered result using your mouse and then click Edit --- > Copy. Insert a new worksheet by clicking "Insert - ? Worksheet," and rename it to final. In the blank area, paste the result.

After pasting the data, click "File ? Save As," type the filename you like, and then in the file type, select: "Microsoft Excel Workbook (*.xls)

By following these steps, you should end up with something that looks like the screen shot below:

Next: External Link Analysis >>
 

More Search Optimization Articles
More By Codex-M

Comments On: Using Xenu Link Sleuth to Spot and Improve External Links in a Domain

· Honestly, I don't see many usefulness in this tool , but sure I need to try it...    · Thanks for the comment. Basically this tool has an advantage of crawling the whole...    · Checking links on your website becomes extremely easy with Xenu, I use it for almost...    · Yes this can be used to spot your links in another site. If the site is large,...   >>> Post your comment now!