To find xml code from excel (My site Rank First in Google)

Here i have found new way to develop xml file from excel. Using these excel to xml file conversion this site rank first in google.

step 1: open MS Excel 2007 or any version

First create root tag and child tag
step 2: choose the cell which you want to convert into xml file.

use the formula =b2&c2&d2 like that <Root><parent><child>child node</child></parent></Root>
step 3: In the above figure use the formula  in the formula box type it as root tag first as
         =B2&A2
      =B3&D3&A3&E3 (Drage and drop untill the last child node
      =C3&C2
 the next cell assign the root tag or child tag name in the next cell and the drag and place the cell which
Then copy the final output and paste it in the notepad and save as filename.xml
and then open the xml file from your browser it will show in the format of xml.

Xml file for the about excel file..

xml file generated
i think this code will useful for SEO purpose to generate sitemap, to generate xml file. This code will bring up my site rank first in google.

1 comment:

  1. Wow...its a nice post..

    I was looking for this information through this net...

    Atlast i got it.. Now it will be useful for me..

    Thanks a lot

    ReplyDelete