Tag Info

Hot answers tagged


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


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


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


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.


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


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


I acknowledge that this does not answer "what is Google Spreadsheets’ new line character?". However, if not for OP for others wanting to get from a text file containing: hi,hello\r\nwelcome,to\r\npeaceful,world to : a process of the kind below may suit. The technique is basically to 'feed' Google Sheets with a replacement for \r\n that ...


Couldn't find any built in way to do it so I wrote a script to use in Google Sheets Just paste it in script editor and run function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}]; ss.addMenu("csv", csvMenuEntries); }; function saveAsCSV() { var ss = ...


You can query the database: http://meta.wikimedia.org/wiki/Help:Advanced_editing#Records_of_edits_in_the_database Edits are recorded both in the revision table and in the recentchanges table of the database. The revision table is used for page histories and user contribution lists. The recentchanges table is used for recent and related ...


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


With the new Google Spreadsheet, you are able to add more than 256 columns. To test this, I added this formula in A1: =TRANSPOSE(REPT("A,", 367)) and continued with this formula in A2 =SPLIT(A1, ",") It will raise an error, telling you to add more columns (it will add 300 as a standard): Once added, the split result will expand and show all the data ...


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


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