Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to copy and paste CSV formatted text into Excel 2007.

Is there a way of doing this without saving it to a temporary file first?

I'm sure in previous versions of Excel there was a way to trigger the CSV import wizard by hand in this situation, but I don't know how do this in Excel 2007.

For reference, in OpenOffice this Just Works - pasting in 2+ lines of CSV text will trigger the CSV import wizard.

share|improve this question
    
Do you have the CSV file? I don't have one handy to test, but if the file is accessible (including possibly over the network), you should just be able to open Excel, open that file, then Save As to the appropriate Excel format. – Thomas Owens Aug 4 '10 at 10:15
1  
@Thomas - thanks, but I was trying to avoid going via a file for convenience (since the CSV data is from an email). – therefromhere Aug 4 '10 at 10:43
up vote 124 down vote accepted

You need to insert your data into one column. Select this column, go to the Data menu and press the Text to Columns button.

share|improve this answer
1  
thanks. This saved me some some file hoop jumping. – Joshua Dance Nov 7 '13 at 19:11

Mark (a.k.a. select) the same number of columns expected to be imported from csv and import (paste). For example:

Name;surname
xxx;yyy

Mark columns A and B, then paste.

share|improve this answer

If you can produce tab-delimited data, you can paste directly into Excel.

If you cannot get them to send you tab-delimited (as opposed to comma-separated) e-mail, this still involves one intermediate step (e.g. paste into notepad, replace all commas with tabs, copy again) but at least you don't have to save into and import a temporary csv file.

share|improve this answer

I believe it is the same for Office 2007 (I'm using 2013) but if you paste your CSV text into a table then Excel will split it into columns for you:

  1. Insert > Table
  2. Click OK in the Create Table dialog
  3. Select the first data cell under the header in the new table
  4. Paste your data (e.g., Ctrl+V)
share|improve this answer

I'll say I'm 90% sure just changing the file extension to a .xls will resolve the data without any additional steps. What I mean is save a copy of the .csv to your desktop right click, rename, and change the file extension to .xls

I say I'm 90% sure because I'm away from my computer right now and can't verify.

There is a trick to displaying file extensions of known file types in windows 7.

Start/ control panel/ Appearance and Personalization/ Folder Options On the view tab select advanced setting scroll down and deselect Hide extensions for know file types.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.