Google, however, provides a lot of search operators and facilities to show you the information you are seeking. One of these operators is site. This operator can be used to get a list of all the URLs of a particular domain from Google Index. For example, if you enter the following in Google search: site:techwelkin.com The results will contain all the TechWelkin pages from Google’s index. The first page, as usual, will have 10 results and then you can go through result pages to view more pages. This method is okay if your website has a few pages. But if your website boasts of hundreds or thousands of pages —the above method will be difficult to use. Moreover, some SEO tools require a URL list to operate upon. Preparing such a list by copying indexed addresses from returned results is going to be very taxing. So, I am presenting a simpler solution here. STEP 1: Log into your Google account and then go to Google Drive. STEP 2: Create a new spreadsheet. STEP 3: Paste the following function in first cell: We have noticed that this method no longer works and Google no longer allows easy access to the list of indexed URLs. STEP 4: Now place the cursor in cell number A101 and paste the above function again after changing start param from 1 to 101 Repeat the fourth step for as long as you need to. Every time you’ll get 100 URLs. Don’t be greedy by changing num=100 to num=1000 … this will not work because Google does not return more than 100 results in one go. We hope this will help you. Share with us your questions and suggestions. Follow up question – Do you know if it is possible to pull the page title and meta description for each URL as well? here is the solution of your problem: “In order to show you the most relevant results, we have omitted some entries very similar to the 239 already displayed. If you like, you can repeat the search with the omitted results included.” Please go on last page of search result and you will find the above message. this is the main reason of differences. Regards, Kunal Bhopal thnks Thanks a lot, really helpful!! First I did ‘F2’ and pasted the link in Google Sheets but it didn’t work and then I did direct copy paste and it worked like a champ!! Superb!! Thanks, Anson “Error: Wrong number of arguments to IMPORTXML. Expected 2 arguments, but got 1 arguments.” =importXml(“https://www.google.com/search?q=site:tubeamplifierparts.com&num=100&start=101″,”//cite”) Thanks for the comment. I can think of no reason as to why there should be any difference. This formula simply gets the same index XML results which Google shows after formatting as HTML. I would suggest you double check if you’re using the formula in right way (you need to change the start value every time). I will let you know if a possible reason for such discrepancy would crop up in my mind. Glad you found this post useful! Stay tuned. Comment * Name * Email * Website
Δ
