How to Import CSV files to Google Sheets (Beginner’s Guide)

how to Import CSV files to Google Sheets 10

Hi everyone, In this article, we will learn how to import CSV files to google sheets.

We all have to deal with CSV Comma Separated Values in our day-to-day tasks.CSV format is used mostly in databases and large directories. Still, many tools and software products use CSV format to store files and data. This article is designed to teach you how to use CSV files in google sheets, we will see how to import CSV into google sheets. We will see how they can be imported into Google sheets properly from Excel, or spreadsheet file format.

The CSV files store data in tabular form (table-like structures), where we have rows and columns, but they are delimited by commas or sometimes semi-colons, but in google sheets, we have defined cells we keep out data within cells. We will see how comma-separated value files behave when imported into google sheets.

See also  Extract Numbers from Strings in Google Sheets [REGEX Functions]

CSV files to Google Sheets

CSV files are used highly and mostly in the databases. Databases like SQL use Comma Separated values format and since they have huge data inside databases, so the values are difficult to maintain in CSV format. We, therefore, use this method, we may import our database files into MS word or Google docs, but they interpret them as CSV. But when we import the CSV in google sheets, google sheet is powerful enough to break from the commas and put them into different cells and make the file more readable for every user.

Google sheets detect commas in CSV and break the values into separate cells delimited by commas. Although we can do this using other methods as well, it’s automatically done by google sheets when a CSV file is imported.

  • Fast and easy to convert CSV files
  • To maintain the readability of CSV files
See also  What does IDLE Mean on Google Sheets?

How to Import CSV files to Google Sheets

Here, in the step-by-step procedure, we have two easy methods to import CSV files into google sheets. Both methods are very easy and simple having 3-4 steps. to learn them properly I will recommend you to follow me with the methods and practice each method.

How to Import CSV files to Google Sheets From Local Computer

In this section, we will learn how to import CSV files to google sheets from a local computer. For this, you should have a file in a directory of your local computer. In case you don’t have a CSV file to practice, I am attaching a link below from where you can get dummy CSV files of any length and size for absolutely free.

Get a Free Dummy CSV file here

Step 1

Open Google sheets Home

how to Import CSV files to Google Sheets 1

how to Import CSV files to Google Sheets 2

how to Import CSV files to Google Sheets 3

how to Import CSV files to Google Sheets 4

Step 2

Click on the Folder icon on the right side “Open File Picker”

how to Import CSV files to Google Sheets 5

Step 3

A new window will appear in the center, click on upload

how to Import CSV files to Google Sheets 6

Step 4

Drag and drop, or click on “Select a file from your device

how to Import CSV files to Google Sheets 7

Step 5

Your file directory will open

how to Import CSV files to Google Sheets 8

Step 6

Right-click on the file and click the first option “Select

how to Import CSV files to Google Sheets 9

Step 7

Your file will be imported, and now it is opened in google sheets
how to Import CSV files to Google Sheets 10

This method is very easy and quick, this is how to import CSV files to Google Sheets from a local computer.

See also  How to Add a Trendline in Google Sheets [Complete Guide]

How to Import CSV files to Google Sheets from Google Drive

In this section we will see another similar method – we learn how to import CSV files to Google Sheets from Google drive. For this method, you must have your file uploaded to the file. We will cover uploading files on the drive also in this section.

Follow me with this example to practice this method, you do not get into any trouble in the future.

Step 1

Open Google Drive

how to Import CSV files to Google Sheets 11

how to Import CSV files to Google Sheets 12

how to Import CSV files to Google Sheets 13

Step 2

Google Drive Home

how to Import CSV files to Google Sheets 14

Step 3

Click on New

how to Import CSV files to Google Sheets 15

Step 4

Click on File upload

how to Import CSV files to Google Sheets 16

Step 5

Select the file

how to Import CSV files to Google Sheets 17

Step 6

The file is uploaded, click on it

how to Import CSV files to Google Sheets 18

Step 7

The file is opened now

how to Import CSV files to Google Sheets 19

Step 8

Click on Open with > Google Sheets

how to Import CSV files to Google Sheets 20

Step 9

CSV File is successfully opened with Google Sheets

how to Import CSV files to Google Sheets 21

This is how the google drive method works, this is how to import CSV files to Google Sheets using google drive

See also  How to Change Text Case in Google Sheets [Complete Guide]

How to Import CSV files to Google Sheets Automatically Using Add-ons – Sheetgo

In this section, we will learn how to import CSV files to Google Sheets automatically using the add-on – Sheetgo from google drive. Using Sheetgo we can automatically import CSV files placed into the drive at a fixed time of a day, we can specify the hour, we can specify the frequency like every day, every week, etc. We can also define certain actions to be performed on the file. And most importantly this is a live connection is some changes are made in the file stored in google drive, they will be automatically reflected in the google sheets file.

