Open a new or existing Google spreadsheet that you want to import the CSV data into.To import a CSV into Google Sheets, follow these steps: Additionally, I will show you how to convert CSV files into Google Sheets format through Google Drive. Sometimes copying and pasting can be very effective, and so I'll teach you this method as well, but for the most part it is way faster to use the 'Import' feature that is built into Google Sheets. Want more? Check out all the Google Sheets Tutorials.Several years ago, I didn't know that there was a super easy way to import CSV files into Google Sheets… and so I spent lots of time copying and pasting entire CSV files into my Google spreadsheets. In this tutorial, I covered how to open a CSV file in Google Sheets.

If you need to make edits to your CSV file or convert it to another format, follow these steps: Step 1ĭouble click on the CSV file in Google Drive to open the CSV viewer.Īt the top of the viewer, click on the Open With dropdown and select Google Sheets from the menu: Step 2Īfter a few seconds, the Google Sheets editor will open with a new Google Spreadsheet containing the data from your CSV file: Step 3Īll the features of Google Sheets are now available to edit your data, such as formatting, and formulas SummaryĮxample GSheets Spreadsheet: Make a copy of the example spreadsheetĮxample CSV Spreadsheet: Make a copy of the example spreadsheet

When a CSV file is double clicked, instead of opening in the Google Sheets editor, it will open in a read-only in the CSV viewer. The CSV icons are blue, unlike Google Sheets Icons, and they have a different shape from Google Docs icons: Opening CSV Files Identifying CSV Files in Google DriveĬSV files will appear in Google Drive with a different icon from Google Sheets Files or Google Docs. Google Sheets makes it easy to open CSV files, edit them and convert them into formats that support formatting and formulas. CSV files cannot contain formatting, formulas, or other more complicated features.

Many software packages export data in CSV, or comma separated value, format.ĬSV format is a simple spreadsheet format where each row is separated by a line break and each column within the rows is separated by a comma.

Open csv in google sheets