Skip to main content

How to export and import Office ribbon menu settings

Office export and import ribbon menu settings
Office export and import ribbon menu settings (Image credit: Windows Central)

On every application of Microsoft Office (Word, Excel, PowerPoint, and others), you can customize the ribbon menu by rearranging the tabs and adjusting commands to include only those you need. Also, you can create new tabs and groups to organize the menu around your environment.

If you have already spent time customizing the ribbon experience, Office includes an export and import option to backup and restore the settings on the same or different device to replicate that personalization.

In this Windows 10 guide, we will walk you through the steps to export and import the ribbon menu settings on the same or different computers running Office from Microsoft 365 (opens in new tab), Office 2019, or an older version.

How to export ribbon menu settings in Office

To export the ribbon settings for an Office app, use these settings:

  1. Open Office app.
  2. Click on Options from the bottom-left corner.

Source: Windows Central (Image credit: Source: Windows Central)
  1. Click on Customize Ribbon.
  2. Under the "Customize the Ribbons" section, use the "Import/Export" drop-down menu and select the Export option.

Source: Windows Central (Image credit: Source: Windows Central)
  1. In the "File name" field, confirm a descriptive name for the file containing the settings.

Source: Windows Central (Image credit: Source: Windows Central)
  1. Select a location to save the ".exportedUI" file.
  2. Click the Save button.
  3. Click the OK button.

Once you complete the steps, you can save the customization file and then use it to restore the settings in the future on the same device. Or you can use the file to import the settings on another computer.

If you have an older version of Office, you are not taking advantage of all the suite features. If you switch to a Microsoft 365 subscription, you can always upgrade to the newest version of the most popular suite of apps to access the latest features for free, and you get many other benefits, such as sharing the account with up to six people and every user gets 1TB of OneDrive cloud storage.

How to import ribbon menu settings in Office

To import a configuration file containing custom ribbon and toolbar settings, use these steps:

  1. Open Office app.
  2. Click on Options from the bottom-left corner.

Source: Windows Central (Image credit: Source: Windows Central)
  1. Click on Customize Ribbon.
  2. Under the "Customize the Ribbons" section, use the "Import/Export" drop-down menu and select the Import option.

Source: Windows Central (Image credit: Source: Windows Central)
  1. Select the ".exportedUI" file containing the exported settings.

Source: Windows Central (Image credit: Source: Windows Central)
  1. Click the Open button.
  2. Click the Yes button.
  3. Click the OK button.

After you complete the steps, Office will replace all the ribbon and Quick Access Toolbar settings with the ones in the exported files.

These steps only export and import the ribbon settings for one application. You must repeat the steps for each application's ribbon settings you want to export and import.

Mauro Huculak is technical writer for WindowsCentral.com. His primary focus is to write comprehensive how-tos to help users get the most out of Windows 10 and its many related technologies. He has an IT background with professional certifications from Microsoft, Cisco, and CompTIA, and he's a recognized member of the Microsoft MVP community.