This article will show you how to import passwords in to IT Glue from a CSV file.
- The file must be a CSV file encoded in UTF-8.
- The maximum file size is 100 MB.
- A user account with Creator, Editor, Manager or Administrator role.
Managers and Administrators can also follow this KB, but will also have the option to import data for multiple organizations when choosing a CSV file to import. The steps for importing into multiple organizations are covered in our Importing CSV data into your account KB article.
Creating your CSV file
- Download one of the ZIP files provided at the bottom of this article.
- Sample Excel import files with required fields highlighted (save as CSV when you're ready to import)
- Sample CSV import files
- Open the file you want to use and delete the sample data, but not the header row.
- Paste your information into the sample import file. You can change the order of columns if needed but do not remove the header row.
- Save your file as a CSV (Comma Delimited) document:
- If on a PC, save as CSV (Comma delimited) (*.csv)
- If on a Mac, save as Windows Comma Separated (.csv)
Importing your passwords
- Open the organization you want to import your passwords to, click Passwords from the sidebar, and click Import.
- Click Choose File to select the CSV file you created above. Choose whether to allow partial imports and click then Continue
Important. Toggling the Allow partial import button to "No" will result in the entire import failing if the CSV file is missing any required fields, or if any field contains non-UTF-8 characters.
- Match the columns in your CSV file to the columns from the password Asset by selecting the dropdown under Password Field. If you have fields for id and organization, ensure the corresponding Password Fields are set to Ignore. Click Run Import.
- Once the import is done, you'll get an email from firstname.lastname@example.org that includes a link to view imported rows or details regarding import errors.
You can verify your import was successful by waiting for the email confirmation or by navigating to Account > Import Data and then clicking on the link for your import. You can also navigate to the Global > Assets area to view the information that you imported.
If there are any problems performing these instructions on a PC:
- Open the CSV file in Notepad.
- Click Save As... and then select UTF-8 under Encoding.
- After selecting UTF-8, save the file with a slightly different filename from the original.
- Do not reopen the file, as this will cause it to be re-encoded by Windows.
- Import this new file in to IT Glue.
Sample Download Files