Home > Shopify Tutorials > Import CSV Files into Google Sheets

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

Last updated: September 01, 2024
Written and researched by experts at AvadaLearn more about our methodology

By Sam Nguyen

CEO Avada Commerce

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.

login

Step 2: Click Blank

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

blank

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.

Import

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.

choose

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.

dialog

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:

before

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

after

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.

edit

Conclusion

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