Top Free Uninstaller Apps You Should Try in 2023

Top Free Uninstaller Apps You Should Try in 2023

What We Like

  • Includes several ways to start an uninstall

  • Remove programs in bulk, one after another

  • Monitors installations to make them easier to remove

  • Identifies bundleware

IObit Uninstaller is highly recommended for program removal. It offers more features than Windows’ built-in app remover, such as discovering and removing rarely used programs, uninstalling browser toolbars and plugins, and identifying out-of-date software.

The standout feature of IObit Uninstaller is its right-click context menu integration, allowing you to remove programs directly from your desktop without searching for their uninstall utilities. A similar tool simplifies the removal of running programs.

Once a program is deleted, IObit can scan the registry and file system for missed leftover data, helping to keep your computer clutter-free. If you uninstall a program without IObit, it still prompts you to remove leftover items.

IObit Uninstaller can also create a System Restore point before making any changes, includes a file shredder, can force-remove a program, supports batch uninstalls, and includes other useful tools, too.

I regularly use this app on Windows 11, and I’ve tested it with Windows 10. It also works on Windows 8, 7, Vista, and XP.

What We Like

  • No need for installation (portable)

  • You can view the registry entry for any program

  • Lets you sort the list of programs by size

  • It’s easy to remove stubborn programs

Geek Uninstaller has been a favorite of mine for a while. I like it because you can run it after downloading it without installing it. It has excellent features, all in a file less than 10 MB!

Geek Uninstaller sorts programs by size or installation date, deletes software entries, searches programs, exports installed software lists to an HTML file, and provides program information via the Registry Editor or online.

This uninstaller deletes desktop and Microsoft Store apps. It can also forcibly remove a program by eliminating registry and file system references.

Some features, like batch removal, unfortunately, only work in the professional version.

I tested Geek Uninstaller with Windows 11, but it also uninstalls programs in Windows 10, 8, and 7.

What We Like

  • A perfect solution for advanced users who like to tinker with really specific options

  • It’s portable, so installation is unnecessary

As this screenshot indicates, Bulk Crap Uninstaller (aka BCU or BCUninstaller) is an advanced application uninstaller. I don’t recommend using this if you’re easily overwhelmed by lots of options, but I do recommend it if you like to have lots of control over how your programs work.

Besides cleaning leftover files and performing forced uninstallations, BCU offers advanced features like quiet uninstallations, system shutdown prevention, restore point creation, unlimited bulk removal, quick registry entry deletion, file/folder-based uninstallation, and pre/post-uninstallation commands.

There’s also a startup manager and a shortcut to Disk Cleanup and some other related Windows tools.

This is a wonderful software removal tool if you take the time to appreciate all its options. Check out the BCU Documentation page if you need help.

I tested this app with Windows 11. It also runs on Windows 10, 8, 7, and older Windows versions, and you can use it in both private and commercial settings.

What We Like

  • Can remove programs in bulk

  • Lets you make a restore point before uninstalling software

  • Most programs can be uninstalled automatically

  • It’s a portable application

What We Don’t Like

  • Doesn’t let you search for a program from the list

  • No filtering options (e.g., a size or name filter)

  • Can’t uninstall programs directly from File Explorer

  • Support has been discontinued

PC Decrapifier takes up less than 2 MB of space and supports batch uninstalls. It can run without being installed, so it’s a great option if you like to keep fix-it-related tools on a flash drive.

PC Decrapifier is ideal for beginners, offering a user-friendly wizard guiding you through the removal process, including selecting items to remove and creating a restore point before uninstallation.

Some programs can be uninstalled automatically and very quickly. For others, you must uninstall them manually, clicking through their wizards like a normal uninstallation.

While I was testing this program, four apps were selected for uninstallation. Only one required a walkthrough of a regular uninstall wizard, while the others were removed automatically without any prompts.

Unfortunately, there’s no way to filter or search through the list of software.

PC Decrapifier should work fine with Windows 11, 10, 8, 7, and older versions.

What We Like

  • Has a clean and modern user interface

  • Deletes rogue entries in the registry

  • Includes a way to delete programs that failed to uninstall with other means

  • Helps identify which apps you might want to remove

