Web Applications Asked by Gary D on January 25, 2021
I have a spreadsheet that analyzes data uploaded into a sheet from a .csv
file that is downloaded from my store for various operations and reports that I extract from it. I would like to know if there is a method to make calls directly to my store database to retrieve the report automatically so the sheet always has up to date info.
Try IMPORTDATA
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
Sample Usage
IMPORTDATA("http://www.census.gov/2010census/csv/pop_change.csv")
IMPORTDATA(A2)
Answered by Rubén on January 25, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP