Easy way to extract the file ID from its URL

In this tip, we are going to explore:
Easy way to extract the file ID from its URL
All explanations are simple and to the point.

#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets

Feel free to make your copy of this spreadsheet template:

Useful Link:
Google Workspace Tutorial:

Ben Collins (Google Developer Expert & Data Analytics Instructor)

Google Sheets training:

The Playlist link:

Follow us on Pinterest:

These are the URLs of files on our Drive.
Our mission is to extract their IDs.
We can achieve that using the REGEXEXTRACT function, using this REGEX pattern.
=REGEXEXTRACT(A3,"[\w+]{25,}")
[\w+] means one or more word characters
[a-z, A-Z, 0-9]
The only part of the URL that has more than 25 characters is the ID.
Therefore, it is the only part that will be extracted.