Skip to main content
Share Your Experience: Take the 2024 Developer Survey
257 votes

How to paste a comma separated string over multiple cells in Google Sheets?

From https://support.google.com/docs/answer/6325535?hl=en : Open a spreadsheet in Google Sheets. Paste the data you want to split into columns. In the bottom right corner of your data, click the ...
fstang's user avatar
  • 2,679
68 votes

How to paste a comma separated string over multiple cells in Google Sheets?

You are able to paste CSV data as is into the spreadsheet and go to Data selecting Split text to columns... and even further specifying the delimiter: Also, you can simply use keyboard shortcut combo:...
user0's user avatar
  • 26.7k
58 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 ...
user29020's user avatar
  • 922
11 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 ...
ale's user avatar
  • 52.7k
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 ...
cladelpino's user avatar
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 ...
Rubén - Volunteer Moderator -'s user avatar
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.
Guilherme Franco's user avatar
2 votes

How to export CSV without commas in unpopulated cells?

The answers pretty embarrassing. I had an if statement populating " " a bunch of rows instead of "" - i.e where nothing was required. Adding a space will add a comma in CSV. I did not know.
Matthew Rowlands's user avatar
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). ...
Erik Tyler's user avatar
  • 5,048
2 votes
Accepted

Downloading CSV results in empty (#ref) file. Is it a problem with IMPORTRANGE?

The issue is caused by the use of importrange() to copy data from one tab to another within a spreadsheet file, which is generally discouraged. To copy data from one tab to another within the same ...
doubleunary's user avatar
  • 14.8k
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 ...
Dave S.'s user avatar
  • 21
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.
pnuts's user avatar
  • 17.6k
1 vote

How to nicely import CSV contacts to Google Contacts preserving as much information as possible?

For best results, the column names in your CSV should match those found in a Google Contacts exported CSV. Contacts will make a best effort when importing data that has alternate column names. Columns ...
Blindspots's user avatar
  • 5,648
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.
Daniele's user avatar
  • 2,428
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 ...
Westicle's 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(...
Erik Tyler's user avatar
  • 5,048
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 ...
Mayank Kumar Chaudhari's 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('...
Rubén - Volunteer Moderator -'s user avatar
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.
Rubén - Volunteer Moderator -'s user avatar
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 ...
Rubén - Volunteer Moderator -'s user avatar
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://...
Rubén - Volunteer Moderator -'s user avatar
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 ...
SilvioPicinini's user avatar

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