0

I've got a spreadsheet (workbook) in Google Drive Sheets that has multiple sheets (tabs/worksheets).

I want to export just one worksheet from the workbook as an XLS file.

Is this possible?

I know I can download the entire file as an XLS and then delete the worksheets I don't need, but this is quite long-winded. I also know I could download just my current worksheet as a CSV, but in doing this I would lose all formatting.

0

That's not really a thing, but best you can do is to download it as .tsv file and then just open it in Notepad and copy-paste it into Excel. Of course, the formatting gets lost.

0

0

One solution i found was to right lick the sheet in the bottom bar copy to > new spreadsheet this will create a new spreadsheet containing just this tab. Just make sure to delete this new spreadsheet when you are done as this can get confusing as you are essentially duplicating your data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.