Importing XML data

So you've got a bunch of XML data. How do you get it into PowerPivot? Various ideas:

1. Import it into Excel using its normal data input capabilities. Once you've got the data into a worksheet, you have two options depending on if you are going to modify it later on. If the data is dynamic, i.e. you might change it by-hand later on, then mark the range and convert it into a table.