Converting string into Column and values

I am very new to creating macros in excel and I am importing data from Quickbooks. I would like to convert the below string from a particular cell into a column and then populate the column with the values in the string.

<CustomField><Name>Fabric</Name><Value>Canvas</Value></CustomField><CustomField><Name>Status</Name><Value>New</Value></CustomField>

Column name would be Fabric and the value in the column would be Canvas and then create another column named Status and the value would be New.

I will have up to 100 rows of data that I would like to perform this on and any help with the code would be much appreciated.