XML l in full is Extensible Markup Language, is a language similar to HTML. While you are working with Google Sheets and you want to turn an XML document into spreadsheets it might be difficult to do so. However, if you try to open the same file in Microsoft excel it will display an error message it will show the same if your try to open even with Google Sheets. Google Sheets always support text files, Excel, or CSV. If you try to copy and paste your document to google Sheets still it will show you different things. You can use the following method step by step to open your XML document in Google Sheets.
Step 1
Step 2
Step 3
Step 4
Step 5