How to create sitemap for 20,000 urls

How to?
#1

Hello everyone,

Does anyone have a simple process in which I can follow to copy and paste 20,000 urls I have in an excel sheet into https://webscraper.io/ effectively (No coding experience).

I've tried to manually edit the site map but can't seem to find an easy way of doing it without having to put each on in manually. (Also having an issue with the spacing/paragraph issue copying from excel into JSON)

Any help would be much appreciated.

Kind regards, Mrbeans

#2

Browser extension has a limit of 10'000 URLs for a sitemap.

Although, I will be very pleasantly surprised if the sitemap will not crash or you will not run out of RAM trying to iterate through all of the 10'000 URLs.

#3

Thanks Webber for your response.

Do you have a guide for 10,000 urls then which I can follow?