Let’s see how to install and use the Sheetgo add-on

Note: This add-on gives one week completely free trial, after the trial, you can continue using this add-on with the limited feature or you can continue by purchasing a plan.

Let’s move on to the steps

Step 1

Go to Extensions > Add-ons – Get add-ons

how to Import CSV files to Google Sheets 22

Step 2

Search “Sheetgo”

how to Import CSV files to Google Sheets 23

Step 3

Click on Sheetgo in the results

how to Import CSV files to Google Sheets 24

Step 4

Click on install

how to Import CSV files to Google Sheets 25

Step 5

Click Continue

how to Import CSV files to Google Sheets 26

Step 6

Select a google account

how to Import CSV files to Google Sheets 27

Step 7

Click Allow

how to Import CSV files to Google Sheets 28

Step 8

Click Done

how to Import CSV files to Google Sheets 29

Step 9

Go to Extensions > Add-ons > view document add-ons

how to Import CSV files to Google Sheets 30

Step 10

On the right side, the Sheetgo box will appear, click on use

how to Import CSV files to Google Sheets 31

This is how you can install and use Sheetgo to automate CSV to Google sheets very easily

This tutorial is not intended to teach about Sheetgo, it’s easy to use you can simply follow the guideline given by the sheet to use it.

See also  How to Use QUERY Function in Google Sheets (User Guide)

Converting Colon Separated Values to Comma Separated Values

Some files have a colon instead of a comma and they are also referred to as CSV files. These files have a colon after every value and it can cause a problem when importing to google sheets. So, we will make it a comma-separated value file from colon separated value file. It is pretty straightforward.

Step 1

Open your colon-separated file with any word editor, (notepad, word, docs, etc), in this example, I am using notepad

how to Import CSV files to Google Sheets 32

Step 2

Go to edit > replace (ctrl + h is the shortcut)

how to Import CSV files to Google Sheets 33

Step 3

In find type; semi-colon or: colon, and in replace type a , comma (as per your file separator, it can be a colon or semi-colon)

how to Import CSV files to Google Sheets 34

Step 4

Click on replace all

how to Import CSV files to Google Sheets 35

Step 5

Save your file (Ctrl + S) and close

how to Import CSV files to Google Sheets 36

Now your file is a pure CSV file you can verify by viewing it or importing it to google sheets. Enjoy.

See also  How to Sort Rows in Google Sheets [Best Practice]

Recap

We have learned how to import CSV files to Google sheets, we have learned 2 simple and one advanced way to import CSV into google sheets, firstly we saw how we can import a CSV to google sheets by using google sheets, then we saw how to import CSV file to google sheets using google drive method. Then we saw an advanced way an add-on method to automatically import the CSV files to google sheets and also make a live connection so the changes to the CSV file inside the google drive will automatically be reflected into the Google sheet file. In last we have seen a problem and resolved it using the very easy method, we saw how to convert any Separate values to comma-separated values using a simple find and replace method.

See also  How to Convert Excel to Google Sheets and Google Sheets to Excel (Easy Guide)

Notes

  • CSV can be separated by commas on the semicolon
  • Separated by semicolon, colon, comma, all care called CSV comma separated values in the convention.
  • Sheetgo add-on is a paid tool after a free 1-week trial
  • Sheetgo can be complex to use for beginners, I will provide a complete guide on it so you can learn Sheetgo exclusively.

See also  How to use IFS Function in Google Sheets (With Examples)

FAQs

How do I import CSV into sheets?

You have two methods to import CSV into sheets, first, you can open your google sheets home, then click on the file picker folder icon to open a window in which you can select upload and can select any file from your local computer folder. The file will be opened will the google sheets and will be imported directly into a new file.

How do I convert colon separated to comma separated?

It is pretty easy it can be done manually but it’s highly not recommended, instead do the same work automatically and quickly by using the find and replace feature this feature is available in every word editor like Ms word, google docs, or even notepad and notepad++.

See also  How to Change Text Color Using Conditional Formatting in Google Sheets

Conclusion

Wrapping up how to import CSV files to google sheets, we have learned how to import CSV files to google sheets using three different ways. We have seen two simple and quick ways to import CSV files in google sheets. We have seen how to use google drive to import CSV and also we have seen how to directly import CSV into google sheets, there is another easy way go to file > Open and select a file to open on the existing google sheet file, but it may lose your current data on the existing opened google sheet file that’s why I did not include this method. So that’s all from how to import CSV files to google sheets.

I hope you find this article helpful, if yes please do share it, like it, and consider subscribing to the Office Demy blog. See you guys soon in the next tutorial till then take care, and keep learning with Office Demy. Thank you

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general