Home > Shopify Tutorials > Import CSV Files into Google Sheets

Import CSV Files into Google Sheets: A Step-By-Step Guide

Last updated: April 01, 2024
This article has been written and researched by our expert Avada through a precise methodology. Learn more about our methodology





In the previous post, I have discussed with you the definition of CSV files and some important points about using these files on Shopify. So I suppose that you have already had a necessary background which is enough to understand the CSV files’ definition as well as their characteristic. Now we will turn to a higher stage in the process of mastering CSV file which is learning the method to import a CSV file into your Google Sheets.

Here is a brief instruction on how to import CSV files into Google Sheets for Desktop. I believe that after following these steps, you will be able to master it in no time.

Related Posts:

To import CSV files into Google Sheets

Step 1: Open Google Sheets

First, click this link to login into your Google account. After that, you need to open your Google Sheets page.


Step 2: Click Blank

To create a new spreadsheet, click the Blank option which is on the Google Sheets page.


Step 3: Select Import

When a new spreadsheet which named Untitled spreadsheet appears, you then click the File section which is right under the name of that spreadsheet. After seeing a drop-down list, select the Import section which is in the fourth line of this list.


Step 4: Select a file {#select-file)

In step four, you will have to find and select the file that you want to edit. But there is one thing that you will need to memorize is that a CSV file with UTF-8 encoding is the only format which you are allowed to apply to import or export a file from your Shopify page. So, you can choose a file from various source such as My driver, Shared with me, Recent, or Upload as long as the file you select is a CSV file with UTF-8 encoding format.


Step 5: Choose an option

After you have selected a specific CSV file, a dialog which is called the Import file dialog will appear. In here, you can choose the options which you prefer right under the Import action, Separator character, and Convert text to numbers and dates sections.


Step 6: Click Import

When you have finished choosing the options, click the Import button to complete the importing process.

Here is a picture to illustrate the CSV format before uploading:


After you have imported it into Google Sheets, it will look like this:


From the Untitled Spreadsheet, you can edit your CSV file. You can add more details, delete some information, change the name of this file, and so on.



The above information which you have just read is the step-by-step tutorial on how to import CSV files into Google Sheets for Desktop. Hoping that this instruction would become helpful for you and your crew when dealing with CSV files.

Sam Nguyen is the CEO and founder of Avada Commerce, an e-commerce solution provider headquartered in Singapore. He is an expert on the Shopify e-commerce platform for online stores and retail point-of-sale systems. Sam loves talking about e-commerce and he aims to help over a million online businesses grow and thrive.

People also searched for