I've used InDesign regex for this in the past.
In my case, there was a business name data field in excel that had superscripted exponents (ex. My Company2 - as in 'My Company squared'). Since it was a predictable pattern I could use regex to superscript the '2'.
This procedure uses InDesign functions only. In other words, XMPie didn't create the superscript.
- Create an InDesign Character Style for the superscript
- Create an InDesign Paragraph Style
- Within this Paragraph Style, create a GREP Style
- Set Apply Style to your superscript Character Style created in step 1
- Set To Text to the regex pattern (This is tricky if you aren't familiar with regular expressions)
- Apply the Paragraph Style to the body of text
It's been awhile so this might be slightly off but should get you in the right direction. There are other ways depending on what's contained in your data.