Tag Info

Hot answers tagged

6

Drop this formula in the first cell of your google spreadsheet: =importData("http://example.com/activities.csv") And it will automatically fill out the rest of the current spreadsheet with as many columns and rows as it needs until all the data from the original source csv is displayed. There are many other powerful ways to feed Google Spreadsheets from ...


4

Old-school way: select filtered set of rows copy to clipboard create new sheet paste (or paste special -> paste values only) download this new sheet as CSV


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 ...


3

No, it is not possible to change it when downloading. However, you can load it in a spreadsheet or script and change the format of the duration.


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

On the Google Developer site, Google Apps Script, the following tutorial can be found: Interacting With Your Docs List. In section 3, it describes how to save a selected range to CSV. This particular line of code introduces a carriage return: // Join each row's columns // Add a carriage return to end of each row, except for the last one if (row < ...


1

I've found that setting a filter in Google Spreadsheets, copying that filtered selection, and then pasting into Excel does only paste the filtered selection. When you try to paste into another Google Spreadsheet, you get all rows in the selection (regardless of filter).


1

So as I was saying... I couldn't find anything that would let me do this that didn't involve installing a full spreadsheet app so I created a simple CSV transposition tool on app engine: CSV Transposer Tool


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