49
votes
How to export a filtered set of rows from a Google Spreadsheet?
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 ...
- 832
9
votes
Accepted
How to use "split text to columns" when pasting in Google Sheets?
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 ...
- 51.9k
5
votes
IMPORTDATA Google Sheet CSV on Google Drive
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://...
- 302
5
votes
How to export a filtered set of rows from a Google Spreadsheet?
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.
- 151
5
votes
What's the biggest .csv file you can import into a Google Sheets?
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 ...
- 171
4
votes
Accepted
Google Spreadsheets CSV Encoding not UTF-8?
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 ...
- 43.4k
3
votes
How to export a filtered set of rows from a Google Spreadsheet?
You can make a Pivot table for that, inserting the desired filter. Then just export it as CSV.
3
votes
Accepted
Parsing JSON, XML or CSV with IFTTT?
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 ...
- 877
2
votes
Importing "Reminders" to Google Calendar using CSV file
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 ...
- 21
2
votes
Accepted
How to analyze a time tracking sheet with Google Sheets?
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). ...
- 4,820
1
vote
How to import only some of csv into Google Sheets
It's not difficult to put California data in a sheet, just copy/paste the California lines and you will get this file.
- 2,246
1
vote
Google Sheets interpreting dates from CSV in a weird way
Ok I've worked it out. Google Sheets imports the date cell as text and then interprets that cell as a date. The Locale is set as UK so it can't handle the US format date. I had change the spreadsheet ...
- 31
1
vote
How to analyze a time tracking sheet with Google Sheets?
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(...
- 4,820
1
vote
How to analyze a time tracking sheet with Google Sheets?
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 ...
1
vote
Accepted
Google App Script TypeError Cannot Call Method getSheets of null
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('...
- 43.4k
1
vote
What's the equivalent of the SEP metadata in Google Sheets?
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.
- 17.2k
1
vote
Put quoutes around data in csv export from Google Spredsheets
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.
- 43.4k
1
vote
IMPORTDATA Google Sheet CSV on Google Drive
The file should be shared to anyone or to anyone with the link
If the file is "small enough" the URL to be used should have the form
https://drive.google.com/uc?export=download&id=FILE_ID
If ...
- 43.4k
1
vote
Import a CSV file from a URL to Google Sheets and update it periodically
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 ...
- 43.4k
1
vote
Auto import CSV into existing Google Sheet
You could Google Apps Script, the Google Sheets API or G Suite Document Editor add-on to automate tasks on Google Sheets.
To ask for an add-on recommendation please post a question on https://...
- 43.4k
1
vote
How to escape a double-quote in a TSV file for import into a Google Sheets?
I replaced the double quote in the original file with something unique, the concatenated word doublequote. Then I imported into Google Sheets and it went ok. Then I went to the Find dialog and entered ...
Only top scored, non community-wiki answers of a minimum length are eligible