yes, exactly that, drag an xml file into excel, choose "generate a schema", then you can drag and drop fields from your nested structure,

parent records will be repeated intelligently for nested sub-records.