19

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


11

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.


3

At this time, on Google Sheets owner and users with permissions to edit a protected range are allowed to filter it. to edit saved filters. users without permissions to edit a protected range are not allowed to filter the protected range. to edit view filters created by others. are allowed to create temporary and to save view filters to edit own ...


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.


1

Unless you want to delve into the Advanced Google Services or Filter View, a "quick and dirty" workaround would be to rename your filters giving them a serial number: 01-myfilter, 02-yourfilter, 03-onemore. Rather a practical solution of re-naming than a "Google developer solution".


1

The Google Sheets UI, the Google Apps Script service and the Google Sheets API do not include a way to sort the list of filter views on the Google Sheets UI, but the filter views are editable so you could each item in the filter view to make have the settings that you want. NOTE: Google Apps Script doesn't support filter views directly but you could use the ...


1

Here's a way to achieve this =FILTER(B1:B10, iferror(ArrayFormula( VLOOKUP(B1:B10,$A$1:$A$10,1,false)) ,true)) EDIT : If you have a lot of values this is maybe a better solution : =FILTER(B1:B10,ArrayFormula(COUNTIF($A$1:$A$10,B1:B10)-1)) Breakdown of the formula VLOOKUP: Vlookup to see if there's a match between values in B and A. It returns ...


1

Well, it's clunky, but this works: INDIRECT("R" & ROW() & "C" & COLUMN(),false) e.g. = AND(INDIRECT("R" & ROW() & "C" & COLUMN(),false) <> "Financial",INDIRECT("R" & ROW() & "C" & COLUMN(),false) <> "Income") I could make it a lot neater if I could pack some of this into a custom function, but I can't seem to ...


1

Instead of using the Google Sheets UI filters, use a formula to filter the results. To do this you could use functions like FILTER and QUERY


1

Apparently in Google Sheets, when you turn on the filter (say on the first row) and you don't create a named filter view, that filter on the first row is still set with a range that only goes to the maximum number of rows that you have set up at the moment you turn on filters. If you add rows (not data to existing rows, but physical rows) to the spreadsheet,...


1

Google Sheet's Filter Views only work on the range specified. This range does not update upon the adding of rows or columns. The second issue, the number not being sorted, is because of the first one. Those cells are not in the range of the Filter View.


1

Follow this answer. Create a new sheet within the same document Use filter function (Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1)). (See docs on the filter function.) Import range from this new sheet.


1

I ran the test (video here) which shows what happens for each of the operations. I tested: Cut & Paste, Copy & Paste & Delete, and Dragging cells. You can see from the resulting image that the only operation that gave the expected results while in filtered view was to copy the cells, paste them, and then delete the data from the original cells. ...


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