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!