I'm getting an error exporting my Dropbox Passwords CSV file into Apple Keychain

I tried it, and I think it worked, my Passwords are in Keychain now. Thank you very much for explaining it

Hi Angelsoto! 

I tried the exact same thing but still received an error message. Additionally, the export from Passwords still can’t handle special characters (as mentioned here in one of the replies) which creates import problems into Keychain as well. 

so it’s a nice solution, but Dropbox still needs to iron out this thing so users can export to Keychain without issues. 

Hi everyone,

I was fiddling with this after seeing your post, trying to figure it out. It turns out very "simple".

Just open the .csv file with TextEdit you just exported from Dropbox Passwords and change the column titles (the first ones you will see, don't bother scrolling to your password data) and make them match the Apple Keychain .csv format (I just exported one .csv and checked).

Once the columns of the .csv match, the import works (I still have to check if there where any errors in any of the keys), but seems to be fine.

Apple Keychain columns are:
Title,URL,Username,Password,Notes,OTPAuth

I hope this works for you guys as well!

Thank you for posting this.
I am facing the same problem importing into Apple passwords and I echo this request, I found this via google search. Please let us know what to do.

Also the exported csv loses all non-ascii characters which causes a problem for exporting the info stored on dropbox passwords in other languages 

Mattsson​ that's a fair request, and thanks for bringing this feedback to our attention. I'll share this thread with the relevant teams so this can be explored.

Hey! 

I have read it but it tackles a now non-existent problem as the dividers are commas and not semi-colons. 

Jay - a simple button as has been made for 1password would be the best solution. I doubt your partner will object to you guys adhering to the needs/requests of your users. 

Jay – Since many users (myself included) will be switching to Apple Keychain due to your company’s decision to discontinue the service, I’d really appreciate a clear, detailed response to this issue that’s going to affect every user.

@ DF-Dropbox: I found this thread via Google, but unfortunately, the suggestions are too superficial to help. I’ll admit I’m not very familiar with Excel or Numbers, so the explanations go over my head. A step-by-step guide or a more beginner-friendly approach would be much appreciated

Hi Jay! 

well, I would consider this to be a Dropbox issue as other password-imports to Keychain doesn’t seem to have this issue. Also, to apply the google-mindset to this, if your users have an issue which contains your service (regardless if it’s a service you’ve decided to discontinue), it’s YOUR issue.

so let’s try on both our ends to find the solution to this topic rather than pushing in onto the users to fix for you, shall we? ☺️  

To add to Jay's response about checking with Apple Support, have you checked out this thread?

https://discussions.apple.com/thread/255759674?sortBy=rank

Hi Mattsson, thanks for bringing this to our attention.

After some brief research, I can see that there are similar errors from other password providers when trying to import CSV files into Keychain.

As this error message appears to be related to Apple Keychain, and isn't related to Dropbox, I'd recommend checking with Apple Support for the correct format used to import a CSV file from another password provider.

In the meantime, if you have any further queries, feel free to message back.