Sunday, May 24, 2015

postheadericon How to Create a Plain Index of Links for your Blog?


No Crap! No background! You know the problem if you have been a blogger? You always wanted to create a page (some may call it an HTML sitemap or XML sitemap) on your blog that contained all the links to every single post you made on your blog? Isn't it? If yes search nowhere else? I will tell you few simple step to do so and it all for free. You don't spend a dime for it.

Let me cut the crap and come straight to the point. I am sure you would already be aware of how to build a free xml site map. If not google it right now and you will find hundreds of tools both offline and online . Pick the one you are comfortable with and generate a XML sitemap for your website or blog. What next huh?

Download the XML Sitemap as a .xml file on your computer. Now all you need a latest version of Microsoft-Excel program  installed on your computer. Any other spreadsheet program that supports XML should also do here. I am not promoting any OEM here. All you need is the ability to open the .XML file as a table.

Below are the steps to do so using Microsoft Excel program..

1.       Start MS-Excel (Don't expect me to tell you how to start excel. Still if you don't know google it)
2.       Click Open on the File menu.
3.       In the "Files of type" list, select XML files.
4.       Navigate and Select the XML Sitemap file you want to open
5.       click Open button.
6.       You may be prompted a dialog like the one below. I am using MS Excel 2013. Select "As as XML Table.
Machine generated alternative text: O nXML  Please select how you would like to open this file:  @ As an XML table  o  As a read-only workbook  o  use the XML Source task pane

If you XML Sitemap contains all the links you will be able to view all the links in a column. You are free to select, copy, and paste the links alone the way u like.

Machine generated alternative text: HOME  Cut  Copy  Paste  INSERT  Calibri  PAGE LAYOUT  Font  Links.xlsx - Excel  VIEW  DEVELOPER  TABLE TOOLS  DESIGN  FORMULAS  DATA  REVIEW  Alignment  Conditional  Formatting •  Format as Cell  Table • Styles •  Styles  Inset  Number  nsl:lastmod  Wrap Text  Merge & Center  2  4  6  7  8  g  10  11  12  13  14  15  16  17  18  20  21  22  23  •S Format Painter  Clipboard  X •V' nsl:loc  Microsoft Office Ti s Tricks and Secrets  nsl:loc  http://ms-office-tips.blogspot.in/  http://ms-office-tips.blogspot.in/2010/02/microsoft-powerpoint-quick-shortcuts.html  http://ms-office-tips.blogspot.in/2ccg/12/quick-find-next-repeat-search-without.html  http://ms-office-tips.blogspot.in/2010 02 01 archive.html  http://ms-office-tips.blogspot.in/2009 12 01 archive.html  http://ms-office-tips.blogspot.in/200B 11 01 archive.html  http://ms-office-tips.blogspot.in/2ccg/12/recover-deleted-items.html  http://ms-office-tips.blogspot.in/2ccg/12/how-outlook-deleted-items-folder-works.html  http://ms-office-tips.blogspot.in/2ccg/12/convert-formula-into-value-magic-fg-kev.html  http://ms-office-tips.blogspot.in/2ccg/12/auto-complete-functions-in-excel.html  http://ms-office-tips.blogspot.in/2009/12/auto-complete-functions-in-excel-2007.html  http://ms-office-tips.blogspot.in/2ccg/12/did-vou-know-vou-could-quicklv-delete 04.html  http://ms-office-tips.blogspot.in/2ccg/12/did-vou-know-you-could-quickly-delete.html  http://ms-office-tips.blogspot.in/2ccg/12/microsoft-office-2010-in-beta-state.html  http://ms-office-tips.blogspot.in/2009/12/making-vour-excel-2CC7-files-backward.html  http://ms-office-tips.blogspot.in/2ccg/12/files-tvpes-and-excel-2007.html  http://ms-office-tips.blogspot.in/2009/12/grouping-worksheets-in-ms-excel.html  http://ms-office-tips.blogspot.in/2ccg/12/use-sheet-navigation-buttons-in-ms.html  http://ms-office-tips.blogspot.in/2ccg/12/ms-excel-editing-tips-and-tricks.html  http://ms-office-tips.blogspot.in/2ccg/12/ms-excel-formatting-editing-selection.html  http://ms-office-tips.blogspot.in12009/11/ms-excel-navigation-shortcuts.html  nsl:changefreq nsl:priority  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily  daily

All Done!! I hope you like this quick tip and thank you for reading!!!!

0 comments:

Sponsored Links



Forex Platform Trading / Forex Trading Software

Betting on Horse Racing Successfully

Easy Home Surveillance under $30 / Buy Spy Camera