I have a Google spreadsheet with 10 columns of data. I would like to export columns A, C, E, F as csv. I do not need to export the entire spreadsheet. Can this be done? I do not mind using Google script.
Google Sheets CSV – How to Export Specific Columns as CSV
csvgoogle sheetsgoogle-appsgoogle-apps-script
Related Topic
- Google-sheets – Export CSV from a Google Spreadsheet page from command-line
- Google Sheets – How to Split Content into Multiple Rows and Columns
- Google-sheets – Auto import CSV into existing Google Sheet
- Google Sheets – How to Convert Formulas to Plain Text for CSV Export
- Google-sheets – Put quoutes around data in csv export from Google Spredsheets
- Google Sheets – Script to Delete Columns Without a Specific Header
Best Answer
A script cannot give a file to you (well, it could email it to you, but I think this is going too far). You'll need to use "save as csv" menu command, and since it only saves the current sheet, you'll have to create a sheet that has only those columns in it.
The straightforward way is to just create a new sheet and type in cell A1
If you have to do this often, retyping all this thing with sheet name in every place will get old. This is where a script can be useful. Here is a function that assumed you enter simply
into the cell A1, and converts this input into a formula.