Clicky

batch rename files with google sheets

How to Batch Rename Files from Google Drive with Google Sheets and FileDrop

If you are looking to rename files in bulk that are in a Google Drive folder and you want to do it quickly this solution is for you.  You can rename files in batches for hundreds of files at once with this easy method. To rename the files in your Google Drive we are going to use Google Sheets and FileDrop, our must have Google WorkSpace add-on.

FileDrop is an excellent file manager tool that you can find in the Google Workspace Marketplace. It provides several functionalities that can greatly enhance your file management capabilities, including the ability to easily rename files in a Google Drive folder. In this article, we’ll walk you through this process step-by-step.

Step 1: Accessing FileDrop

Begin by navigating to the Google Workspace Marketplace and installing the FileDrop add-on if you haven’t already done so. With FileDrop installed, you can start using its wide array of features.

Step 2: Listing Files in Folder

The first function we’ll use is ‘List files in folder’. Click on this button in the FileDrop extension, and you’ll be prompted to enter your folder ID. This ID is the section of the URL that comes after “folders” when you’re viewing your folder in Google Drive.

list files in sheet

After you’ve entered your folder ID, click OK. You should now see a list of all the files in your specified folder displayed in Google Sheets.

Step 3: Preparing for Rename

FileDrop conveniently adds headers to these columns. On the left, you have the current file name, while the B column is where you can specify the new names for your files. For instance, if you have a file named “21.jpeg”, you can rename it to something more descriptive, like “cats”, in the B column. Proceed to name all your files according to your preference.

Step 4: Renaming Files

Once you have your new file names ready, head back to FileDrop and click on the ‘rename files’ button. You’ll receive a confirmation once the files have been successfully renamed.

rename menu filedrop sheets

To verify the changes, refresh your Google Drive folder. You’ll now see your files sporting their new names.

Video Tutorial

Conclusion

Renaming files in a Google Drive folder is a simple yet effective way to maintain organization and ease of access. With FileDrop, this process becomes more straightforward and efficient.

We hope you find this tutorial helpful in improving your file management practices. Stay tuned for more tips and tricks. Until next time, cheers!