In Chrome, goto the URL chrome://password-manager/settings and click "download file" to export your passwords to a CSV file. Then, open the CSV file in a text editor to confirm your passwords are there.

Then, in Opera, goto the URL opera://password-manager/settings and click "select file" to import that CSV file.