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. If you accidentally have not read the previous post, please click here to read it.
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.
First, click this link to login into your
Google account. After that, you need to open your
Google Sheets page.
To create a new spreadsheet, click the
Blank option which is on the
Google Sheets page.
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.
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
Shared with me,
Upload as long as the file you select is a CSV file with UTF-8 encoding format.
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
Separator character, and
Convert text to numbers and dates sections.
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:
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.