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

<strong>Founder, Entrepreneur & Investor at Kimbley IT Limited</strong>

<br><br>

My team organises your business IT with Google Workspace, AI, Cyber Security & Support in One Package, trusted by 65+ UK businesses. Kimbley IT is a Google Cloud Partner, and Google Workspace is at the heart of everything we do. We recommend it because we've spent nearly 20 years helping UK businesses get the most from it and not because anyone asked us to.

<br><br>

Connect with me:

<a href="https://www.linkedin.com/in/jameskimbley/">LinkedIn</a> •

<a href="https://www.threads.com/@james.kimbley">Threads</a> •

<a href="https://www.kimbley.com/blog?author=50c5e9d6e4b033df8f3030ec">View All Posts</a>

www.kimbley.com
Previous

A Fascinating Behind-the-Scenes Look at why you should never let a Building Contractor install your Computer Network!
Next

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