Wise Program Uninstaller facilitates program removal via the right-click context menu in File Explorer, making it easy to delete programs, particularly those with desktop shortcuts.

After deleting an app, it will automatically scan your computer for any remaining registry entries or files that may have been left over. I always like to see this feature in a software remover.

Forced Uninstall is an option that can force a program to be removed if you’ve already tried using the software’s regular uninstaller but were unable to get it removed properly.

This uninstaller can also remove program entries from the list of installed software, instantly search through all the programs, sort by installation date or size, and delete software in batches. It even includes built-in reviews submitted by other users.

I’ve used this to uninstall apps on Windows 11 and Windows 10, but it also runs on Windows 8, 7, and Vista. Windows XP users have to use the portable version.

What We Like

  • Removes remnants often left after an uninstall

  • Can delete the entire program because it monitors the install

  • Works from File Explorer for quick uninstalls

  • Lets you back up and restore whole programs

  • Includes other tools you might like

What We Don’t Like

  • Some of the tools included are not free to use

  • No option to make a restore point before uninstalling software

  • The other tools clutter the interface

In some ways, Advanced Uninstaller PRO is a lot like these other uninstaller apps. Common features like scanning for leftover registry items, context menu integration, and a search utility are included. However, a feature called Monitored Installations drove me to include it in the list.

That feature takes a snapshot of your computer before and after you uninstall an app. This allows Advanced Uninstaller PRO to quickly identify the changes that were made on the computer, thus allowing it to remove every single file the program modified during its installation process.

One downside is the cluttered interface due to extra tools like the registry cleaner and file shredder, which, while useful, should ideally be separate.

32-bit and 64-bit versions of Windows 11, 10, 8, 7, Vista, and XP are supported.

What We Like

  • Can identify possibly malicious programs

  • Applications can be removed in bulk

  • Has a clean and uncluttered interface

  • Lets you sort and search through the list

Puran Software, the maker of a few other popular system tools, also has a free application uninstaller called Puran Uninstaller.

It’s similar to some of the other programs on this list. It supports instant searching of installed software, batch uninstalls, force uninstalls, and allows individual program entries to be removed from the list of software.

Puran Uninstaller unique feature is its ability to verify a program’s identity using code signing. If an application’s signature doesn’t match the known signature, it’s identified as untrusted.

I tested Puran Uninstaller in Windows 11 and Windows 10, but you can also uninstall apps in Windows 8, 7, Vista, XP, Server 2008, or Server 2003.

What We Like

  • Organizes large programs into their own category

  • Deletes invalid program shortcut

  • Supports batch uninstalls

  • Also deletes Windows updates

Absolute Uninstaller is a free software remover that supports batch uninstalls, so you can check multiple programs to remove them consecutively. Newly installed programs are marked as such for quick identification.

One thing I like is the AutoFix invalid entries option in the menu that can scan all the installed programs to find any that don’t refer to an actual installed program. This may happen if you’ve removed a program in the past, but the entry remained in the list of installed software. While it does have a search function, it’s not nearly as good as the ones in most other programs I’ve reviewed here.

You can also modify the name of the listed programs, change the uninstall command line string and remove Windows updates.

This uninstaller app can be used with Windows 11, 10, 8, 7, and probably older versions of Windows, too, as well as Windows Server operating systems.

What We Like

  • Useful filtering tabs

  • Performs a deep cleaning after the regular uninstall

  • Can log new program installs to make them easier to remove later

  • Includes other cleanup tools

What We Don’t Like

  • Must create a user account, and log in before you can use it

  • Can’t uninstall programs in bulk (just one at a time)

  • Drops an unrelated shortcut on your desktop without asking

Ashampoo’s uninstallation app is easy to use and lets you remove regular programs and Windows apps and updates. There are also extra tools for browser cleaning, managing services, changing file associations, and wiping files.

Like other programs in this list, this one will scan for leftover files after the standard uninstallation to make sure everything gets removed. I also like the super helpful ability to force a new program installation to be logged so that leftovers will be easier to delete when you want to remove the program.

I often remove apps because I run low on hard drive space, so I was happy it had no problem finding the biggest programs on my computer. Other filtering options help locate recently installed programs and apps with negative reviews.

