The specific reason I export the 'logins' is to compare them to the logins stored by Google Password Manager. Below are my notes and suggestions related to the 1Password export process (File - Export - All items) and working with the resulting CSV file in Microsoft Excel for Mac (I do not use Numbers for data manipulation).
I realize that 1Password exports 'data' while I talk about 'logins'.
It would be useful to have an option to export only logins as I may not want to import my credit card data and secure notes, etc. to e.g. Google Password Manager.
When setting up the export parameters for CSV, the 'common fields' selection offers the following fields in this order:
notes, password, title, type, url, username.
For me this order is useless and commands that I spend time rearranging them to a plausible order like: title, username, URL, etc...
It is very nice though, that the order can be arranged before export.
I suggest to change the default order of fields to follow the structure of the 'login' items.
No header row.
When exporting logins via File - Export - All items, the default resulting CSV file will not have a header row.
The 'Include Column Labels' has a mixed-up wording for me: 1Password does have labels but does not have columns, it visually has rows. When opening in a spreadsheet app, there are columns, but columns have headers and not labels.
A different wording would be more transparent, and I suggest to have this selected by default.
Header rows are particularly useful if one is planning to import them into another app, and the subtitle of the related help note ('You can export your 1Password data if you want to move it to a different app.' (https://support.1password.com/export/) would be honoured.
I suggest to insert a header row.
The resulting CSV file has a curious structure.
It seems to group logins and is definitely not in alphabetical order.
The grouping (if it is) must have a logic I am unable to grasp.
I suggest an export that is not grouped but is in alphabetical order of login titles, just as in the app itself. Any other order or grouping is distracting.
3a. The CSV file once imported in Microsoft Excel (and Numbers) starts with a cell containing 'üéâ Welcome to 1Password!', with curious characters in the beginning. Why is that? I think it comes from the welcome note provided by 1Password.
3b. If a Note text contains comma (,), and they tend to do, it will be handled by Excel as a separator. This destroys the CSV document structure. So I had to first import it in Numbers, and export from Numbers for Excel to go around this problem with Excel.
1Password Version: 1Password 7
Extension Version: Version 7.8.1 (70801004)
OS Version: 10.15.7
Sync Type: Not Provided