What are substance Painter files?

Substance Painter is a texture painting tool and spp is just the format used to save your work :it is not meant to be used anywhere else (not even in engines). You can export textures from painter to be used wherever you want.

What file format should I use when exporting my mesh to substance painter?

File format & Bit Depth

BMP.