You can do quite a bit by right-clicking a program in the list, like research it online, rate it for other users to know how you feel about it, and delete its entry in the list. However, you can’t remove programs in bulk, so you have to uninstall each individually.

It works with Windows 11, 10, 8, and 7.

What We Like

  • Batch removal with zero input.

  • Detail of everything that will get deleted.

  • Monitor new installations.

  • Can be used without installation.

Uninstalr is a relatively new software uninstaller from Macecraft Software. Still, there are many reasons to like it… and a few reasons I don’t prefer this program over all the ones I’ve listed above.

Some of the good: it supports unattended batch uninstallations (you don’t have to click anything), it shows everything that will be deleted with the program, previously uninstalled software leftovers can be found, and it can keep track of new installations to ensure complete removal.

This software removal tool also detects portable apps and lets you sort installed programs by size or installation date.

One negative thing to mention is that it will automatically shut down all your open programs during the uninstallation, and your PC will reboot when all the program removals are done. There are some checkboxes to turn those actions off, but it doesn’t stick, so you have to do it each time you uninstall a new program. It is helpful to ensure that everything is deleted correctly, but I wish there were a way to prevent this from happening all the time.

Also, because the whole removal process is automated, the program recommends not even using your mouse during the uninstallation. If you have a lot of programs to delete at once, this could take several minutes to finish, so plan to walk away during this process.

Pay close attention to the list of items Uninstalr will delete if you proceed. Some users have reported that it tries to uninstall programs with a similar name as the one you chose to remove.

What We Like

  • Provides a unique way to remove programs

  • Can scan for leftovers to remove everything

  • A portable version is available

  • Makes a restore point automatically

  • Includes other useful free tools

What We Don’t Like

  • Batch removal isn’t supported

  • Can’t delete partially uninstalled programs

  • Doesn’t always work as advertised

A unique feature I enjoyed using in this program is Hunter Mode, which lets you manipulate a program by simply selecting its open window. You can uninstall the software, view its installation folder, kill the process, and even stop it from running at startup using this mode.

When uninstalling apps with Revo Uninstaller, you can run it in advanced mode. It scans the file system and registry for leftover items that are no longer needed but didn’t get properly uninstalled with the built-in uninstaller. You can then delete some or all of the leftover items.

Automatic restore point creation is a big plus in my book. Also, there’s a junk file cleaner and privacy cleaner included, among other extra tools.

I do like Revo Uninstaller, but because there’s also a professional version, it lacks a handful of the same features you’ll find in some other uninstaller tools from this list, like removing partially uninstalled applications and support for batch removals.

There’s both a regular installable version and a portable one. The official system requirements state that it works with Windows Server and Windows 11, 10, 8, 7, Vista, and XP.

What We Like

  • Sort programs by size to find the largest ones

  • Search through the list of installed programs

  • Rename and delete program entries

  • Includes lots of other tools

What We Don’t Like

  • Doesn’t support batch uninstalls

  • You have to run the uninstalls manually

  • Only works from the program window, not File Explorer

CCleaner is best known as a free registry cleaner and junk file removal program, but it can also be used as a free software uninstaller.

You can search for installed software, remove and rename entries from the program list, and sort by name, installation date, size, or version number.

It’s a wise choice to use this tool for removing programs because you can quickly switch over to its file and registry cleaner to sweep up any residual files that an uninstaller may have left behind.

In fact, this is the program I used to delete apps for years before I found some of the better options (the ones listed above), though I still use it from time to time if I’m already in the program when I need to uninstall some apps.

Some other useful tools include a duplicate file finder, hard drive wiper, and startup manager.

This one works with Windows 11, 10, 8, 7, Vista, and XP. A portable version of CCleaner is also available.

What We Like

  • Apps are deleted automatically (you don’t have to click anything)

  • Checks for and deletes any leftover remnants after each uninstall

  • Lets you remove programs in batch

  • No installation necessary (it’s portable)

OESIS Endpoint Assessment includes an application uninstaller called the OESIS Removal Module (formerly titled AppRemover).

Its biggest limitation is that not all installed programs can be removed. Programs identified as antivirus software, file-sharing applications, toolbars, and backup programs can be uninstalled, but nothing else.

