There's a ton of remixes/acoustics etc on YouTube that I like to listen to but can't find any way of getting them on to my playlist on Spotify. Also some artists haven't released certain EP's on Spotify.
You can add local files through the desktop client and then sync to other devices,
There are some caveats to that, DRM for example.
Check this article.