How to Migrate Stache Entries to 1Password
If you run into any pop-ups or errors, please see the Errors / Pop-up section at the bottom of this page.
Introduction
As Stache is scheduled for retirement in December 2026, this page was created to help you transition your passwords and login information to the new UT‑approved password manager, 1Password.
This migration tool uses an Excel workbook that accepts any number of your Stache entry keys and converts them into a CSV file format compatible with 1Password. After importing the file, your data will be organized and stored in 1Password as “Secure Notes,” which function similarly to traditional Stache entries.
What you will need:
Stache entries (for which you are an Owner)
A 1Password account (log in with yourEID@eid.utexas.edu)
If you are unable to access your 1Password account (deactivated, frozen, etc.) please contact the UT Service Desk for assistance (512-475-9400 or security@utexas.edu).
Download this Excel workbook:
--
Note: This workbook contains two sheets: Stache Entries and Stache Export. On the first sheet (Stache Entries), you will copy and paste your Stache API keys (see instructions below). These entries automatically generate corresponding data on the second sheet (Stache Export), which you can then save as a CSV file and import into 1Password.
Recommendation:
For the best experience, it is recommended to use two screens (one to display this wiki, and the other to switch between Stache, Excel, and 1Password).
If you only have one screen available, it might be helpful to split/resize the apps so they take up the left and right half of your screen.
Please fully read the instructions and follow them carefully.
Exporting from Stache
Begin by going to http://stache.utexas.edu and click on an entry you would like to migrate that you have Owner permissions for.
On the right-hand side, click the Options tab, check “Allow data to be read by API calls” and click Save.
If you do NOT see a Save button, it is because you do not have Owner permissions for the entry. Look under the People tab and contact an Owner of the entry to make changes.
If the “Allow data to be read by API calls” checkbox was already checked, then you are free to move to the next step.
Open the StacheTo1Password Excel template you downloaded at the beginning of the page and open the Stache Entries sheet. If prompted, please Enable Editing and Enable Content on the Security Warning pop-up banner.
First, we’ll need to allow the Excel sheet to communicate with the Stache website.
Note: The following steps only apply to macOS users.
If you are using Windows, skip to step 8.
(macOS only) At the top of the page, under the Data tab, click the drop-down arrow next to Get Data (Power Query) and click Launch Power Query Editor.
(macOS only) This will open a new window, where you’ll click the Home tab > Options > Privacy, check “Allow combining data from multiple sources…”, and click OK.
(macOS only) Exit the Power Query Editor and click Keep.
– Windows users continue here –
Replace the example entry in the sheet by opening up your own Stache entry and copying the Entry Name, API Endpoint, and API Key (X-Stache-Key) to the Stache Entries sheet (see image below).
The spreadsheet supports multi-entry exporting, so you can add additional entries on the same sheet to bulk transfer them.
When copying the API Key, be careful you are not also copying the API Endpoint, as both fields might be auto selected after revealing the key. To avoid this, just double-click the API Key once its revealed and make sure it is the only item selected.
In the Excel ribbon, go to the Data tab, and click Refresh All. It might take a couple of seconds for the data to load.
In macOS, after clicking Refresh All, you will have to click Connect on the “Connect to data source” pop-up for each of the entries on the sheet.
If you run into any pop-ups or errors, please see the Errors / Pop-up section at the bottom of the page.
Now, at the bottom left of the workbook, navigate to the Stache Export sheet to see all the exported entry data from Stache.
In the very top-left, click File > Save As > rename the file to “Stache_Export” > change the file format to a CSV UTF-8 (Comma delimited) (.csv) and save to the folder of your choice.
If you get a pop-up about the file type not supporting workbooks with multiple sheets, just click OK.
Please fully read the instructions and follow them carefully.
Importing to 1Password
In a web browser, open utexas.1password.com and sign into your 1Password account using the “Sign in with Microsoft” button.
If you haven’t already signed up for 1Password, search your inbox for the University of Texas invite link titled “Join University of Texas at Austin on 1Password”.
If the “Join now” link does not work, or you are unable to access your account, you will need to reach out to the UT Service Desk (512-475-9400 or security@utexas.edu) to have your account re-activated.
Next, make sure you are on the 1Password Home page, by checking the top-left corner of the screen and making sure you see the words Password Manager, and clicking Home.
If you are on Windows you should automatically be taken there after signing into the link above.
If you’re on macOS, you will instead be taken to the UT Vaults page (with the UT tower in the top-left). To get to the Home page, in the top left-hand corner, click the University of Texas at Austin drop-down and then click Manage Account. Then click Home in the top left again.
The 1Password equivalent to Stache “Folders” are called Vaults, which allow you to store multiple passwords and logins into one group. On the Password Manager Home page, click +New Vault (on the right-hand side) to create a new Vault and name it accordingly.
If you have an existing Vault, click the gear icon next to the Vault of your choice to enter its settings page.
Once the new Vault is created, click Import Data on the left-hand side.
Scroll down to the section called Somewhere else and click on CSV file.
At the Export your data as a CSV section, click Continue and confirm the Vault you’d like to upload to. Click Continue again, upload the Stache_Export.csv file you saved in the previous section, and click Continue one more time to start labeling/confirming your data.
At the Confirm item types page, you will see a table where you will need to label each row for the data to import properly. When labeling rows, set the header row (1st row) to Ignore Row. Then set each of the other rows with information to Secure Note. Set any empty rows to Ignore Row. (See examples below)
a. If you have multiple pages of entires, make sure you navigate to the other pages to continue labeling each row.
Click Continue, and in the first column, click Add Label and select Title. Then in the second column, select Notes. (See below)
Click Continue one last time to finish, and click View imported items to view the new entries in your Vault.
Note: This tool is designed to help you migrate your stored information from Stache into 1Password. However, there is one important limitation: if a single Stache entry contains multiple passwords, those passwords will not be split into separate entries automatically.
If you want to use 1Password’s website autofill features, you will need to manually create individual Login entries in 1Password - one for each password you want to autofill.
You can format the text in a Secure Note using Markdown. Below is some documentation from 1Password on how to format your notes.
The template above applies some formatting for ease of legibility between section, however, feel free to edit the formatting as needed.
Import Tags
When importing data via CSV to 1Password, an “Imported {Date, Time}” tag gets auto-generated for you to be able to search for those entries in the future.
If you wish to remove these tags, this can ONLY be done in the 1Password application (available to install in Software Center (Windows) and Self Service+ (macOS)). 1Password currently does not support this feature in the web-client.
Errors / Pop-ups
Protected View
Excel, by default, opens downloaded files in Protected View. However, in order to add your Stache entries, editing will need to be enabled.
----
Security Warning
If you see the “Security Warning: External Data Connections have been disabled” message, click Enable Content. If you ignore the message or click the X, you will just get another pop-up later on.
If you did not click Enable Content before clicking Refresh All, click OK on the External Data Source pop-up.
----
Connect to data source / Access Web Content
If you get the Connect to data source pop-up when clicking the “Refresh All” button:
On Windows, https://stache.utexas.edu/ selected and press Connect.
On macOS, leave Authentication kind as Anonymous and press Connect.
----
Microsoft Excel Security Notice
If you get a Security Notice pop-up when clicking the “Refresh All” button, just click OK.
----
Privacy levels
Click the checkbox on Ignore Privacy Levels checks for this file, and click Save.
----
Microsoft Excel multiple worksheets
Make sure you’re still on the Stache Export sheet before clicking OK. If not, go to the Stache Export sheet at the bottom of the workbook, then File > Save As > rename “Stache_Export” as (.csv), and then click OK.