Short answer: Use a free Google Apps Script that imports every Excel file in a Google Drive folder into its own tab, and checks the folder again every morning. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Put your Excel files in a Drive folder; Paste the script; Add the Drive API; Run it once; Turn on the morning check.
How to set it up
- Put your Excel files in a Drive folder. Put your Excel files in a Google Drive folder. With Drive for desktop, that's just a folder on your computer. Copy the folder ID from the address bar.
- Paste the script. In your Google Sheet, open Extensions, then Apps Script, and paste in the code below, with your folder ID in place of PASTE_FOLDER_ID.
- Add the Drive API. Click the + next to Services and add the Drive API, so the script can convert Excel files.
- Run it once. The first time it runs, Google asks for permission because the script works in your own account. Review it and allow it; that only happens once. Each Excel file becomes a tab with the same name.
- Turn on the morning check. Run
installNightlyonce. From then on the folder is checked every morning at 6, and only files that changed are imported again.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Just one file?
Our free Excel and Google Sheets tool converts a file in your browser.
Questions
What does this script do?
It is a free Google Apps Script that imports every Excel file in a Google Drive folder into its own tab, and checks the folder again every morning.
How do I set it up?
In 5 steps: 1. Put your Excel files in a Drive folder; 2. Paste the script; 3. Add the Drive API; 4. Run it once; 5. Turn on the morning check. 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.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/