This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a lot of xml files which need to be imported into single excel file. I can able to import one by one but cannot select all at a time to import.
Is it possible to do through batch process or any other process?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You may refer the article given below for more information on how to import multiple XML data files into Excel, and check if that helps.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Great! I got 2/3 through my 800 or so .xml files. They all populated in different tabs and the mapping was preserved in each!
Then I got another error. It turns out that some of my files have the exact same name up to and beyond 30 characters. So there error told me that I can not have two sheets with the same name. How can we modify this script so that every sheet has a name that is less that 31 characters and yet has a completely unique name? 31 is actually the limit not 30.
Or even better would be how can we convince excel to let us have names that are longer then 31 characters? It would be great to be able to preserve the whole name??
Thank you,
Jonathan
add the bold line
.................
s = sFile
s = Replace(s, ".xml", "")
If Len(s) > 30 Then s = Left(s, 30)
For Each ws In ThisWorkbook.Sheets
If ws.Name = s Then ws.Delete
Next
...............