How to quickly open a CSV file using Google Sheets

Google DriveGoogle Workspace
Written By James Kimbley

CSV files are one of the most common file formats used to export data. It is also one of the most frustrating files to open. Windows will tend to open the file in Notepad if you don't have Excel installed - and Excel costs money to use. 

Google Sheets, however, is an alternative way to view, edit and use a CSV file. There are a couple more clicks involved but is pretty easy to open a CSV file in Google Sheets.

  • Upload your CSV file to Google Drive

  • Double click on the CSV file once it is uploaded

  • A preview of your CSV file will appear

  • At the top of the preview select "Open with"

  • Then select "Google Sheets"

  • Your CSV file will now open in Google Sheets

James Kimbley
I am the founder of Kimbley IT.
www.kimbley.com
Previous

Founder's Log and IT Support Statistics for October 2020
Next

You don't need Microsoft Office when you use Google Workspace