Despite that, it made our list because of the OESIS Removal Module, which uninstalls the above software silently, with no intervention on your part. It also supports batch uninstalls and automatically scans for leftover files and registry entries to ensure that the entire program, including all its references, is deleted.

This is a portable program, which means you don’t need to install it on your computer to use it. It should work with Windows 11, 10, 8, 7, Vista, and XP.

What We Like

  • Monitors installs to know how to uninstall the program

  • Lets you restore deleted programs

  • Integrates with File Explorer for easy uninstalls

  • Able to delete Windows updates and drivers

Comodo is probably best known for its antivirus software, but it also has a decent uninstaller app called Comodo Programs Manager.

Its standout feature is the way it monitors program installs. After installing Comodo Programs Manager, any new software install will be monitored in real-time to keep track of every registry and file system change. Then, when you’re ready to delete the program, Comodo’s software removal tool knows exactly where to look for a thorough cleaning.

I love that it can restore a program from a backup if it was removed by accident. It’ll also remove programs from the right-click context menu in File Explorer, view the installation folder of any program, and sort the list of installed software by name, company, size, frequency of use, install folder, and install date. Some of these filtering options are rare to find in other similar programs.

Comodo Programs Manager can remove Windows Updates, drivers, and Windows features in addition to regular programs.

This program is only compatible with Windows 8, 7, Vista, and XP. You’ll need a different program from this list to uninstall apps on Windows 11 or Windows 10. This is a significant reason I don’t use it anymore, but I think it’s an excellent option if you’re running a compatible version of Windows.

What We Like

  • Has a unique way of removing troublesome software

  • Restore points can be made before uninstalls

  • Supports multiple ways to view the list of programs

Free Uninstall It is another program that can forcibly remove an application if it can’t be removed by normal means. It does so by scanning for registry and file items that refer to the program in question and then lets you remove them.

One difference between this program and others I’ve reviewed that forcibly remove programs is that Free Uninstall It can remove software by an executable even if it’s not listed in the list of installed programs.

Fortunately, unlike similar apps, there’s an option here to create a System Restore point before removing software.

An installation monitor is included that’s supposed to track how a program is installed to provide an easy way to remove it, but I wasn’t able to get it to work correctly.

This program should work with Windows 11, 10, 8, 7, Vista, and XP.

Antivirus Software Uninstallers

© Steven Puetzer / The Image Bank / Getty Images

If you plan on reinstalling one of these programs after deleting the current version, make sure you’ve safely backed up the license information to avoid having to repurchase a product key.

All the programs listed above should be able to remove antivirus software, but if not, the developer’s dedicated uninstaller should do the trick.

Since antivirus programs are integrated much more tightly into Windows to protect it from threats, removing these programs can be especially difficult for the general programs in this list.

These dedicated uninstaller programs are used for removing the listed applications only. Using one when you don’t have the associated program won’t do anything.

Uninstall McAfee Products: McAfee Ultimate, McAfee Advanced, McAfee Premium, McAfee Total Protection, etc.

Uninstall Norton Products: Norton 360, Norton AntiVirus, Norton Secure VPN, etc.

Uninstall Bitdefender: Bitdefender has a different tool for each product that needs to be removed

Uninstall Kaspersky Products: Kaspersky Premium, Kaspersky Plus, Kaspersky Standard, etc.

Uninstall Microsoft Security Essentials

Uninstall Comodo Products: Comodo Internet Security, Comodo Firewall, Comodo Antivirus, Comodo Client Security, and Comodo Advanced Endpoint Protection (AEP)

Uninstall AVG Products: AVG Free, AVG Internet Security, AVG Ultimate, etc.

Uninstall Avast Products: Avast Free Antivirus, Avast Premium Security, Avast Ultimate, etc.

Dating apps are encouraging users to meet in person to address concerns about “dating fatigue” among Gen Z and reverse a post-pandemic slowdown in growth (Kieran Smith/Financial Times)

Dating apps are encouraging users to meet in person to address concerns about “dating fatigue” among Gen Z and reverse a post-pandemic slowdown in growth (Kieran Smith/Financial Times)

