Yes, the export from Connections does meet the CSV Import file requirements ;)
This is my “stock” answer for the nothing imported question. The solution is nearly always the one presented in the FAQ that I linked to in my previous reply.
If you had not followed the instructions in the FAQ, then it was definitely the beta CSV Import that worked. The reason being I added logic to the import to account for that common error :D
Any great to hear that this is sorted!