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

[cellurl]

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

[#2 · Accepted solution]

i found it.

1. just paste it all jammed into 1 column

2. Hit control-A to highlight everything.

3. Hit Data->Text-to-Columns.  That brings up the import wizard! Yipee

Boom!

[#3]

https://trumpexcel.com/excel-text-to-columns-examples/

[#4]

You may skip one step. After pasting into the sheet you may see small icon like here

Press Ctrl, Arrow Down, Enter or expand by mouse to start the wizard

[#5]

thanks this saved me hours of work

@cellurl 

[#6]

I don't know if this can be reversed? for example, I have three columns in excel. Last name, first name (with a comma) and then place next to third column. I am taking a list of graduates with their degrees and placing them into powerpoint program. I hope that this makes sense and that I replied to a thread that I thought was related 

---

@cellurl wrote:

i found it.

1. just paste it all jammed into 1 column

2. Hit control-A to highlight everything.

3. Hit Data->Text-to-Columns.  That brings up the import wizard! Yipee

Boom!

---

 @cellurl 

[#7]

Hi @AliceDean ,

That is separate question, better to start new conversation for such.

To merge columns the easiest is with Power Query, but if only within the sheet please check https://www.ablebits.com/office-addins-blog/2013/10/13/merge-columns-excel-without-losing-data/

[#8]

Wow, that was a quick response and thank you. This is my first question and it was exactly what I needed. thank you. @Sergei Baklan