- Open the URL of the source data.
- Press F12 to open Chrome Developer Tools
- Press Control+Shift+P to open the Command Menu.
- Start typing
Reload the page to see if the content that you want to import is shown, if it's shown it could be imported by using Google Sheets built-in functions, otherwise it's not possible.
IMPORTDATA, IMPORTFEED, IMPORTHTML and IMPORTXML are able to get content from resources hosted on websites that are:
- Publicly available. This means that the resource doesn't require authorization / to be logged in into any service to access it.
- The content is "static". This mean that if you open the resource using the view source code option of modern web browsers it will be displayed as plain text.
- The content has the appropied structure.
- IMPORTDATA works with structured content as
tsv doesn't matter of the file extension of the resource.
- IMPORTFEED works with marked up content as ATOM/RSS
- IMPORTHTML works with marked up content as HTML that includes properly markedup list or tables.
- IMPORTXML works with marked up content as XML or any of its variants like XHTML.
On W3C Markup Validator there are several tools to checkout is the resources had been properly marked up.
Regarding CSV check out Are there known services to validate CSV files
It's worth to note that the spreadsheet
- should have enough room for the imported content; Google Sheets has a 5 million cell limit by spreadsheet, according to this post a columns limit of 18278, and a 50 thousand characters as cell content even as a value or formula.
- it doesn't handle well large in-cell content; the "limit" depends on the user screen size and resolution as now it's possible to zoom in/out.