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

Copper 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.

 

a,b,c

1,2,3

 

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...