.PNG is the most common file type that supports transparency. Just add an alpha layer, select the background and delete it. Sadly, .png doesn't work for TF2 sprays (for whatever reason), so I usually use the TarGa format.