How to collect date From XML to XL

Transact-SQL
1

Hi, How to collect Data from XML to XL in same manner.

2

can you add a little more detail like ddl, what you have and what you are trying to accomplish?