I've just tried opening csv in LibreOffice and it asked me for it too. However sane options were already selected so it was just one additional click.