Using IMPORTDATA Function in Google Sheets (from URL or CSV)

Published: 31 August 2017
on channel: Spreadsheet Point

77,377

385

IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma-separated value) or .tsv (tab-separated value) file.

This can be useful if you’re working with data that is available online in a .csv/.tsv file.

00:00 Intro
00:10 How is IMPORTDATA useful?
01:06 Importing Census Data into Google Sheets
02:05 Using IMPORTDATA with VLOOKUP
04:25 Ref Error in IMPORTDATA function

Using IMPORTDATA function, you can instantly get the data in Googe Sheets (instead of going the longer route of downloading the .csv/.tsv file and then copy-paste and format the data).

In this video, I will show you how to import the entire data set or part of a dataset using the IMPORTDATA function in Google Sheets.

IMPORTDATA function takes one single argument, which is the URL of the CSV/TSV file. Note that you need to use the entire URL including the HTTP or the HTTPS part. Also, the URL needs to be enclosed within double-quotes.

Read More about the IMPORTDATA Function here: https://productivityspot.com/importda...

Related Video (IMPORTRANGE Function in Google Sheets): • Using IMPORTRANGE Function in Google Sheets

Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint

This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets

You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/

#GoogleSheets #GoogleSheetsTips #Spreadsheet

IMPORTDATA function in Google Sheets, Using IMPORTDATA to fetch data from a CSV/TSV URL

On this page of the site you can watch the video online Using IMPORTDATA Function in Google Sheets (from URL or CSV) with a duration of hours minute second in good quality, which was uploaded by the user Spreadsheet Point 31 August 2017, share the link with friends and acquaintances, this video has already been watched 77,377 times on youtube and it was liked by 385 viewers. Enjoy your viewing!