Date created / modified in csv

Ask the Community Password Manager
1

Hi
Is the above in the csv export of a vault? I can’t see it so guess not. Can anyone tell me how to get it to show up, or detailed steps to get it another way.
It is imperative I am able to sort my vault by those criteria to make it fit my work flow. I am not ‘tech savvy’ so if there is another way and you have the time, could you please provide detailed, ‘little steps’ instructions!
Many thanks and here’s hoping…

2

Unfortunately, I don’t think it is possible to obtain that level of detail when you export your vault, regardless of the format,

3

If you really require it and willing to spend time on it , i can tell you about a DIY way but it requires much patience and some excel skills.
The entry revision date(i.e also the creation/import date) and password revision date does appear in the local cached version of your Bitwarden vault. They are also in plaintext , so you can copy those with help of vlookup Fn in your unencrypted csv ,the common point of match being the “id” field.

The brief steps would be as follows

  • Copy the database file data.json from the cached storage directory ( in case of windows its C:\Users\user\AppData\Roaming\Bitwarden/data.json to a secure location.

  • Import the data.json file into excel (from the data tab Data>get data>from file>from json)
    This step is the most difficult as you need to define correct columns/value for json.
    I wouldn’t recommend using any online json-excel convertor as your data is sensitive and they usualy store your data.

  • After successfully importing data into excel you could simply use Vlookup function to copy data from that sheet, the lookup value being the “id” , and the column no. being same as Entry revision date/password revision date.

I haven’t tried it personally but you could try if you feel like its worth your time and effort.

Disclaimer : Work only a copy of the data.json file in another directory to avoid any corruption.

4

Many thanks Gaurav, but why is this not available in csv export of all data. Not your problem I know, just venting continued frustration of not being able to access data already in the database. This must be a common request surely???
Cheers….

5

Hi
Any idea where it is on a Mac? Looked but can’t find it anywhere!
Cheers…

6

Hi @tonyt - my guess is that this is it:

/Users/<username>/Library/Application Support/Bitwarden/data.json

7

Oh! Excel! Not using Numbers on a Mac then. I am stuck!
Cheers…

8

Sorry David, should have said thanks for location.

1 Like