Email your Google Sheet as an Excel file every week, automatically

Short answer: Use a free Google Apps Script that sends the whole spreadsheet, or one tab, as an .xlsx attachment, now or on the same day every week. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make a Settings tab; Pick the day; Paste the script; Send one now; Send it every week.

How to set it up

1. Make a Settings tab. Add a tab called Settings. B1 is who gets the file (commas for several people). B2 is one tab to send; leave it blank to send the whole spreadsheet.
2. Pick the day. B3 is the weekday to send on, such as Mon or Fri. B4 is the hour on the 24-hour clock, such as 7 for 7am.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Excel menu appears.
4. Send one now. Choose Excel, then Email as Excel now. Google asks for permission the first time, because the script exports your file and sends email from your account.
5. Send it every week. Choose Excel, then Send every week. The file goes out on your day and hour, named after the spreadsheet with the date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• The Excel file is a copy made at send time. Changes made in Excel don't come back into the Google Sheet.
• If you change the day or hour, choose Send every week again to update it.

Questions

What does this script do?

It is a free Google Apps Script that sends the whole spreadsheet, or one tab, as an .xlsx attachment, now or on the same day every week.

How do I set it up?

In 5 steps: 1. Make a Settings tab; 2. Pick the day; 3. Paste the script; 4. Send one now; 5. Send it every week. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.