'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Find Custom Excel Templates in macOS Sonoma
Question details
The user needs to locate their custom Excel templates on macOS Sonoma to manage them or transfer them to another Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS Sonoma
- Scenario
- Transferring, backing up, or organizing custom Excel templates on a Mac.
- Observed behavior
- Custom templates are stored in a hidden User Library folder rather than the main system Library, making them difficult to locate without the exact directory path.
Ensure you are logged into your primary user account on your Mac and have a Finder window open.
Use Finder's 'Go to Folder' Command
This is the most direct and reliable way to access the hidden templates folder using its exact file path.
Because macOS hides the personal Library folder by default, using the 'Go to Folder' tool allows you to bypass the hidden directories and jump straight to your Excel templates.
Click anywhere on your desktop to make Finder active. Then, click on the 'Go' menu in the top menu bar and select 'Go to Folder' (or press Shift+Command+G).
Type or paste the following exact path into the search box: ~/Library/Group Containers/UBF8T346G9.Office/User Content/Templates
Press the Return key. The Templates folder will instantly open, allowing you to copy, delete, or manage your custom Excel files.
Navigate Manually via the Hidden User Library
Use this method if you prefer navigating through your system folders manually using keyboard shortcuts to unhide the Library.
Manage Spreadsheets Easily with WPS Office for Mac
Tired of digging through obscure, hidden system folders just to find your spreadsheet templates? WPS Office provides an intuitive, built-in template gallery and fully supports all your existing Microsoft Excel files, making spreadsheet management effortless on macOS.
- 1. Download and Install: Download WPS Office for Mac and complete the quick, lightweight installation process.
- 2. Access the Template Gallery: Launch WPS Spreadsheet and click 'New' to browse thousands of professional templates directly within the app.
- 3. Save Custom Templates Easily: Create your own spreadsheet design and simply go to Menu > Save As > WPS Spreadsheet Template to store it without hunting for hidden system directories.
Frequently Asked Questions
Why can't I find my Excel templates in the main Macintosh HD Library?
macOS uses multiple Library folders. Custom Office templates are saved in your personal User Library (~/Library), which is hidden by default to protect system files, rather than the system-wide Macintosh HD Library.
How do I transfer my custom Excel templates to a new Mac?
Locate the templates in ~/Library/Group Containers/UBF8T346G9.Office/User Content/Templates on your old Mac, copy them to a USB flash drive or cloud storage, and paste them into the exact same folder path on your new Mac.
Can I change the default save location for custom Excel templates on Mac?
Microsoft Office hardcodes the default custom template location to the UBF8T346G9.Office folder structure. While you cannot natively change this default save path in Excel for Mac, you can create an alias (shortcut) of the Templates folder and place it on your desktop for faster access.