Featured Podcasts

Dating apps are encouraging users to meet in person to address concerns about “dating fatigue” among Gen Z and reverse a post-pandemic slowdown in growth (Kieran Smith/Financial Times)

Lenny’s Podcast:

Anthropic co-founder on quitting OpenAI, AGI predictions, $100M talent wars, 20% unemployment, and the nightmare scenarios keeping him up at night | Ben Mann

Interviews with world-class product leaders and growth experts to uncover actionable advice to help you build, launch, and grow your own product.


Subscribe to Lenny’s Podcast.

Big Technology Podcast:

Grok’s AI Lovebot, Aqui-Hire-Sition Backlash, OpenAI’s ChatGPT Agent Debuts

The Big Technology Podcast takes you behind the scenes in the tech world featuring interviews with plugged-in insiders and outside agitators.


Subscribe to Big Technology Podcast.

Hard Fork:

X Hits Grok Bottom + More A.I. Talent Wars + ‘Crypto Week’

The future is already here. Each week, journalists Kevin Roose and Casey Newton explore and make sense of the latest in the rapidly changing world of tech.


Subscribe to Hard Fork.

Spotlight On:

Bonus: Anton Osika on how Lovable’s creating a world of builders

A podcast from Accel about how companies are built, from the people doing the building.


Subscribe to Spotlight On.

Decoder with Nilay Patel:

Perplexity’s CEO on why the browser is AI’s killer app

A show from the Verge about big ideas – and other problems.


Subscribe to Decoder with Nilay Patel.

Great Chat:

The straw that broke the camel’s back

A podcast mostly about tech. Brought to you weekly by Angela Du, Sally Shin, Mac Bohannon, Helen Min, and Ashley Mayer.


Subscribe to Great Chat.

Add your podcast here
7 Plex Apps Everyone Should Try Once

7 Plex Apps Everyone Should Try Once

I’m always on the lookout for apps that enhance Plex, whether it’s fetching accurate metadata or organizing my library. In my search, these Plex apps won me over after just one interaction and have already become part of my go-to for each Plex installation.

7

Amazon Alexa

An Amazon Echo Dot displaying the time

Josh Dolloghan / MakeUseOf

Controlling gadgets with your voice is good fun, especially if you have an army of smart home devices, so why not add Plex to that list? I know I lose the remote at least every other day, and having a hands-free backup to control media playback would be nice.

Although Amazon Alexa has all the basic voice commands you need to navigate Plex, you can add commands using Alexa Skills and get specific. For example, if you can’t decide on what to watch, there’s an Alex Skill that suggests content after you’ve said, “Alexa, suggest something to watch.”

Download: Amazon Alexa for Android | iOS (Free)

6

Plex Dash

As your Plex library expands and you invite more people to enjoy the content, you’ll learn that having backend information is invaluable. What’s the most-watched movie on your server? How has your bandwidth been holding up, and when does it tend to spike in usage? What are your viewers watching right now? Plex Dash will answer every one of those questions and more.

Plex Dash also doubles as a helpful tool for troubleshooting and making changes to your server on the fly. Not only can you refresh your libraries from the app, but if your server happens to crash, you can get your hands on server logs.

Download: Plex Dash for Android | iOS (Free; premium available)

5

Plexamp

streaming music in plexamp via remote access to plex media server

YouTube is as far as I’ll go when it comes to streaming music, so you won’t catch me using Spotify (or listening to its AI music). When I’m not streaming music, I’ll listen to my own library on Plexamp, where I can quickly access all the CDs I ripped to my Plex server. It’s the most frictionless music app I’ve used to date—even easier than VLC.

For one, I appreciate that the UI resembles a miniaturized Plex app, similar to Plex Dash and Plex Photos. Secondly, Plexamp is incredibly lightweight, especially on PC, where it’s nothing but a teeny-tiny sidebar you can drag. Lastly, I particularly love its Mood playlist, which Plexamp creates and organizes itself, then gives me the option to pick music based on my mood.

Download: Plexamp for Android | iOS | Windows | MacOS | Linux | Raspberry Pi (Free)

Related

I Use This Simple App to Stream My Personal Music Collection Wherever I Am

