Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Hot answers tagged

38 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 ...
user avatar
  • 713
8 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 ...
user avatar
  • 51k
8 votes
Accepted

Export all sheets in a spreadsheet to csv in Google Apps

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 ...
user avatar
  • 459
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 ...
user avatar
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://...
user avatar
  • 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.
user avatar
  • 151
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 ...
user avatar
  • 41.7k
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.
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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). ...
user avatar
  • 4,477
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
user avatar
  • 768
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 ...
user avatar
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(...
user avatar
  • 4,477
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 ...
user avatar
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('...
user avatar
  • 41.7k
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.
user avatar
  • 16.7k
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.
user avatar
  • 41.7k
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 ...
user avatar
  • 41.7k
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 ...
user avatar
  • 41.7k
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://...
user avatar
  • 41.7k
1 vote

Import a CSV file to Google Spreadsheets

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\...
user avatar
  • 16.7k
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 ...
user avatar

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