TransWikia.com

Can I import data from web store directly to Sheet?

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.

One Answer

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP