This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I have been pasting csv data into excel for many years. Now one of my computers doesn't have the option. I have enabled the legacy option that I understood is supposed to give me the "Text Import Wizard" back. But I still can't do Paste-->Text Import Wizard. I can't "Insert". I can't do Data-->Get from clipboard or anything like that. It looks like maybe I am now required to go make an intermediate file on the filesystem containing the csv data, and then some great new wizard will let me import that. Is that the only way? Is it no longer possible to paste csv data from the clipboard?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I don't know why they disappeared that function as a menu option.
However, you can add it as a button on the Quick Access Toolbar where, in my opinion, it is even more accessible.
What happens when you paste?
I'm with Andre, PowerQuery is the "new" way to import CSV files. It allows you to perform "data cleaning" to fix any data problems.
I can provide you with some articles and webinars to get you started in PQ if you are interested.
Hi
My name is André. I am an independent consultant.
>Initially the most practical way to import a CSV. is through
-Date
-Get and Transform Data
-From Text / CSV
And the second way, would be to copy all the contents of your csv normally.
and click on the clipboard option triangle (print1) and paste the content as you wish.
If these methods are not working. answer here, as excel is probably corrupted, and you will have to perform a repair.
André.