This will open a new window where you are prompted to select the file that you would like to import. Step #2: Click on the “File” menu, then click on the “Import” button. Once the spreadsheet is open, then we can take the next step. Step #1: Log in to Google Sheets and then click on the button that says “Start a new spreadsheet,” and select “Blank.”Īs we’ll be importing our own file, we don’t want to use a pre-selected template and instead just want to use a blank file. Let’s dive into how you can convert a CSV file to Google Sheets: How to Import to Google Sheets With just a few clicks you can import CSV files into your Google Sheets account and begin to format and edit the data within your file. Importing CSV files into Google Sheets is relatively easy.

If you would like to turn a CSV file into a Google Sheets spreadsheet so that you can add formatting, visually change data, and in general make your data more presentable - follow the steps that are outlined in this article. Google Sheets is Google’s answer to Microsoft Excel and part of their wider suite of products that is available through Google Docs. However, it is important to understand that CSV files are just raw data, not a full spreadsheet that you would expect. CSV files are one of the most common file types for delivering data and creating reports.

Open csv file in google sheets