• White Hat SEO

  How can i convert huge xml files to excel

  Posted by aliyas192000 on November 4, 2022 at 2:13 pm

  Hi

  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

  aliyas192000 replied 2 years, 7 months ago 2 Members · 1 Reply
• 1 Reply

• 

  johnmu

  Guest

  November 4, 2022 at 2:26 pm

  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 🙂

• 

  Neither-Emu7933

  Guest

  November 4, 2022 at 9:32 pm

  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