Now, click on the ‘File’ menu, and then click ‘Import’. If you have opened an existing sheet, create a new sheet within the file. Open Google Sheets, and either create a new document or open an existing one. How to import a CSV file into Google Sheets? It is the simplicity that is the beauty of CSV files. If you want better visibility of the data, perform data analysis, you can easily do that by importing it to a spreadsheet program or anywhere else. The reason is, that a CSV file is a simple text file, devoid of any formatting, and the values are separated just by commas, making it easy for different programs to differentiate between the entries.ĭue to the simple organization of a CSV file, with comma separation, a CSV file can easily be viewed in a text editor, and any changes could be made pretty easily. The biggest advantage is, that a CSV file consumes less space compared to other types of files having the same set of records. There are several advantages of a CSV file. It isn’t that tough but you need to know the steps.

So, today I will basically talk about how to import a CSV file into Google Sheets. While it is extremely straightforward to import a CSV file to Microsoft Excel, simply by opening the file in Microsoft Excel, the process is a little different in Google Sheets.

This type of file is called a CSV file, where CSV is the acronym of Comma separated values.ĭue to its simple organization, a CSV file can easily be imported to spreadsheet programs like Microsoft Excel, OpenOffice Calc, or even Google Sheets. One of the simplest ways to store records is in a text file, and separate the entries by a comma (,). Data can be available in different formats, and based on how we want to process or analyze the data, we have to organize it strategically to meet our goals.

Upload csv to google sheets