If you're trying to download a spreadsheet or other data export, and you don't have Excel installed, you might see a 'blank file' or 'Wordpad' icon on the file, like so:

To open it in Google Sheets to edit and share it, open your Google Drive, then click and drag the CSV file onto your drive like so:

Then, use the button or dropdown to open the file in Google Sheets: