How to use .XSD file in Excel to create data XML files for File Input in SAP Cloud Apps

This video shows how to use the .XSD file from the Cloud Studio and use it as a template in Excel. Anyone can then use this Excel template to create XML files to be imported into SAP cloud (Cloud for Customer, BYD) in the File Input function.
BTW, the create datetime mentioned in the video should use this format as in "2013-12-03T14:11:00.0000000Z"

[@tobyteng7522]

Thank you. Helps a lot. Seems like elements with fixed values will not be exported unless it has been mapped..

[@mindfulengineer]

Thank you, I found this very useful. I had no idea Excel could do that. Thank you again for taking your time to make this video.

[@chellapandian.b]

Thanks for the explanation. The Date and time format should be 2018-01-01T11:38:00.0000000Z for C4C and ByD

[@EuripidisZ]

Great tutorial , very simple and straight forward.

[@jimrosser]

Thanks for the help!

[@jonny-banana6663]

Very nice! Thank you very much :)

[@aeromsp99422]

Hi, how come after exported file? the remaining cell data tag is not created for you. I tried for my workbook, still I am getting a empty tags for all other columns,,, could you help me out??

[@rushrpa3433]

Hi, I have tried the same steps, but unable to process since the following error displayed while clicking on import "Cannot save or export XML DATA, The XML maps in this workbook are not exportable."

[@Our1stPlanet]

Me to

[@jeffmichelson3156]

Lousy presentation