the problem is because you trying open csv (result) by double click which is not a proper action
you should import csv with defined delimiter (tab)
with double click, Excel ignore tab as delimiter and you've all data in single column

as i said this is a comma separated values type of file and if you define delimiter in your vba comma instead of tab it will work with dbl click or just import

Alan did his job great with your requirement and you got csv with copied data, but what will you do with this csv (and problems with that) is on your side

regards