1

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.

1

I'm aware this was asked some months ago but this recently became a part of my weekly workflow and I decided there had to be a better answer than the roundabout answers that were given.

My solution is admittedly a little hacky but it has worked for me and, barring any future changes Google plans to make in how they encode their URLs, should work for the foreseeable future.

It turns out, per Dafne Canales Lees' answer to a similar question asked on Quora, that all you have to do is replace the "/edit#gid=" part of the URL with "/export?format=xlsx&gid="

This works just fine although I did find that I had to keep looking up this string and copying it. Instead, I made a quick Javascript snippet that does all the work for you:

Just create a new bookmark name it whatever you like and add this as the URL for the bookmark. Then, whenever you need to export a single page sheet from Google Sheets as an Excel document, just open the page you want to export, click that bookmark, and it should start the download.

javascript:var%20winURL%20=%20window.location.href;if(winURL.indexOf('/edit#gid=')%20%3E%200)%7Bwindow.location.assign(winURL.replace('/edit#gid=',%20'/export?format=xlsx&gid='));%7Delse%7Balert('Incorrect%20URL%20format');%7D

I've tested this on the latest versions of Chrome, Safari, and Firefox. They all work although you might have to get a little creative about how you make your bookmarks.

  • A very welcomed solution :) – marikamitsos Jan 24 at 22:44
1

One solution I found was to right click 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.

  • Sorry Sam, but when tried to "right lick the sheet" all I managed was a smudge on the screen and a funny taste on my mouth. I then right clicked the sheet and all worked like magic. So I edited your answer :) – marikamitsos Jan 24 at 22:40
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

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.