1.Select all the URLs that you want to export and press CTRL+C.
2.Then, in MS excel, use CTRL+V to paste the URLs. The URLs will be copied as long list of URLs separated by a white space just like below
Then, click on the Data tab, Text to column, “delimited” and then tick “space” to get the following:
3. Press finish. Now, every column of the spreadsheet should contain a URL. Select the first row by clicking on 1 since it contains all the URLs and press CTRL+C.
Then, click on the cell at A2, right click and press Paste special. Then, check “transpose” at the bottom of the Paste special window.
This is it, every URL are now in a new line of your MS excel spreadsheet