This is great, I'm pretty good with computers and excel, but the tricky little tick box had me stumped for much longer than i'd care to admit. You're a legend, thank you!
Been getting good stuff from you as a follower. I happen to have multiple xml files in a folder. After filter for only xml, I still have 4 nested tables in each xml. I transformed a sample file like you suggested. But how do I do this transformation for all xml files in the folder? (Basically, I'm having trouble extracting & joining/appending different nested tables on multiple files) Thanks.
Hello, I want to ask you, if i have an excel file mapped to an xml map. When i save the file as xml, the empty cells of the excel are not created in the xml file. So, how can i edit the xml to create empty xml tags for the empty elements in the excel file? Thank you in advenced.
How do you create a proper XML Schema file. I'm having issues. I have a valid XML file, I open it, Excel creates the XML Mapping/Schema but when I try to save imported spreadsheet data it fails. "Cannot save or export XML data. The XML maps in this workbook are not exportable."
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
I don't know who you are, but I NEED to thank you SO MUCH for upload this video. You saved my life!
This is great, I'm pretty good with computers and excel, but the tricky little tick box had me stumped for much longer than i'd care to admit.
You're a legend, thank you!
Glad it helped George!
Thanks! This was particularly helpful for weeding a single value out of multiple test records and presenting in tabular format.
Wow.. This video is useful and it served me as a good reference for my project.
Thank you. I have found exactly what I was looking for.
always wondered how to better handle all that text in an xml file.
thanks for the lesson!
Thank you! This video really saved me a lot of time...
Great explanation, thank you. DeltaXML have some really useful XML compare and merge tools with API for building into applications.
Been getting good stuff from you as a follower.
I happen to have multiple xml files in a folder. After filter for only xml, I still have 4 nested tables in each xml.
I transformed a sample file like you suggested. But how do I do this transformation for all xml files in the folder?
(Basically, I'm having trouble extracting & joining/appending different nested tables on multiple files)
Thanks.
Thanks for the great video, but where can I download that .xml file to practice ?
Thank you!
I wonder if you can explain how to do in a Mac Computer. I would really appreciated it. I have been looking for days.
Sorry, Excel for Mac doesn't support power query.
Thank you man !
Hello, I want to ask you, if i have an excel file mapped to an xml map. When i save the file as xml, the empty cells of the excel are not created in the xml file. So, how can i edit the xml to create empty xml tags for the empty elements in the excel file?
Thank you in advenced.
great thank you
great stuff!!!!
thanks! awesome
Can we add this process of importing xml data into excel in Vba Macro!?
Not sure. I avoid VBA.
I have a exported xml file from sql database which has 1.1 Million rows. Is it possible to work on it with power query?
Connect power query directly to the SQL database!
Then load it to the data model and you can work with the 1.1 M rows in a pivot table.
@@HowToExcelBlog thanks. Let me try that
Sir, if I modify some data in the spreadsheet and convert into xml, shall it work?
You can convert any proper XML into a table with power query.
how do I change the date format if the date shows all numbers after I import xml into excel
Depends what those numbers look like.
I need to do the opposite, help!!!
Thank you
No problem Felix!
@@HowToExcelBlog open xx on
❓
Watch in 1.5 speed. You are welcome
Definitely more efficient 😜
How do you create a proper XML Schema file. I'm having issues. I have a valid XML file, I open it, Excel creates the XML Mapping/Schema but when I try to save imported spreadsheet data it fails. "Cannot save or export XML data. The XML maps in this workbook are not exportable."
Can we send sms from Excel if yes Pease tell us process.
Yep, I wrote a blog post about it.
www.howtoexcel.org/microsoft-flow/sending-sms-text-messages/
How do I import an XML file that has more than a million lines of information?
You can add it to the data model and use a pivot table to analyze it.
I love u
We have a lot in common, because I love me too! 😂
น่ารัก
😂