Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Hot answers tagged

18

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


18

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


10

Create a new sheet (Sheet2) within the spreadsheet. Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1). (See docs on the filter function.) You should then be able to save or export Sheet2 as CSV with only the filtered values.


5

I took some test CSV data and pasted it into a Google Sheet. When I opened the clipboard and chose "split text to columns", my data was immediately split. There shouldn't be anything else you need to do. Try with a smaller sub-set of the data.


4

Try four double-quotes, e.g. """" According to Wikipedia there is no reliable standard, but some attempts have been made. A (double) quote character in a field must be represented by two double quote characters.


4

Actually, Google Sheets exports to CSV using UTF-8. In Excel, instead of using double-click to open a CSV file, use the Text Import Wizard as it allows to select the "File origin". On the "File Origin" field, select 65001: Unicode (UTF-8).


4

Generating a direct download link, as described in this article seems to work fine with the =IMPORTDATA function. To summarize, you take the SITE_ID string from the sharing link you have: https://drive.google.com/file/d/FILE_ID/edit?usp=sharing Using this, you can generate the direct download link for use with the =IMPORTDATA function: https://drive....


3

Based on Normal Human's answer, I've created a Google sheets script that will parse and email IFTTT based on a price threshold. Google sheet cells won't update ImportXml() or other external site data more than once every hour or so, even using workarounds. However, accessing external sites via the script works. Use the following script and set up a ...


3

The best way to do this is to just select the cells you want to save as CSV, paste it into notepad, then find/replace tab with a comma.


2

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


2

As of July 2019, my own experimentation says that: A csv file of ~ 300000 cells, ~ 80 MB, was imported properly. A csv file of ~ 700000 cells, ~ 100 MB, was not allowed to be imported. I wasn't able to find any official documentation on this feature, but the import dialog will properly inform you if the .csv is "too large".


2

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


2

Peleke, I just looked at your linked sheet. Some of your data in Rohdaten!A:A is dates (those that are right-aligned) and some are text that just looks like dates (those that are left-aligned). Similarly, some of your data in B:B is numbers (right-aligned) and some is text (left-aligned). How you got mixed data in the same column, I don't know. But, no, my ...


2

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


1

Create a new sheet Add the following formula to A1 =ArrayFormula("'"&Sheet1!A1:D3&"'") NOTE:Replace Sheet1!A1:D3 by the proper reference. Download the new sheet to as a CSV file.


1

Peleke, try replacing your formula with this: =ArrayFormula(IF(Rohdaten!C2:C="Stop";(TIME(INT(Rohdaten!B2:B);(Rohdaten!B2:B-INT(Rohdaten!B2:B))*100;0)-TIME(INT(Rohdaten!B1:B);(Rohdaten!B1:B-INT(Rohdaten!B1:B))*100;0))*60*24;"")) The TIME function turns (h, m, s) into a viable time. I've used INT to grab the first part of your time (the hour) and the raw ...


1

Try pusing formula to replace . with : Insert a column next to your time entries. Use substitute function to replace "." with ":" a. In cell D2 write "=SUBSTITUTE(B2)" b. Drag or double tap on right bottom corner c. Copy D:D d. Paste as value in B:B Now, apply your function as before. Hope this helps.


1

The "active" methods, like getActiveSpreadsheet(), return null when the script is triggered by a time-driven trigger. You should replace this by openById('yourSpreadsheetId')/openByUrl('yourSpreadsheetUrl') methods.


1

This doesn't appear to be possible (yet). You'd think that you'd be able to import a CSV into your Reminders calendar ... CSV import has a "reminders on/off" option, but that's for sending push notifications, which are not the same as Reminders.


1

What's the equivalent of the SEP metadata in Google Sheets? There isn't one. is there an all around metadata which could work both on MS Excel and Google Sheets No.


1

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


1

Use the IMPORTDATA() built-in function. AFAIK the refresh of the data is done on the server side, so refreshing or recalculating the spreadsheet very frequently could not make any difference. The time that it takes on the server side is not documented in an canonical source; some sources say that it takes 5 minutes others 1 hour. References IMPORTDATA - ...


1

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


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