Start Free Trial
  1. SEJ
  2.  » 
  3. Tools

6 Ways To Export Your Backlink Data in Excel

6 Ways To Export Your Backlink Data in Excel

You might have noticed that I love tables in general and Excel in particular. Once you view any data in Excel, you notice things you wouldn’t have seen otherwise. The greatest benefits allowing to effectively process huge volumes of information are:

  • Sorting function;
  • Pivot tables;
  • Find / Replace option, etc.

Thus today I am listing 6 ways to export your backlink information to Excel to further work with it:

Continue Reading Below

1. With Yahoo! SiteExplorer you can export results to TSV file and open it as Excel:

Export to Excel: YSE

2. Some free internal analytics tools that track referrals offer an export feature.

Continue Reading Below
  • With Google Analytics you can save the report of referring domains (enhanced with plenty of browsing data per each linking domain: bounce rate, time spent on site; pages per visit, etc).
  • GetClicky also allows to export referral information (by playing with”date range” drop-down, you can effectively set the quantity of the links you want to export):

Export to Excel: GetClicky

3. Link Diagnosis tool (based on Yahoo API) offers a very handy export feature for the wide range of available reports:

Export to Excel: Link Diagnosis

4. Majestic SEO (reviewed previously) that rely on its own search engine and index offers an export feature for all the reports:

  • Linking domain overview;
  • External anchor text report;
  • Linking TLDs overview.

5. Google Webmaster Tools offer an export feature under “Pages with External Links” section:

Export to Excel: Google Webmaster Tools

6. You can export any search results that provide RSS feed to Google Spreadsheets (and then save as Excel): just take the following steps (thanks Distilled for the tip):

Continue Reading Below
  • search Google BlogSearch [link:];
  • copy the feed URL of the results (left column);
  • create a new spreadsheet in Google Docs;
  • paste the following in the very first cell:

=ImportFeed(“feed URL”)

Export to Excel: RSS


Subscribe to SEJ

Get our daily newsletter from SEJ's Founder Loren Baker about the latest news in the industry!

Topic(s) of Interest*
By clicking the "SUBSCRIBE" button, I agree and accept the content agreement and privacy policy of Search Engine Journal.

Ann Smarty

Brand amd Community Manager at Internet Marketing Ninjas

Ann Smarty is the blogger and community manager at Internet Marketing Ninjas. Ann's expertise in blogging and tools serve as ... [Read full bio]

Read the Next Article
Read the Next