Once set up, Plexamp is simple to use.

4

Plex Photos

Accessing a library of photos in the Plex Photos app

Lately, I’ve been thinking of gathering images I’ve uploaded on Facebook of my family and making them accessible on Plex for my wife and I. With the Plex Photos app, as long as my server keeps running, we can download copies of images and videos any time we need to.

Now, Plex Photos isn’t rich with features—it just accesses images and videos. However, if you go the extra mile to organize your library, it’ll reflect in the app when you switch to Library View. You’ll then see all your photos, segregated by folders and albums. But my favorite feature is Timeline View, which orders them by dates uploaded, making it easier to find something from, say, a year ago.

Download: Plex Photos for Android | iOS (Free)

3

The Plex App

searching for movies and tv shows using plexs discover page

If you’re someone who mostly streams Plex from their browser, having the Plex app will feel significantly better. I use Google Chrome and, for some reason, the browser really punishes the quality when I stream Netflix or HBO Max, but that’s where the Plex app solved my problem.

For one, I like the very minor convenience of having an app that takes me directly to Plex, as opposed to typing a URL into a browser. Secondly, Plex has my second favorite streaming UI (the first being Netflix), which is sleek, simple, and the icons are sized well. And lastly, I like having control over my Plex server and don’t want to risk my browser’s own settings getting in the way.

Download: Plex (Free)

Related

Here’s What I Do to Expand My Plex Library for Cheap

It’s all about finding the right deal at the most opportune time.

webtools-ng server settings interface

WebTools-NG is a bit of a hodgepodge of different features, from organizing your Plex server to plugins; in fact, getting plugins is the app’s specialty. Once installed, you’ll be able to check out and install plugins for Plex through the Unofficial App Store (UAS)—at least the ones that still work.

Aside from organization and troubleshooting, one of the best features WebTools-NG has is the ExportTools module. With it, you can export a handy list of all the available content in your Plex library, which lets you export a handy list of available content on your library. It can even be used to create lists of specific content, like only 4K movies, or find missing episodes.

Download: WebTools-NG for Windows | MacOS | Linux (Free)

1

FileBot

filebot episode formatting window

Say your library grows to a respectable size, but you haven’t exactly been the best organizer. You could do it manually, but FileBolt is far quicker and even includes the work of renaming files to their proper titling, episodes included. Though there are plenty of other tools for organizing your Plex library, FileBolt is the one I rely on the most.

Aside from pulling metadata for accuracy, FileBot also has the ability to find artwork, cover images, and subtitles for movies and shows. For example, Plex originally pulled the cover image for Clash of the Titans (2010) for my copy of Clash of the Titans (1981), but FileBot rectified the problem. Now, Harry Hamlin’s stoic stare graces my Plex server!

Download: FileBot (Free trial; Subscription & Life-Time license available)


With plugins being phased out, I hope apps start to take center stage when it comes to customizing Plex. Just with these apps alone, you can organize your Plex library, troubleshoot, install plugins, even keep a watchful eye on server usage.

Apps Script for Google Sheets Is the Productivity Hack You’re Missing

Apps Script for Google Sheets Is the Productivity Hack You’re Missing

Google Sheets can do a lot—but with Apps Script, it does everything. I’d been using Sheets for years without touching this feature. Once I did, I started automating the chores I didn’t even realize were slowing me down.

Automating Boring Tasks

If you’re tired of repeating the same task over and over again in Google Sheets, whether it’s inserting a date, cleaning up text, applying formatting, or exporting data, Apps Script can help you automate that.

For instance, you can easily insert the current date in Google Sheets by pressing Ctrl + ; on Windows or Cmd + ; on Mac. But if you need it to be in a particular format like yyyy-MM-dd, you must use a formula or do some manual formatting. With Apps Script, you can create a function that gets the current date, formats it as desired, and then inserts it into the selected cells.

You only need to do this once, and you can reuse it wherever you need it. Here is an example of what the script would look like:

        function insertCurrentDate() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var selectedCell = sheet.getActiveCell();
  var currentDate = new Date();
  var formattedDate = Utilities.formatDate(currentDate, Session.getScriptTimeZone(),'yyyy-MM-dd');
  selectedCell.setValue(formattedDate);
}

