Tag Info

Hot answers tagged

4

Taken from this Help article on Google Docs: Spreadsheets: 400,000 cells, with a maximum of 256 columns per sheet. Uploaded spreadsheet files that are converted to Google spreadsheets format can’t be larger than 20MB, and need to be under 400,000 cells and 256 columns/sheet. 40,000 of your cells can have formulas. Certain formulas ...


2

i would suspect that setting the expire-time for the .csv file could help. that would be something for the server to deliver. OR you can trick the webbrowser by appending something random at the end of the url you are using to fetching the data (see my comment on your question): http://example.com/myfile.csv?_invalidate_cache_of_browser_XYZ and then you ...


1

You can use the importData("URL") function to achieve your goal. Upload the CSV file somewhere that you can have public access to (I suggest Dropbox or Ge.tt) and you'll endup with something like http://example.com/foo.csv Go the the first cell that you want to insert your data and write: =importData("http://example.com/foo.csv")



Only top voted, non community-wiki answers of a minimum length are eligible