get all the posts and hyperlinks from blogger to excel sheet

how to get all the posts and hyperlinks from blogger to excel sheet

 

 

• open excel
• click on [data] on menu bar
• select [from web]
• enter the url http://www.blogger.com/feeds/xxxxxxxxxx/posts/default
  replace xxxxx with your blogger id (check the id next to the url address when you login to blogger)
• click go
• it will import all the urls including blogger internal links --> go to the appropriate column mostly the column name would be href13
• where you will all your blog posts and filter the excel sheet to get the right posts after removing all the unwanted links through filter.