I have exported to Excel, changed my regional settings so the list separator is pipe, then saved that excel as comma separated CSV and it worked - hope it helps someone