Using IMPORTDATA Function in Google Sheets (from URL or CSV) смотреть онлайн

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/importdata-google-sheets/

Related Video (IMPORTRANGE Function in Google Sheets): https://www.youtube.com/watch?v=MS89ABKQPRc

Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - https://www.youtube.com/c/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