Thursday 12 April 2012

Tutorial: How to extract ALL URLs directly into excel

Lets take an example of www.crmdomain.com. We need to extract all the URLs from this website including the orphanaged ones .

Step 1: Open the excel and go to the Data tab. Click on Data >From Other Sources >From XML Data Import


Step 2: When it open , put the complete URL and click OPEN


Step 3: When you click open, it will connect to the server and after this it will ask you few things, just click OK and here you are:




So now you can directly import the URLs in your excel sheet and share it with your colleagues/ clients etc.

No comments:

Post a Comment