Tuesday 10 May 2022

Bulk convert Excel files to Google Sheet files

As of February 2023 'Convert Drive Files' is now available as a Google Workspace Marketplace Add-on.

The following Google Apps Script is designed to iterate through a Google Drive folder of Microsoft Excel files and convert them all to individual Google Sheet files. It does not technically check a file is Excel only (eg you may have a Word document in there), but it is recommended to only try from Excel to Google Sheets otherwise the data may be unreadable.

Bulk convert Excel files to Google Sheets
Bulk convert Excel files to Google Sheets

Download

Bulk convert Excel files to Google Sheet files download (please use 'Overview' > 'Make a copy' for your own version).

As of February 2023 'Convert Drive Files' is now available as a Google Workspace Marketplace Add-on.


1 comment:

  1. Thanks, worked perfect first time for me. Much appreciate the help.

    ReplyDelete