People who work with several data usually process them with statistical software in order to perform advanced calculus that is only possible with these software tools. However, for the actual representation of the data and the sharing of the results with other — especially with technically less advanced people — a spreadsheet with its built-in graphic plotting possibilities might be the better option. The output generated by statistical software is usually a .csv or .tsv file. This, we have to load the data from these file types into a spreadsheet. While you can do such an import manually in Google Sheets, if this is a repeated task involved in your daily work, it quickly becomes time-consuming and inefficient to perform such a task manually. Moreover, you may work with various databases that change every time. Thus, you may require a way to automate the process of importing constantly updated CSV or TSV files into Google Sheets. This article now describes to import automatically CSV file into Google Sheets.
Import automatically CSV file: How to do it?
In this article, you will learn how to automatically import a CSV or TSV file into a Google Sheet with the help of Sheetgo. Sheetgo is an add-on for Google Sheets that allows you to import and export data from one spreadsheet to another. Hereby we mean spreadsheets in the wider sense as it can also import data from a CSV or TSV file. This feature of Sheetgo is very useful when you need to automatically load data into a Google Sheet from these kinds of files which are generated by statistical software. For example, if you have to do a statistical report with R or Matlab every week and then use the results in a Google Sheet to share it with others or visualise the data.
In the following, we outline the steps to automatically import CSV or TSV files:
1) Install the add-on and open Sheetgo in a Google Sheet
To install Sheetgo for free, go here and install it. Then, create a new spreadsheet and click on Add-on menu to open it:
2) Create an import connection
Now you need to import data from the CSV file. So, the next step to follow is to click on Import and select the the Connect connection type.
3) Select CSV (or TSV) file
Next, choose the CSV file that you want to import into your Google Sheet. Remember that you have to upload the file to your Google Drive before selecting it as a file to import. You can use the Google Drive Desktop client to do this automatically.
You can either search for your CSV file using the lens icon or by clicking on SEARCH IN DRIVE at the bottom to search inside your Google Drive.
4) Configure update frequency of the connection
After choosing the file from your Google Drive, you can further customise the connection. For instance, you can change the name of the tab where data will be imported to by changing the connection name. Moreover, you can define an automatic update frequency such as Hourly, Daily, Weekly or Monthly.
You have got it!
Now, you have created a link between a CSV (or TSV) file and one of your Google Sheets. This means that data from a CSV file will be automatically loaded into your spreadsheet (import automatically CSV), and if this CSV file changes over time, these changes will be reflected in the spreadsheet automatically.