Rob Daviau, Patreon
What is this place? Who are you people? Read this helpful guide to find out!
Want to advertise with GWJ? Sorry, we don't run ads on the website, just the podcast. If you need something else, hit us up!
I've got a sitemap in ror.xml format that I want to import into an excel spreadsheet, but excel doesn't seem to like this kind of xml file. Anyone know of a way to import it correctly? I just need the URL in column A, and the URL title in column B.
"There was violence."
Import/save as a csv (comma or space seperated value) file?
When you import something as a csv file it will let you configure the import like wether to remove empty values in between commas:
one, two,,four can be stored into columns as one two <blank> four or one two four
Being fangoriously devoured by a gelatinous monster.
Hard for me to figure out what's going on without seeing the field itself, I'm afraid. Is it really just a .csv format, or could you get it into that format?
Words... are a big deal.
The only way writers are going to get better is if they get some decent damned editing.
Thanks for the suggestions guys. I actually found a solution going a different way, but the ror.xml file I was referring to is the one generated when you use the site xml-sitemaps.com to map out your urls. It does not appear to be in CSV format. I wanted to use this version because it was the only one separating out the URLs from the webpage titles. However I downloaded a free app that does this for me and in CSV, so problem solved!