Google Sheets – How to Export Filtered Rows

csvexportgoogle sheetsgoogle-sheets-filter

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows?

I need to get in CSV exactly the rows which are visible on the sheet after a filter is applied to it.

Best Answer

Apparently not. I've just wasted half an hour trying to figure out a way to save filtered data, to no avail. It always saves all rows, regardless of the filter selection.

Related Solutions

Google Sheets – Print Filtered Rows

Create yet another sheet, with a catchy name like for example PRINTING.

Use the FILTER formula to set the data range and filter for the sub-contractor:

=FILTER(DATA!A:U, DATA!F:F=H1)   // H1 = Xzila

If you place H1 outside the printing area, then it will not take part in the printing.

Google-sheets – 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://softwarerecs.stackexchange.com

To use Google Apps Script, please start reading https://developers.google.com/apps-script/guides/sheets

To learn about the Google Sheets API, please reas https://developers.google.com/sheets.

It's worth to note that Google Apps Script or an add-on can't access a local file so first you have to someway upload that file to the cloud (Google Drive, or something like that).

Best Answer

Related Solutions

Google Sheets – Print Filtered Rows

Google-sheets – Auto import CSV into existing Google Sheet

Related Topic