If you are following along, I will show you how to run the above code from within a spreadsheet in the next section.

Create Customized Spreadsheets

One way Apps Script helps you customize your spreadsheet is by letting you create specialized tools that streamline your workflow. For instance, you can insert a button that applies formatting or performs advanced calculations, or create dashboards that help you to easily analyze your data. These capabilities are far beyond anything Google Sheets can do on its own.

Continuing with our example from the previous section, we can add a custom menu item that allows us to run the function from within the spreadsheet. Here is the script that does that (insert above the function in the previous section):

        function onOpen(){
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('My Menu').addItem('Insert Current Date', 'insertCurrentDate').addToUi();
}

Once you run this code in Apps Script and refresh Google Sheets, you will see My Menu appear in the top menu. Now, you can insert the current date in a selected cell by clicking My Menu > Insert Current Date.

A custom menu in Google Sheets created with App Script.

Perform Specific Calculations Through Custom Functions

Google Sheets doesn’t always have the functions you need to perform specific calculations. In cases like these, creating your own function using Apps Script, inserting the calculation into it, and using it within the sheet (just like you would any other) is the way to go. This also means that you don’t have to repeat the complex calculations throughout the script, making your spreadsheet cleaner and more readable.

Related

30+ Essential Google Sheets Functions

Manipulate your Google Sheets data and simplify processes with these handy functions, available in a free downloadable cheat sheet.

Consider the function below that accepts a date and checks how many days have passed since the current day (similarly to calculating the difference between two dates) to determine the due date:

        function CHECKDUEDATE(inputDate) {
  var today = new Date();
  var timeDiff = today - inputDate;
  var daysDiff = Math.floor(timeDiff / (1000 * 60 * 60 * 24));

  if (daysDiff < 0){
    return "Overdue!"
  } else if (daysDiff > 0) {
    return "Due in " + daysDiff.toString() + " days!"
  } else {
    return "Due today!"
  }
}

Depending on the date entered, it says if it’s overdue, if the days difference is less than zero, how many days are left if greater than zero, or due that day if equal to zero.

The best part of Apps Script is that you can create a time-based trigger that runs the function at a specific time (e.g., midnight) to dynamically update the due date. It can even be used for conditional formatting—the possibilities are many.

You Can Use Apps Script with Other Google Services

Apps Script allows you to integrate your spreadsheets with other Google services, including Gmail, Google Drive, and Google Docs. This capability enables you to build comprehensive workflows that span multiple tools in the Google ecosystem.

Here is an example script that extracts the body text from a Google Docs document and inserts it into cell A1:

        function getBodyTextFromGoogleDoc() {
  const doc = DocumentApp.openById("insert Google Docs ID here");
  const bodyText = doc.getBody().getText();

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const targetRange = sheet.getRange("A1");

  targetRange.setValue(bodyText);
}

Be sure to replace insert Google Docs ID here in the second line with the ID of the Google Docs document you want to get the body text from (don’t remove the parentheses).

Apps Script Is Not That Hard to Learn

If you have some basic programming knowledge, Apps Script is particularly easy to learn. This is especially true if you’re familiar with JavaScript, as that is the primary language used by the platform. You can start slowly with simple automations and tasks (basic calculations and sending an email), and build up from there.

The Apps Script editor.

Even if you’ve never written code in your life, Apps Script can be a great way to learn. Since you’ll mainly be using it to automate tasks in Google Sheets, you will see results instantly, which is a great motivator. With that said, you still need to learn basic programming concepts (e.g., variables, loops, and functions)—Google has great tutorials, and Apps Script has a supportive community behind it to assist you.

Furthermore, there is no need for a complicated setup, as it runs in the cloud. You don’t need additional software or libraries.

Related

These Free Websites Taught Me More Than Any Paid Course Ever Did

Paid doesn’t mean better.

Apps Script is just one of the many Google Docs features that you’re missing out on and worth a try. The cool thing about Apps Script is that you can also use it in other Google Workspace apps like Docs and Slides. For instance, I created a simple text case converter in Google Docs since it doesn’t have that functionality built-in.

Back to Top
Product has been added to your cart