-
How can i convert huge xml files to excel
Posted by on November 4, 2022 at 2:13 pmHi
i am analyzing site xml files but i have nearly 6 million in 117 xml link, which is impossible to be downloaded on PC
so is there a way to convert and extract it to google docs: excel
-
1 Reply
-
Do you just need the URLs? I’m guessing this will work in most cases:
`cat sitemap.xml | grep loc | awk -F ‘>’ ‘{print $2}’ | awk -F ‘<‘ ‘{print $1}’ >urls.csv`
Alternately, making a script to read an XML file and output a CSV file is a good exercise 🙂
-
Need to remember that Excel can only handle so many rows/columns of data
1,048,576 rows total, so anything more than that it will crash.
Log in to reply.