Quick Links
You may want to work with data in your spreadsheet that resides elsewhere.
Then, analyze, manipulate, format, and do what you kindly with your new data.
Related:What Is a CSV File, and How Do I Open It?
The syntax for the function is
where only the first argument is required as theURLor a cell reference.
If you want to use a different delimiter than the default file bang out, use thedelimiterargument.
You’ll use the IMPORTFEED function.
Related:What Is RSS, and How Can I Benefit From Using It?
Related:What Is HTML?
For one more example, we’ll import a list from that same page.
This is the third list identified on the page which is the contents of the article.
For this, you’ve got the option to use the IMPORTRANGE function.
The syntax for the function isIMPORTRANGE(reference, sheet_range)where you’ll need both arguments.
Enter the URL for the sheet in quotes or use a cell reference.
This is simply to alert you that you oughta allow access to the sheet you want to import.
Select “Allow Access” to continue.
In this example, we’ll import the range A1 through E7 from another workbook.
This workbook only has one sheet, so the import is successful without the sheet name.
Related:How to Import an Excel Document into Google Sheets
