"How can you upload a locally made drupal site?" See How To Use Filezilla to Transfer and Manage Files Securely on your VPS.

"I installed Drupal using the corresponding article..." What "corresponding article?"

Thank you for the reply.

I managed to set up an sftp with filezilla and browse my directories but still couldn't find it.

I used this article: https://www.digitalocean.com/community/articles/how-to-install-drupal-with-nginx-on-an-ubuntu-13-04-vps

Why are you looking for the /var/www/ directory (Apache's default root directory)? According to the article you cited, you're supposed to use Nginx (and not Apache).

"Is there a sites/all folder, or something equivalent?"

According to Step 3 of that same article, you were to (manually) create a new directory in which to store your drupal files. Did you do that?

"Will change to Nginx+Apache configuration."

Why would you want to do that?

"... but still couldn't find it."

Could not find, what?

You are 100% corretct. I messed up the tutorials and I think I did the Apache one. I have started the process from scratch and will pay more attention. There is a learning curve, it's my fault for trying to cut through it.

As to using both Nginx and Apache, both according to this article:
https://www.digitalocean.com/community/articles/how-to-configure-nginx-as-a-front-end-proxy-for-apache
and other sources it appears to be the more efficient choice. Correct me if I'm wrong but in this configuration the site has to go to the apache's directory, no?

I just finished setting up apache+nginx with a complete drupal instalation running!
The tutorial was a great help and everything works fine!

I even set it up for multiple drupal instalations, but I will have to check that out when the domain names come in!