Rated 5 out of 5 stars

Or you could just right click on the name of your file in the Downloads window and select "Show in Finder."

Not only opens your download folder but also takes you directly to any file you choose in the list of downloads.