Questions tagged [importdata]
For questions specifically about the Google Sheets function: IMPORTDATA()
21 questions
1
vote
1
answer
136
views
Trouble using IMPORTDATA when text includes commas
Shopify publishes a text file containing their Product Taxonomy online at the following URL:
https://help.shopify.com/txt/product_taxonomy/en.txt
I've pasted the file contents into Google Sheets as a ...
- 77
1
vote
2
answers
3k
views
Splitting JSON-Formatted Single Column Into Rows and Columns in Google Sheets
PROBLEM
Since Google Sheets doesn't natively support JSON data, which I'm importing, I'm trying to split the data into a matrix of four columns and an unfixed number of rows using only Google Sheets's ...
- 237
0
votes
1
answer
375
views
Google Sheets' IMPORTDATA randomly converts number
We have a simple REST endpoint that returns a number as a string. The number is rounded to two decimals and has a point, like this: 2385.1
Google Sheets then sometimes transforms this into 177418 or ...
- 103
0
votes
1
answer
80
views
IMPORTDATA pulls multiple date format even if cell format is specified
I am pulling weather data for a city from a server (visualcrossing.com) and it's giving me the results in CSV format:
Name,Date time,Maximum Temperature,Minimum Temperature,Temperature,Wind Chill,...
- 1
0
votes
1
answer
285
views
I want to get values from multiple URL's in Google Spreadsheet. IMPORTDATA doesnt work
I have 9000 lines with URL's in my Google Sheet.
Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10).
Every URL returns JSON like this:
{
"success": ...
- 1
1
vote
2
answers
161
views
Copying cell values to AVERAGE function
I’m pulling Free Cash Flow Data from Morningstar to Google Spreadsheet.
I have formula:
=IMPORTREGEX("http://financials.morningstar.com/ajax/exportKR2CSV.html?&callback=?&t="&B4,"Free ...
- 11
15
votes
2
answers
34k
views
How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?
Google Sheets has several import functions
IMPORTDATA
IMPORTFEED
IMPORTHTML
IMPORTXML
Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that ...
2
votes
1
answer
1k
views
Google Sheet "across spreadsheets you've created"
I have an error for an importdata function
Error
Loading data may take a while because of the large number of requests.
Try to reduce the amount of IMPORTHTML, IMPORTDATA, IMPORTFEED or
IMPORTXML ...
- 1,062
9
votes
2
answers
11k
views
IMPORTDATA Google Sheet CSV on Google Drive
So I'm starting to really get into utilizing Google Drive to streamline my many personal projects. One of the things I'd love to do is figure out how to download CSV files onto my Google Drive, and ...
- 171
4
votes
1
answer
12k
views
Does IMPORTDATA() refresh when an Apps Script runs even if the sheet isn't open?
We have a Google Spreadsheet that pulls data from an external source via an IMPORTDATA() function and then a Google Apps Script that is on a timed trigger that performs other things with the imported ...
- 93
10
votes
6
answers
31k
views
What are the refresh characteristics of the Google Spreadsheet Import functions?
The imported data is not always up to date with the source pages when I load the spreadsheet. When this happens, F5 refresh does not help. Nor does Ctl-F5. Apparently there is some kind of caching ...
- 219