October 6, 2022
You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet. With the functions we’ll describe here, you can pull data into your sheet from external sources. Then, analyze, manipulate, format,…

You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet.

With the functions we’ll describe here, you can pull data into your sheet from external sources. Then, analyze, manipulate, format, and do what you please with your new data.

IMPORTDATA for a CSV or TSV File

If you see a CSV or TSV file on a website you’d like to import, you can use the IMPORTDATA function.

RELATED: What Is a CSV File, and How Do I Open It?

The syntax for the function is IMPORTDATA(reference, delimiter, locale) where only the first argument is required as the URL or a cell reference. If you want to use a different delimiter than the default file type, use the delimiter argument. And if you need to change the language, use the locale argument with the region’s code.

Here, we’ll import a CSV file using the URL with this formula:

=IMPORTDATA(“https://www.bls.gov/cew/classifications/aggregation/agg-level-titles-csv.csv”)

In this example, we…

Read Full Article Source

Leave a Reply

Your email address will not be published.