During paste csv, how to launch import wizard so the commas are recognized and columns formed.

New Contributor

I dont want to create an intermediate file.

I just want to directly take csv from anywhere, perhaps notepad, perhaps notepad++

Then copy it.

Then in excel, paste it and not have it all jam into the first column.

Eg, during paste all I see is Paste-Special which doesn't bring up the import wizard.


 just want this in the clipboard to launch the import wizard.





Is there anyway on Gods Green Earth that I have uncovered something that CANT be done in Excel?

That belongs in Revelations perhaps!


Thanks for any leads!

Jim in Memphis


1 Reply
You could just paste and then click Data, Text to Columns...