Following command on terminal (local). (Detailed explanation here)
scp your_file.csv [email protected]:/path/to/destination/directory
Following command on terminal (local; where you want to download the file)
scp -i path/to/pem/file/if/needed [email protected]:/path/to/the/file/to/download .
Don't forget "." at the end.