I am looking for a simple solution to a problem that I am having. I have several websites and each one has its own sitemap. I would like an application or maybe a macro in excel that can pull each sitemap, combine and convert into 1 excel csv file.
I have found an application online (here is a link to the software [login to view URL]) that will do exactly what I want (ie..load a text file of urls, and convert to 1 csv file). However, it only provides certain fields of info, not the entire xml file.
This can be a standalone application such as the demo I provided or done by macro, I am open to however you can do this. I will need to run it daily and it will eventually have several thousand records, so it will need to be fast.
If something is unclear, please ask.
For a sample, please provide a demo using these 2 files.
[login to view URL]
[login to view URL]