I need to export a dozen or so 1Password entries for a family member. They want it to look tidy and readable. So, I've exported the data to comma delimited text and then import it into Excel.
But no matter how I configure the import, the data is all over the place in Excel. Account names get swapped with logins, URLs get moved to the "Type" column. It's all so random and requires a lot of work to clean up and then cross-reference with the 1Password entries to make sure nothing was missed. I've spent over an hour just to clean up sixteen entries imported into Excel.
It is, frankly, a terrible and infuriating experience.
The export options in 1Password, especially considering the price, are very limited, primitive, flaky, and imprecise. It would be nice if there was an export to html or PDF option.
Is there any way to export data from 1Password so that it looks tidy and organized when imported into Excel or some other text program?
1Password Version: Not Provided Extension Version: Not Provided OS Version: Not Provided
Each of the Categories has different "templates". And those templates have different field names internally, as well as field counts. CSV was never designed to have varying numbers of columns. So the 1Password CSV exporter creates a column for every field you ask, and for certain fields, a value can be mapped into multiple columns.
So your best bet is to export one Category at a time.
There is a way to get your data in a nice, tabular format, but I'm thinking it is going to be more work than you are care to undertake. Sample:
or
So I'm trying to help find a way that's easy for you.
That said, you're right. It's rather pointless to use a secure password manager, and then store such data in an unencrypted plain text document.
Alright, it appears as if the export fields are just organized alphabetically. I can sort of see why they did that for all fields, but not for common fields. I still think that the fields should be ordered to reflect the order in which you enter data in a login item. But it seems like something for the 1Password devs to debate.
I'm selecting certain items from different categories (logins, secure notes, wireless routers, etc) and then exporting them. A family member wants some of their password information in Excel format. I know it's not secure, but that's what they want.
The default export order for common fields does not match that of login entries. The preferred order should be Title, Username, Password, Website, Notes, etc, to reflect the default order of the fields of a brand new login item (before a person enters data). Why is "First One-Time Password" the first item?
There's something weird going on. If I re-order the fields and delete some (which I didn't realize you could do), I have better results. Still, I can export the exact same data twice but Excel will not consistently import them the same. Sometimes it works, sometimes it's badly broken.
I'm going to do some more testing to see if I can figure out if Excel is choking on certain fields.
Are you selecting just the Login entries, by selecting just those entries and exporting Selected items, or are you export everything and trying to clean that up?
I'm just trying to figure out why it isn't working for you (I'm not using the App store version, but I'm guessing that isn't an issue). Do you see one row where this issue occurs, and can you identify the cell that is causing the first breakage? It's possible there is some data that is triggering a bug in the 1Password CSV exporter, as the Tags field does due to the incorrect/non-standard CSV-quoting being done on its value.
I also don't know why the export fields default to that order; it's not generally something users need to care about (because generally when they export, they are moving to a different password manager). But I'm guessing you want to print out these entries, so a tabular order is important to you.
I don't export tags. I only exported "Common Fields": First One-time Password,Notes,Password,Title,Type,URL,Username. I have no idea why they default to that order when exporting but it results in the categories being out of order in Excel.
In addition, entries get displaced to the wrong category. For example, some usernames got moved to the URL column, some secure notes and titles got moved to the Password column, URLs to Type column, etc. It's a jumble and that's just with 16 items. If I had exported dozens or hundreds of items, it would take an impossibly long time to fix.
Sorry, just wanted to be clear, so I can give solid advice.
It appears that exporting of the Tags field breaks the CSV, so don't include that. Here's a quick export I just did without it, exporting to CSV (not Keychain csv):
I set the field order as you see above. Are you including fields other than the default common ones?
Here's a sample of the broken export when including the Tags field:
1Password 7
Version 7.9.3 (70903004)
Mac App Store
As mentioned, I exported to comma delimited text. I also tried tab delimited. Both just result in a mess when imported into Excel. Data is in the wrong columns or even rows.
"}},"componentScriptGroups({\"componentId\":\"custom.widget.Custom_Footer_1PW\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"components/tags/TagView/TagViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageListMenu\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageListMenu-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageView/MessageViewInline\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1747314610093"}],"cachedText({\"lastModified\":\"1747314610093\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1747314610093"}],"message({\"id\":\"message:80800\"})":{"__ref":"ForumReplyMessage:message:80800"},"message({\"id\":\"message:80799\"})":{"__ref":"ForumReplyMessage:message:80799"},"message({\"id\":\"message:80798\"})":{"__ref":"ForumReplyMessage:message:80798"},"message({\"id\":\"message:80797\"})":{"__ref":"ForumReplyMessage:message:80797"},"message({\"id\":\"message:80796\"})":{"__ref":"ForumReplyMessage:message:80796"},"message({\"id\":\"message:80795\"})":{"__ref":"ForumReplyMessage:message:80795"},"message({\"id\":\"message:80794\"})":{"__ref":"ForumReplyMessage:message:80794"},"message({\"id\":\"message:80793\"})":{"__ref":"ForumReplyMessage:message:80793"}},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Former Member","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"true","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MM-dd-yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US","es-ES"]},"repliesSortOrder":{"__typename":"InheritableStringSettingWithPossibleValues","key":"config.user_replies_sort_order","value":"DEFAULT","localValue":"DEFAULT","possibleValues":["DEFAULT","LIKES","PUBLISH_TIME","REVERSE_PUBLISH_TIME"]}},"deleted":false},"CachedAsset:pages-1747314180265":{"__typename":"CachedAsset","id":"pages-1747314180265","value":[{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IcsAdminPage.Page","type":"COMMUNITY","urlPath":"/c/ics-admin-page/page","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"SmartconxAdmin.Page","type":"COMMUNITY","urlPath":"/c/smartconx-admin/page","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1747314180265,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}","userBanned":"We're sorry, but you have been banned from using this site.","userBannedReason":"You have been banned for the following reason: {reason}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"Rank:rank:15":{"__typename":"Rank","id":"rank:15","position":13,"name":"New Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:12887":{"__typename":"User","id":"user:12887","uid":12887,"login":"Boosh","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://www.1password.community/t5/s/cuxzj43862/m_assets/avatars/default/avatar-4.svg?time=0"},"rank":{"__ref":"Rank:rank:15"},"email":"","messagesCount":7,"biography":null,"topicsCount":1,"kudosReceivedCount":0,"kudosGivenCount":0,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-01-18T14:30:23.000-08:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:cuxzj43862/user:12887"},"Category:category:discuss":{"__typename":"Category","id":"category:discuss","entityType":"CATEGORY","displayId":"discuss","nodeType":"category","depth":1,"title":"Discussions","shortTitle":"Discussions","parent":{"__ref":"Category:category:top"},"categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:top":{"__typename":"Category","id":"category:top","entityType":"CATEGORY","displayId":"top","nodeType":"category","depth":0,"title":"Top","shortTitle":"Top"},"Forum:board:1password":{"__typename":"Forum","id":"board:1password","entityType":"FORUM","displayId":"1password","nodeType":"board","depth":2,"conversationStyle":"FORUM","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"REVERSE_PUBLISH_TIME","repliesFormat":"threaded"},"tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":true,"tagType":"PRESET_ONLY","description":"","title":"Password Manager","shortTitle":"Password Manager","parent":{"__ref":"Category:category:discuss"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:cuxzj43862"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:discuss"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"theme":{"__ref":"Theme:customTheme1"},"boardPolicies":{"__typename":"BoardPolicies","canViewSpamDashBoard":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.access_spam_quarantine.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.access_spam_quarantine.allowed.accessDenied","args":[]}},"canArchiveMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.content_archivals.enable_content_archival_settings.accessDenied","key":"error.lithium.policies.content_archivals.enable_content_archival_settings.accessDenied","args":[]}},"canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"eventPath":"category:discuss/community:cuxzj43862board:1password/"},"ForumTopicMessage:message:80792":{"__typename":"ForumTopicMessage","uid":80792,"subject":"Need help exporting passwords to CSV for Excel","id":"message:80792","revisionNum":1,"repliesCount":8,"author":{"__ref":"User:user:12887"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:1password"},"conversation":{"__ref":"Conversation:conversation:80792"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:80792"},"body":"
I need to export a dozen or so 1Password entries for a family member. They want it to look tidy and readable. So, I've exported the data to comma delimited text and then import it into Excel.
\n\n
But no matter how I configure the import, the data is all over the place in Excel. Account names get swapped with logins, URLs get moved to the \"Type\" column. It's all so random and requires a lot of work to clean up and then cross-reference with the 1Password entries to make sure nothing was missed. I've spent over an hour just to clean up sixteen entries imported into Excel.
\n\n
It is, frankly, a terrible and infuriating experience.
\n\n
The export options in 1Password, especially considering the price, are very limited, primitive, flaky, and imprecise. It would be nice if there was an export to html or PDF option.
\n\n
Is there any way to export data from 1Password so that it looks tidy and organized when imported into Excel or some other text program?
\n\n\n\n
1Password Version: Not Provided \nExtension Version: Not Provided \nOS Version: Not Provided
","body@stringLength":"1129","rawBody":"
I need to export a dozen or so 1Password entries for a family member. They want it to look tidy and readable. So, I've exported the data to comma delimited text and then import it into Excel.
\n\n
But no matter how I configure the import, the data is all over the place in Excel. Account names get swapped with logins, URLs get moved to the \"Type\" column. It's all so random and requires a lot of work to clean up and then cross-reference with the 1Password entries to make sure nothing was missed. I've spent over an hour just to clean up sixteen entries imported into Excel.
\n\n
It is, frankly, a terrible and infuriating experience.
\n\n
The export options in 1Password, especially considering the price, are very limited, primitive, flaky, and imprecise. It would be nice if there was an export to html or PDF option.
\n\n
Is there any way to export data from 1Password so that it looks tidy and organized when imported into Excel or some other text program?
\n\n\n\n
1Password Version: Not Provided \nExtension Version: Not Provided \nOS Version: Not Provided
\n","kudosSumWeight":0,"postTime":"2022-03-25T14:03:07.000-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:macos","text":"macos","time":"2025-01-27T11:38:42.471-08:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:80792_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":269},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"searchSnippet":"I need to export a dozen or so 1Password entries for a family member. They want it to look tidy and readable. So, I've exported the data to comma delimited text and then import it into Excel. \n\n B...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDgwMA","node":{"__ref":"ForumReplyMessage:message:80800"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5OQ","node":{"__ref":"ForumReplyMessage:message:80799"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5OA","node":{"__ref":"ForumReplyMessage:message:80798"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5Nw","node":{"__ref":"ForumReplyMessage:message:80797"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5Ng","node":{"__ref":"ForumReplyMessage:message:80796"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5NQ","node":{"__ref":"ForumReplyMessage:message:80795"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5NA","node":{"__ref":"ForumReplyMessage:message:80794"}},{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwzOTowfGludCw4MDgwMCw4MDc5Mw","node":{"__ref":"ForumReplyMessage:message:80793"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}]},"Conversation:conversation:80792":{"__typename":"Conversation","id":"conversation:80792","solved":false,"topic":{"__ref":"ForumTopicMessage:message:80792"},"lastPostingActivityTime":"2022-03-25T17:58:37.000-07:00","lastPostTime":"2022-03-25T17:58:37.000-07:00","unreadReplyCount":8,"isSubscribed":false},"ModerationData:moderation_data:80792":{"__typename":"ModerationData","id":"moderation_data:80792","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:80792_1":{"__typename":"Revision","id":"revision:80792_1","lastEditTime":"2022-03-25T14:03:07.000-07:00"},"CachedAsset:theme:customTheme1-1747314147933":{"__typename":"CachedAsset","id":"theme:customTheme1-1747314147933","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"favicon-1725026196898.png","imageLastModified":"1725026199124","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"Extension_Logo_Programs_IntrepidBlue-1727309633443.png","imageLastModified":"1727309636230","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1250px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"500","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-link-color)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","defaultMessageFontFamily":"var(--lia-bs-font-family-base)","forumColor":"#4099E2","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#148563","blogColor":"#1CBAA0","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#4C6B90","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#2A4D96","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#3B66BC","secondary":"#333333","bodyText":"#1A2552","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#1A285F","#FFF6EB","#E7F6FA","#EFF3FA","#2A4D96","#1A2552","#FFFEFB","#F4ECDF","#010115","#71CDD9","#F4C866","#FF8F78","#B03F91","#FCEDF9","#FFF5F3"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Agile Sans","fontStyle":"NORMAL","fontWeight":"300","h1FontSize":"56px","h2FontSize":"46px","h3FontSize":"38px","h4FontSize":"28px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"Public Sans","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"GOOGLE","name":"Public Sans","styles":[{"style":"NORMAL","weight":"100","__typename":"FontStyleData"},{"style":"NORMAL","weight":"200","__typename":"FontStyleData"},{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"600","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"NORMAL","weight":"800","__typename":"FontStyleData"},{"style":"NORMAL","weight":"900","__typename":"FontStyleData"},{"style":"ITALIC","weight":"100","__typename":"FontStyleData"},{"style":"ITALIC","weight":"200","__typename":"FontStyleData"},{"style":"ITALIC","weight":"300","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"},{"style":"ITALIC","weight":"500","__typename":"FontStyleData"},{"style":"ITALIC","weight":"600","__typename":"FontStyleData"},{"style":"ITALIC","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"800","__typename":"FontStyleData"},{"style":"ITALIC","weight":"900","__typename":"FontStyleData"}],"assetNames":["PublicSans-italic-100.woff2","PublicSans-italic-200.woff2","PublicSans-italic-300.woff2","PublicSans-italic-400.woff2","PublicSans-italic-500.woff2","PublicSans-italic-600.woff2","PublicSans-italic-700.woff2","PublicSans-italic-800.woff2","PublicSans-italic-900.woff2","PublicSans-normal-100.woff2","PublicSans-normal-200.woff2","PublicSans-normal-300.woff2","PublicSans-normal-400.woff2","PublicSans-normal-500.woff2","PublicSans-normal-600.woff2","PublicSans-normal-700.woff2","PublicSans-normal-800.woff2","PublicSans-normal-900.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"Agile Sans","styles":[{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"ITALIC","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"700","__typename":"FontStyleData"},{"style":"NORMAL","weight":"400","__typename":"FontStyleData"}],"assetNames":["AgileSans-normal-300.woff2","AgileSans-italic-300.woff2","AgileSans-normal-700.woff2","AgileSans-italic-700.woff2","AgileSans-normal-400.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1747314610093","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:onepassword.prod:pages/forums/ForumMessagePage:board:1password-1747314610093":{"__typename":"CachedAsset","id":"quilt:onepassword.prod:pages/forums/ForumMessagePage:board:1password-1747314610093","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"section-1743749736035","layout":"ONE_COLUMN","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"OneColumnQuiltSection","columnMap":{"main":[],"__typename":"OneSectionColumns"}},{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"nodes.widget.nodeActionButtonWidget","className":null,"props":{"buttonAlignment":"center","buttonStyle":"lg","actionButtonTitle":"","lazyLoad":false,"buttonWidth":"full_width"},"__typename":"QuiltComponent"},{"id":"messages.widget.messageListForNodeByRecentActivityWidget","className":null,"props":{"hideIfEmpty":true,"useTitle":true,"showTabs":false,"pageSize":5,"pagerVariant":{"type":"loadMore"},"style":"compact","viewVariant":{"type":"inline","props":{"useRepliesCount":false,"useMedia":false,"useAuthorRank":false,"useNode":false,"boardIconSize":"24","truncateBodyLength":-1,"useNodeLink":true,"usePreviewMedia":false,"timeStampType":"conversation.lastPostingActivityTime","avatarSize":"40","useTextBody":true,"useSolvedBadge":true,"subjectAs":"h6","renderPostTimeBeforeAuthor":true,"useAvatar":true,"useTimeToRead":false,"useSpoilerFreeBody":true,"useKudosCount":false,"useViewCount":false,"useBody":false,"useTags":false,"clampSubjectLines":1,"useBoardIcon":false,"useMessageTimeLink":true,"clampBodyLines":3,"useAuthorLogin":true,"useUnreadCount":false,"useNodeHoverCard":true,"useSearchSnippet":false}},"panelType":"divider","sorts":{"conversationLastPostingActivityTime":{"direction":"DESC"}}},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1747314610093","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1747314610093","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1747314610093","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:quiltWrapper:onepassword.prod:Common:1747317225044":{"__typename":"CachedAsset","id":"quiltWrapper:onepassword.prod:Common:1747317225044","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":false,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[],"linkType":"INTERNAL","id":"Common-discuss-link","params":{"categoryId":"discuss"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"Common-community-blog-link","params":{"boardId":"community-blog","categoryId":"whats-new"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"events-link","params":{"boardId":"events","categoryId":"top"},"routeName":"EventBoardPage"}],"linkType":"INTERNAL","id":"whats-new-link","params":{"categoryId":"whats-new"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"Common-developers-link","params":{"boardId":"developers","categoryId":"developers"},"routeName":"ForumBoardPage"},{"children":[{"linkType":"INTERNAL","id":"guides-link","params":{"categoryId":"guides"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link","url":"https://support.1password.com/","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-5","url":"https://blog.1password.com/","target":"BLANK"},{"linkType":"INTERNAL","id":"Common-developer-blog-link","params":{"boardId":"developer-blog","categoryId":"blog-home"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"external-4","params":{"boardId":"random-but-memorable","categoryId":"connect"},"routeName":"BlogBoardPage"}],"linkType":"INTERNAL","id":"connect-1","params":{"categoryId":"connect"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"advocacy","params":{"categoryId":"advocacy"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"300","controllerHighlightColor":"#71CDD9","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"14px","linkBoxShadowHover":"none","backgroundOpacity":1,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"24px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"16px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"#1A2552","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerHighlightTextColor":"var(--lia-yiq-dark)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"#1A2552","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-primary)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"16px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"#1A2552","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"#1A2552"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"var(--lia-bs-white)","linkHighlightColor":"#1A285F","visualEffects":{"showBottomBorder":false},"linkTextColor":"#1A285F"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":false},"backgroundOpacity":100,"backgroundImageProps":{"backgroundSize":"COVER","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"#1A285F"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"#1A285F","items":[{"id":"custom.widget.Custom_Footer_1PW","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":false,"usePageWidth":true,"backgroundColor":"#1a285f","useBackground":false,"backgroundOpacity":1,"title":"Footer","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"QueryVariables:TopicReplyList:message:80792:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:80792:1","value":{"id":"message:80792","first":10,"sorts":{"postTime":{"direction":"DESC"}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"postTime":{"direction":"DESC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:component:custom.widget.Custom_Footer_1PW-en-us-1747314616273":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_1PW-en-us-1747314616273","value":{"component":{"id":"custom.widget.Custom_Footer_1PW","template":{"id":"Custom_Footer_1PW","markupLanguage":"HANDLEBARS","style":".custom-footer-container {\n --footer-bg-color: #1a285f;\n --footer-fg-color: #fff;\n --footer-border-color: hsla(0, 0%, 100%, 0.1);\n --footer-link-color: hsla(0, 0%, 100%, 0.8);\n background-color: var(--footer-bg-color);\n color: var(--footer-fg-color);\n padding-bottom: 3rem;\n padding-top: 3rem;\n\n @media (min-width: 1180px) {\n padding-bottom: 4rem;\n padding-top: 4rem;\n }\n\n hr {\n border-color: var(--footer-border-color);\n margin-bottom: 0;\n margin-top: 2rem;\n }\n\n ol {\n list-style-type: decimal;\n }\n\n ul {\n list-style-type: disc;\n }\n\n ul,\n ol {\n list-style-position: outside;\n }\n\n li {\n margin-bottom: 0.8em;\n position: relative;\n }\n\n li ol,\n li ul {\n margin: 0.8em 0;\n }\n\n nav ul,\n nav ol {\n list-style: none;\n list-style-image: none;\n }\n\n a {\n color: var(--footer-link-color);\n\n &:hover {\n color: var(--footer-link-color);\n text-decoration: underline;\n }\n }\n\n img {\n max-width: 100%;\n height: auto;\n }\n\n ul.list-unstyled {\n list-style: none;\n padding-left: 0;\n }\n\n ul.list-inline {\n display: flex;\n padding-left: 0;\n\n li {\n display: inline-block;\n margin-bottom: 0;\n padding-right: 1.5rem;\n }\n }\n\n .grid-wrapper {\n display: grid;\n grid-template-columns: repeat(4, 1fr);\n column-gap: var(--lia-bs-grid-gutter-width);\n row-gap: 1rem;\n }\n\n .custom-footer-navigation {\n .grid-wrapper {\n grid-template-columns: repeat(1, 1fr);\n\n @media (min-width: 576px) {\n grid-template-columns: repeat(2, 1fr);\n }\n\n @media (min-width: 1180px) {\n grid-template-columns: repeat(6, 1fr);\n }\n }\n\n li {\n line-height: 1.6;\n }\n }\n\n .custom-footer-logo {\n padding-top: 3rem;\n\n @media (min-width: 1180px) {\n padding-top: 4rem;\n }\n }\n .custom-footer-copyright {\n ul {\n display: grid;\n grid-template-columns: repeat(2, 1fr);\n column-gap: var(--lia-bs-grid-gutter-width);\n row-gap: 1rem;\n\n @media (min-width: 1180px) {\n display: block;\n }\n }\n\n p {\n margin-top: 2rem;\n font-size: var(--lia-bs-font-size-sm);\n\n @media (min-width: 1180px) {\n margin-top: 0.5rem;\n }\n }\n\n p:last-child {\n margin-bottom: 0;\n }\n }\n\n .custom-footer-additional-info {\n display: flex;\n flex-direction: column;\n justify-content: stretch;\n padding-top: 2rem;\n\n .custom-footer-social-media {\n padding-top: 2rem;\n width: 100%;\n\n @media (min-width: 1180px) {\n padding-top: 0;\n padding-left: var(--lia-bs-grid-gutter-width);\n flex-direction: row;\n justify-content: flex-end;\n display: flex;\n align-items: center;\n width: auto;\n flex-grow: 1;\n }\n }\n\n @media (min-width: 1180px) {\n flex-direction: row;\n }\n }\n}\n\n.custom-footer {\n padding-left: var(--lia-bs-grid-gutter-width);\n padding-right: var(--lia-bs-grid-gutter-width);\n\n @media (min-width: 576px) {\n padding-left: 0;\n padding-right: 0;\n }\n}\n\n.custom-footer-social-media {\n ul.list-inline {\n display: flex;\n justify-content: space-between;\n margin-bottom: 0;\n\n li {\n padding-right: 0;\n\n a {\n padding: 0.75rem;\n\n svg {\n width: 20px;\n height: auto;\n }\n }\n }\n }\n}\n\n/* Toggles for expanding/collapsing footer links */\n.custom-footer-navigation {\n .ui-caret svg {\n transform: rotate(90deg);\n }\n .transition-transform {\n transition-property: transform;\n transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1);\n transition-duration: 0.15s;\n }\n button {\n background-color: transparent;\n -webkit-appearance: none;\n padding: 0;\n border: 0;\n color: var(--footer-fg-color);\n font-weight: bold;\n margin-bottom: 0.8em;\n padding-right: 10px;\n text-align: left;\n\n span {\n pointer-events: none;\n display: inline-block;\n margin-left: 4px;\n width: 12px;\n height: 12px;\n\n @media (min-width: 1180px) {\n display: none;\n }\n }\n }\n button[aria-expanded='true'] {\n + ul {\n display: block;\n }\n .ui-caret svg {\n transform: rotate(-90deg);\n }\n }\n button[aria-expanded='false'] + ul {\n display: none;\n }\n}\n\n.d-mobile {\n display: block;\n\n @media (min-width: 1180px) {\n display: none;\n }\n}\n","texts":{},"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer_1PW","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_Custom_Footer_1PW_custom-footer-container_1wtw2_1 {\n --footer-bg-color: #1a285f;\n --footer-fg-color: #fff;\n --footer-border-color: hsla(0, 0%, 100%, 0.1);\n --footer-link-color: hsla(0, 0%, 100%, 0.8);\n background-color: var(--footer-bg-color);\n color: var(--footer-fg-color);\n padding-bottom: 3rem;\n padding-top: 3rem;\n\n @media (min-width: 1180px) {\n padding-bottom: 4rem;\n padding-top: 4rem;\n }\n\n hr {\n border-color: var(--footer-border-color);\n margin-bottom: 0;\n margin-top: 2rem;\n }\n\n ol {\n list-style-type: decimal;\n }\n\n ul {\n list-style-type: disc;\n }\n\n ul,\n ol {\n list-style-position: outside;\n }\n\n li {\n margin-bottom: 0.8em;\n position: relative;\n }\n\n li ol,\n li ul {\n margin: 0.8em 0;\n }\n\n nav ul,\n nav ol {\n list-style: none;\n list-style-image: none;\n }\n\n a {\n color: var(--footer-link-color);\n\n &:hover {\n color: var(--footer-link-color);\n text-decoration: underline;\n }\n }\n\n img {\n max-width: 100%;\n height: auto;\n }\n\n ul.custom_widget_Custom_Footer_1PW_list-unstyled_1wtw2_65 {\n list-style: none;\n padding-left: 0;\n }\n\n ul.custom_widget_Custom_Footer_1PW_list-inline_1wtw2_70 {\n display: flex;\n padding-left: 0;\n\n li {\n display: inline-block;\n margin-bottom: 0;\n padding-right: 1.5rem;\n }\n }\n\n .custom_widget_Custom_Footer_1PW_grid-wrapper_1wtw2_81 {\n display: grid;\n grid-template-columns: repeat(4, 1fr);\n column-gap: var(--lia-bs-grid-gutter-width);\n row-gap: 1rem;\n }\n\n .custom_widget_Custom_Footer_1PW_custom-footer-navigation_1wtw2_88 {\n .custom_widget_Custom_Footer_1PW_grid-wrapper_1wtw2_81 {\n grid-template-columns: repeat(1, 1fr);\n\n @media (min-width: 576px) {\n grid-template-columns: repeat(2, 1fr);\n }\n\n @media (min-width: 1180px) {\n grid-template-columns: repeat(6, 1fr);\n }\n }\n\n li {\n line-height: 1.6;\n }\n }\n\n .custom_widget_Custom_Footer_1PW_custom-footer-logo_1wtw2_106 {\n padding-top: 3rem;\n\n @media (min-width: 1180px) {\n padding-top: 4rem;\n }\n }\n .custom_widget_Custom_Footer_1PW_custom-footer-copyright_1wtw2_113 {\n ul {\n display: grid;\n grid-template-columns: repeat(2, 1fr);\n column-gap: var(--lia-bs-grid-gutter-width);\n row-gap: 1rem;\n\n @media (min-width: 1180px) {\n display: block;\n }\n }\n\n p {\n margin-top: 2rem;\n font-size: var(--lia-bs-font-size-sm);\n\n @media (min-width: 1180px) {\n margin-top: 0.5rem;\n }\n }\n\n p:last-child {\n margin-bottom: 0;\n }\n }\n\n .custom_widget_Custom_Footer_1PW_custom-footer-additional-info_1wtw2_139 {\n display: flex;\n flex-direction: column;\n justify-content: stretch;\n padding-top: 2rem;\n\n .custom_widget_Custom_Footer_1PW_custom-footer-social-media_1wtw2_145 {\n padding-top: 2rem;\n width: 100%;\n\n @media (min-width: 1180px) {\n padding-top: 0;\n padding-left: var(--lia-bs-grid-gutter-width);\n flex-direction: row;\n justify-content: flex-end;\n display: flex;\n align-items: center;\n width: auto;\n flex-grow: 1;\n }\n }\n\n @media (min-width: 1180px) {\n flex-direction: row;\n }\n }\n}\n\n.custom_widget_Custom_Footer_1PW_custom-footer_1wtw2_1 {\n padding-left: var(--lia-bs-grid-gutter-width);\n padding-right: var(--lia-bs-grid-gutter-width);\n\n @media (min-width: 576px) {\n padding-left: 0;\n padding-right: 0;\n }\n}\n\n.custom_widget_Custom_Footer_1PW_custom-footer-social-media_1wtw2_145 {\n ul.custom_widget_Custom_Footer_1PW_list-inline_1wtw2_70 {\n display: flex;\n justify-content: space-between;\n margin-bottom: 0;\n\n li {\n padding-right: 0;\n\n a {\n padding: 0.75rem;\n\n svg {\n width: 1.25rem;\n height: auto;\n }\n }\n }\n }\n}\n\n/* Toggles for expanding/collapsing footer links */\n\n.custom_widget_Custom_Footer_1PW_custom-footer-navigation_1wtw2_88 {\n .custom_widget_Custom_Footer_1PW_ui-caret_1wtw2_200 svg {\n transform: rotate(90deg);\n }\n .custom_widget_Custom_Footer_1PW_transition-transform_1wtw2_203 {\n transition-property: transform;\n transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1);\n transition-duration: 0.15s;\n }\n button {\n background-color: transparent;\n -webkit-appearance: none;\n padding: 0;\n border: 0;\n color: var(--footer-fg-color);\n font-weight: bold;\n margin-bottom: 0.8em;\n padding-right: 0.625rem;\n text-align: left;\n\n span {\n pointer-events: none;\n display: inline-block;\n margin-left: 0.25rem;\n width: 0.75rem;\n height: 0.75rem;\n\n @media (min-width: 1180px) {\n display: none;\n }\n }\n }\n button[aria-expanded='true'] {\n + ul {\n display: block;\n }\n .custom_widget_Custom_Footer_1PW_ui-caret_1wtw2_200 svg {\n transform: rotate(-90deg);\n }\n }\n button[aria-expanded='false'] + ul {\n display: none;\n }\n}\n\n.custom_widget_Custom_Footer_1PW_d-mobile_1wtw2_244 {\n display: block;\n\n @media (min-width: 1180px) {\n display: none;\n }\n}\n","tokens":{"custom-footer-container":"custom_widget_Custom_Footer_1PW_custom-footer-container_1wtw2_1","list-unstyled":"custom_widget_Custom_Footer_1PW_list-unstyled_1wtw2_65","list-inline":"custom_widget_Custom_Footer_1PW_list-inline_1wtw2_70","grid-wrapper":"custom_widget_Custom_Footer_1PW_grid-wrapper_1wtw2_81","custom-footer-navigation":"custom_widget_Custom_Footer_1PW_custom-footer-navigation_1wtw2_88","custom-footer-logo":"custom_widget_Custom_Footer_1PW_custom-footer-logo_1wtw2_106","custom-footer-copyright":"custom_widget_Custom_Footer_1PW_custom-footer-copyright_1wtw2_113","custom-footer-additional-info":"custom_widget_Custom_Footer_1PW_custom-footer-additional-info_1wtw2_139","custom-footer-social-media":"custom_widget_Custom_Footer_1PW_custom-footer-social-media_1wtw2_145","custom-footer":"custom_widget_Custom_Footer_1PW_custom-footer_1wtw2_1","ui-caret":"custom_widget_Custom_Footer_1PW_ui-caret_1wtw2_200","transition-transform":"custom_widget_Custom_Footer_1PW_transition-transform_1wtw2_203","d-mobile":"custom_widget_Custom_Footer_1PW_d-mobile_1wtw2_244"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1747314610093","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1747314610093","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1747314610093","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solution","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1747314610093","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1747314610093","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeActionButtonWidget-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeActionButtonWidget-1747314610093","value":{"defaultActionButtonTitle":"Start a Conversation","actionButton.grouphub.startDiscussion":"Start a Discussion","actionButton.title@board:FORUM":"Start a Discussion","actionButton.title@board:BLOG":"Create a Blog Post","actionButton.title@board:TKB":"Create an Article","actionButton.title@board:OCCASION":"Create an Event","actionButton.title@board:IDEA":"Suggest an Idea","joinGroupHub":"Join Group","join.successHeader":"Welcome","join.successMessage":"You are now a member of this group and are subscribed to updates.","errorMessage":"An unidentified problem occurred during the action you took. Please try again later.","errorHeader":"Error - Action Failed"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1747314610093","value":{"title@userScope:other":"Recent Content","title@userScope:self":"Contributions","title@board:FORUM@userScope:other":"Recent Discussions","title@board:BLOG@userScope:other":"Recent Blogs","emptyDescription":"No content to show","MessageListForNodeByRecentActivityWidgetEditor.nodeScope.label":"Scope","title@instance:1727702904251":"Latest Newsletters","title@instance:1732112739483":"Recent Articles","title@instance:1732119989837":"Update Feed","title@instance:abJhYf":"Recent Articles","title@instance:kUSLGS":"Latest Newsletters","title@instance:1732119657269":"Solved Questions","title@instance:dTqXWb":"Discussions","title@instance:EAxCMw":"Discussions","title@instance:1741957038896":"Latest episodes","title@instance:OsOvnG":"Discussions","title@instance:ZaipAm":"Discussions","title@instance:1740593202501":"Recent blogs","title@instance:1747237300106":"Latest issues","title@instance:yGWkpv":"Latest issues","title@instance:AcDRSr":"Recent Posts","title@instance:1732914396339":"Recent News","title@instance:1732567801012":"Discussions","title@instance:1727133630048":"Recent Discussions","title@instance:FBuTVZ":"Recent Posts","title@instance:EAAWmG":"Recent Articles","title@instance:1732301193968":"","title@instance:QiREkA":"Recent Discussions","title@instance:RogiCk":"Latest Discussions","title@instance:1725302258407":"Latest Customer Stories","title@instance:dijhdB":"Latest Newsletters","title@instance:1728299367051":"Articles","title@instance:1726826980948":"Latest Discussions","title@instance:1747262396881":"Recent blog posts","title@instance:ZiIzYQ":"All Discussions","title@instance:1729166245753":"Recent Articles","title@instance:KRhZhr":"Discussions","title@instance:liqPRo":"Recent Discussions","title@instance:1738243059086":"Recent Spotlights","title@instance:1726688746265":"Join the Discussion","title@instance:FEJPuG":"Solutions","title@instance:1737563060995":"Recent posts","title@instance:1726576632244":"Meet the 1Password Community","title@instance:1727704313965":"Latest issues","title@instance:1747237462553":"Latest issues","title@instance:1726700123617":"","title@instance:1732119864142":"Group Feed","title@instance:1726152662042":"Latest Discussions","title@instance:1726688554099":"Recent Updates","title@instance:WNbNGW":"Latest Discussions","title@instance:dZkinr":"Latest Newsletters"},"localOverride":false},"Blog:board:community-blog":{"__typename":"Blog","id":"board:community-blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:connect":{"__typename":"Category","id":"category:connect","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:advocacy":{"__typename":"Category","id":"category:advocacy","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Occasion:board:events":{"__typename":"Occasion","id":"board:events","boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"occasionPolicies":{"__typename":"OccasionPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:developers":{"__typename":"Forum","id":"board:developers","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:whats-new":{"__typename":"Category","id":"category:whats-new","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:guides":{"__typename":"Category","id":"category:guides","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:random-but-memorable":{"__typename":"Blog","id":"board:random-but-memorable","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:developer-blog":{"__typename":"Blog","id":"board:developer-blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Conversation:conversation:155230":{"__typename":"Conversation","id":"conversation:155230","topic":{"__typename":"ForumTopicMessage","uid":155230},"lastPostingActivityTime":"2025-05-17T05:43:56.904-07:00","solved":false},"ForumTopicMessage:message:155230":{"__typename":"ForumTopicMessage","subject":"Beta Release: New MSIX Installer for 1Password for Windows","conversation":{"__ref":"Conversation:conversation:155230"},"id":"message:155230","revisionNum":5,"uid":155230,"depth":0,"board":{"__ref":"Forum:board:1password"},"author":{"__typename":"User","uid":18438,"login":"1P_justin","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://www.1password.community/t5/s/cuxzj43862/images/dS0xODQzOC1talByaGk?image-coordinates=0%2C0%2C512%2C512"}},"metrics":{"__typename":"MessageMetrics","views":524},"postTime":"2025-04-28T10:21:20.149-07:00","lastPublishTime":"2025-05-15T07:31:28.143-07:00","readOnly":false},"Conversation:conversation:156325":{"__typename":"Conversation","id":"conversation:156325","topic":{"__typename":"ForumTopicMessage","uid":156325},"lastPostingActivityTime":"2025-05-17T05:38:13.625-07:00","solved":false},"ForumTopicMessage:message:156325":{"__typename":"ForumTopicMessage","subject":"Why Brown v. Board of Education Changed America’s Schools Forever?","conversation":{"__ref":"Conversation:conversation:156325"},"id":"message:156325","revisionNum":1,"uid":156325,"depth":0,"board":{"__ref":"Forum:board:1password"},"author":{"__typename":"User","uid":20311,"login":"EmmaJane","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://www.1password.community/t5/s/cuxzj43862/m_assets/avatars/default/avatar-8.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":5},"postTime":"2025-05-17T05:38:13.625-07:00","lastPublishTime":"2025-05-17T05:38:13.625-07:00","readOnly":false},"Conversation:conversation:156324":{"__typename":"Conversation","id":"conversation:156324","topic":{"__typename":"ForumTopicMessage","uid":156324},"lastPostingActivityTime":"2025-05-17T03:52:35.908-07:00","solved":false},"ForumTopicMessage:message:156324":{"__typename":"ForumTopicMessage","subject":"Touchscreen Gloves | Convenience Meets Comfort in Cold Weather","conversation":{"__ref":"Conversation:conversation:156324"},"id":"message:156324","revisionNum":1,"uid":156324,"depth":0,"board":{"__ref":"Forum:board:1password"},"author":{"__typename":"User","uid":20311,"login":"EmmaJane","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://www.1password.community/t5/s/cuxzj43862/m_assets/avatars/default/avatar-8.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":5},"postTime":"2025-05-17T03:52:35.908-07:00","lastPublishTime":"2025-05-17T03:52:35.908-07:00","readOnly":false},"Conversation:conversation:156323":{"__typename":"Conversation","id":"conversation:156323","topic":{"__typename":"ForumTopicMessage","uid":156323},"lastPostingActivityTime":"2025-05-17T01:18:39.488-07:00","solved":false},"ForumTopicMessage:message:156323":{"__typename":"ForumTopicMessage","subject":"k8s x local env - complicated secrets workflow","conversation":{"__ref":"Conversation:conversation:156323"},"id":"message:156323","revisionNum":3,"uid":156323,"depth":0,"board":{"__ref":"Forum:board:1password"},"author":{"__typename":"User","uid":20545,"login":"morpig","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://www.1password.community/t5/s/cuxzj43862/m_assets/avatars/default/avatar-10.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":8},"postTime":"2025-05-17T01:17:34.785-07:00","lastPublishTime":"2025-05-17T01:18:39.488-07:00","readOnly":false},"Conversation:conversation:61698":{"__typename":"Conversation","id":"conversation:61698","topic":{"__typename":"ForumTopicMessage","uid":61698},"lastPostingActivityTime":"2025-05-17T00:59:12.367-07:00","solved":false},"ForumTopicMessage:message:61698":{"__typename":"ForumTopicMessage","subject":"Support Floorp","conversation":{"__ref":"Conversation:conversation:61698"},"id":"message:61698","revisionNum":1,"uid":61698,"depth":0,"board":{"__ref":"Forum:board:1password"},"author":{"__typename":"User","uid":-1,"login":"","registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS"},"deleted":false,"avatar":null},"metrics":{"__typename":"MessageMetrics","views":1723},"postTime":"2023-10-13T23:03:20.000-07:00","lastPublishTime":"2023-10-13T23:03:20.000-07:00","readOnly":false},"Rank:rank:10":{"__typename":"Rank","id":"rank:10","position":9,"name":"Super Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:17359":{"__typename":"User","id":"user:17359","uid":17359,"login":"MrC","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2013-04-25T10:38:38.000-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://www.1password.community/legacyfs/online/onepassword_avatars/userpics/59IQBANBY257.jpg"},"rank":{"__ref":"Rank:rank:10"},"entityType":"USER","eventPath":"community:cuxzj43862/user:17359"},"ModerationData:moderation_data:80800":{"__typename":"ModerationData","id":"moderation_data:80800","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80800":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:17359"},"id":"message:80800","revisionNum":1,"uid":80800,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80800"},"body":"
Each of the Categories has different \"templates\". And those templates have different field names internally, as well as field counts. CSV was never designed to have varying numbers of columns. So the 1Password CSV exporter creates a column for every field you ask, and for certain fields, a value can be mapped into multiple columns.
\n\n
So your best bet is to export one Category at a time.
\n\n
There is a way to get your data in a nice, tabular format, but I'm thinking it is going to be more work than you are care to undertake. Sample:
\n\n
\n\n
or
\n\n
\n\n
So I'm trying to help find a way that's easy for you.
\n\n
That said, you're right. It's rather pointless to use a secure password manager, and then store such data in an unencrypted plain text document.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T17:58:37.000-07:00","lastPublishTime":"2022-03-25T17:58:37.000-07:00","metrics":{"__typename":"MessageMetrics","views":0},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80800","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}]},"ModerationData:moderation_data:80799":{"__typename":"ModerationData","id":"moderation_data:80799","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80799":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:12887"},"id":"message:80799","revisionNum":1,"uid":80799,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80799"},"body":"
Alright, it appears as if the export fields are just organized alphabetically. I can sort of see why they did that for all fields, but not for common fields. I still think that the fields should be ordered to reflect the order in which you enter data in a login item. But it seems like something for the 1Password devs to debate.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T17:41:45.000-07:00","lastPublishTime":"2022-03-25T17:41:45.000-07:00","metrics":{"__typename":"MessageMetrics","views":3},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80799","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}]},"ModerationData:moderation_data:80798":{"__typename":"ModerationData","id":"moderation_data:80798","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80798":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:12887"},"id":"message:80798","revisionNum":1,"uid":80798,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80798"},"body":"
I'm selecting certain items from different categories (logins, secure notes, wireless routers, etc) and then exporting them. A family member wants some of their password information in Excel format. I know it's not secure, but that's what they want.
\n\n
The default export order for common fields does not match that of login entries. The preferred order should be Title, Username, Password, Website, Notes, etc, to reflect the default order of the fields of a brand new login item (before a person enters data). Why is \"First One-Time Password\" the first item?
\n\n
There's something weird going on. If I re-order the fields and delete some (which I didn't realize you could do), I have better results. Still, I can export the exact same data twice but Excel will not consistently import them the same. Sometimes it works, sometimes it's badly broken.
\n\n
I'm going to do some more testing to see if I can figure out if Excel is choking on certain fields.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T17:36:00.000-07:00","lastPublishTime":"2022-03-25T17:36:00.000-07:00","metrics":{"__typename":"MessageMetrics","views":3},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80798","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}]},"ModerationData:moderation_data:80797":{"__typename":"ModerationData","id":"moderation_data:80797","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80797":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:17359"},"id":"message:80797","revisionNum":1,"uid":80797,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80797"},"body":"
Are you selecting just the Login entries, by selecting just those entries and exporting Selected items, or are you export everything and trying to clean that up?
\n\n
I'm just trying to figure out why it isn't working for you (I'm not using the App store version, but I'm guessing that isn't an issue). Do you see one row where this issue occurs, and can you identify the cell that is causing the first breakage? It's possible there is some data that is triggering a bug in the 1Password CSV exporter, as the Tags field does due to the incorrect/non-standard CSV-quoting being done on its value.
\n\n
I also don't know why the export fields default to that order; it's not generally something users need to care about (because generally when they export, they are moving to a different password manager). But I'm guessing you want to print out these entries, so a tabular order is important to you.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T17:28:39.000-07:00","lastPublishTime":"2022-03-25T17:28:39.000-07:00","metrics":{"__typename":"MessageMetrics","views":3},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80797","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}]},"ModerationData:moderation_data:80796":{"__typename":"ModerationData","id":"moderation_data:80796","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80796":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:12887"},"id":"message:80796","revisionNum":1,"uid":80796,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80796"},"body":"
I don't export tags. I only exported \"Common Fields\": First One-time Password,Notes,Password,Title,Type,URL,Username. I have no idea why they default to that order when exporting but it results in the categories being out of order in Excel.
\n\n
In addition, entries get displaced to the wrong category. For example, some usernames got moved to the URL column, some secure notes and titles got moved to the Password column, URLs to Type column, etc. It's a jumble and that's just with 16 items. If I had exported dozens or hundreds of items, it would take an impossibly long time to fix.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T16:56:33.000-07:00","lastPublishTime":"2022-03-25T16:56:33.000-07:00","metrics":{"__typename":"MessageMetrics","views":3},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80796","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}]},"ModerationData:moderation_data:80795":{"__typename":"ModerationData","id":"moderation_data:80795","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80795":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:17359"},"id":"message:80795","revisionNum":1,"uid":80795,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80795"},"body":"
Sorry, just wanted to be clear, so I can give solid advice.
\n\n
It appears that exporting of the Tags field breaks the CSV, so don't include that. Here's a quick export I just did without it, exporting to CSV (not Keychain csv):
\n\n
\n\n
I set the field order as you see above. Are you including fields other than the default common ones?
\n\n
Here's a sample of the broken export when including the Tags field:
\n\n
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T16:42:11.000-07:00","lastPublishTime":"2022-03-25T16:42:11.000-07:00","metrics":{"__typename":"MessageMetrics","views":0},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80795","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:80794":{"__typename":"ModerationData","id":"moderation_data:80794","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80794":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:12887"},"id":"message:80794","revisionNum":1,"uid":80794,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80794"},"body":"
Latest version:
\n\n
1Password 7 \nVersion 7.9.3 (70903004) \nMac App Store
\n\n
As mentioned, I exported to comma delimited text. I also tried tab delimited. Both just result in a mess when imported into Excel. Data is in the wrong columns or even rows.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T16:19:41.000-07:00","lastPublishTime":"2022-03-25T16:19:41.000-07:00","metrics":{"__typename":"MessageMetrics","views":4},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80794","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:80793":{"__typename":"ModerationData","id":"moderation_data:80793","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:80793":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:17359"},"id":"message:80793","revisionNum":1,"uid":80793,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:1password"},"parent":{"__ref":"ForumTopicMessage:message:80792"},"conversation":{"__ref":"Conversation:conversation:80792"},"subject":"Re: Need help exporting passwords to CSV for Excel","moderationData":{"__ref":"ModerationData:moderation_data:80793"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"92","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-03-25T16:17:30.000-07:00","lastPublishTime":"2022-03-25T16:17:30.000-07:00","metrics":{"__typename":"MessageMetrics","views":3},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:discuss/community:cuxzj43862board:1password/message:80792/message:80793","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[{"__typename":"CustomStringField","name":"smartconx_source_identifier","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_message_origin","stringValue":""},{"__typename":"CustomStringField","name":"smartconx_share_messages","stringValue":""}],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:text:en_US-components/community/Navbar-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1747314610093","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","external-1":"Using 1Password at Home","Common-community-blog-link":"Community blog","testing4personal-products-1":"Our Apps","developers":"Developers","developer-forums":"Developer Forums","testing4business":"Individuals & Families","testing4personal-products-2":"Support Forums","testing123":"1Password (TEST)","device-trust-link":"Device Trust","passage-link":"Passage","beta-1":"Beta Program","advocacy":"Champions","business-and-teams":"Using 1Password","external-9":"1Password for Open Source","external-8":"Downloads","news-link":"Industry News","external-7":"Status Page","external-6":"Release Notes","announcements-news":"Announcements & News","external-5":"1Password blog","memberships-and-families":"Developer","external-4":"Random But Memorable","events":"Events","external-3":"Documentation","external-2":"Developers","discuss-link":"Discussions","testing4personal-products":"Individual & Families","lounge-link":"Lounge","testing4business-1":"Betas & Pre-releases","external":"Using 1Password at Work","testing4resources-1":"Blog","customer-stories":"Customer Spotlights","product-feedback-link":"Product Feedback","advocacy-1":"Become a Champion","ideas-test":"Product Ideas","events-link":"Events","developer-newsletter":"Developer Newsletter","external-link":"Help and documentation","support":"Support","1password-link":"Password Manager","product-feedback":"Product Feedback","contribute":"Contribute","employeeforum":"Employee","guides-link":"Guides and toolkits","products":"Our Apps","general":"General","Common-developer-blog-link":"Developer blog","test-structure":"Developer Hub","connect":"Discussions","beta":"Product","developers-link":"Engage","testing4products":"Forums","testing4resources":"Get Started","learn":"Learn","user-groups":"Groups","external-link-1":"Dev Tools","user-groups-1":"Programs","external-link-2":"Integrations","user-groups-2":"Ask Me Anything","Common-discuss-link":"Discussions","connect-1":"Resources","whats-new-link":"What's new","Common-developers-link":"Developers"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1747314610093","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1747314610093","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1747314610093","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1747314610093","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1747314610093","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1747314610093","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1747314610093","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1747314610093","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1747314610093","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1747314610093","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1747314610093","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1747314610093","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1747314610093","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1747314610093","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1747314610093","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1747314610093","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1747314610093","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1747314610093","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1747314610093","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1747314610093","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListMenu-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListMenu-1747314610093","value":{"postTimeAsc":"Oldest","postTimeDesc":"Newest","kudosSumWeightAsc":"Least Liked","kudosSumWeightDesc":"Most Liked","sortTitle":"Sort By","sortedBy.item":" { itemName, select, postTimeAsc {Oldest} postTimeDesc {Newest} kudosSumWeightAsc {Least Liked} kudosSumWeightDesc {Most Liked} other {}}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1747314610093","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1747314610093","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1747314610093":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1747314610093","value":{"loadMore":"Show More"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"1password","messageSubject":"need-help-exporting-passwords-to-csv-for-excel","messageId":"80792"},"buildId":"-gVUpXaWnPcjlrLJZ92B7","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"onepassword","openTelemetryServiceVersion":"25.3.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/ThreadedReplyList/ThreadedReplyList.tsx","./components/nodes/NodeActionButtonWidget/NodeActionButtonWidget.tsx","./components/messages/MessageListForNodeByRecentActivityWidget/MessageListForNodeByRecentActivityWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","../shared/client/components/common/List/ListGroup/ListGroup.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","../shared/client/components/common/Pager/PagerLoadMore/PagerLoadMore.tsx","./components/customComponent/CustomComponentContent/TemplateContent.tsx"],"appGip":true,"scriptLoader":[]}
