130
24
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.
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 – 2010-08-04T10:15:28.353
1@Thomas - thanks, but I was trying to avoid going via a file for convenience (since the CSV data is from an email). – therefromhere – 2010-08-04T10:43:50.300