Today I wanted a table of usb vendor and product ids in #excel... Could mangle this manually but its sometimes easier and always more reusable to try PowerBI.

Here's the code to pull and transform the list from http://www.linux-usb.org/usb.ids in to a nice excel table

Most of this you can do with the PowerBI tools rather than coding directly although I've tidied up the auto generated code for sharing