CODEWITHSUNDEEP
excelgoogle-drive-apigoogle-docs
eComEvo
eComEvo

Reputation: 12589

Can data be piped dynamically into Excel or Google Spreadsheet fields?

Is it possible to add dynamically loaded data to a spreadsheet field in either Excel or Google Spreadsheets that retrieves it's value from an externally referenced data source such as a Yahoo Data Pipe or an AJAX response?

If so, is it possible to make the data "live" so it updates at regular polling intervals?

Upvotes: 1

Views: 230

Answers (1)

mb21
mb21

Reputation: 39383

For Google Spreadsheets, use importData by writing the following in a spreadsheet cell:

=importDATA("http://www.census.gov/2010census/csv/pop_change.csv")

Upvotes: 1

Related Questions