1password import from firefox csv: missing creation and last usage date

Hi raoulvb​, thanks for writing in!

So there are a couple of hurdles getting the created and last used dates from a Firefox export into 1Password, but it is doable. 

First, Firefox exports dates in Unix epoch time, so this information will need to be converted into something more readable. You can do this with a formula in a spreadsheet such as =(cell/86400000)+25569+(-5/24), or using something like the EPOCHTODATE function in Sheets (I believe EPOCHTODATE(cell,2) in this case). As your export likely contains unencrypted information, I would recommend using an offline method to convert the dates that is not backed up, and ensuring any copies are fully deleted after being imported into 1Password. You could also consider separating the dates from any sensitive information before converting them.

Here's an example:

Once you have those readable times available you can move to importing. The Firefox importer doesn't capture the date fields but you can use the CSV importer to do this manually. Using the CSV importer you can indicate which fields should or should not be included, as well as provide custom names for fields such as Last Used, or Time Created. Here's an example:

Just to note, time fields added to the items this way will be static, and won't update automatically as you use or update the item. 1Password will add dynamic Last edited information as you modify the item, and you can sort items by Recently Used. 

MrC's converter may be a good option for you as well while you're moving your information into 1Password. 

Let us know if you have any questions and thanks again!

I don't recall that 1Password will import these date values.

Date Created is something that could be imported, as 1Password has a standard field for this (createdAt).

Date Last Used is not one of the standard fields, and it is not a value not exported in a 1PUX file (nor imported from one).

You can use the mrc_converter_suite's csv importer to import these fields.  With the problem column label, Date Created will be automatically converted.  I could provide you with a custom conversion for Date Last Used, but it would be a static value not automatically updated by 1Password (so not very useful most likely).