opening new csv file in existing xls file's worksheet

[Shikha]

Hi All,
I want to open up a new csv file in an existing xls file's worksheet. Is
there any way to do this?
Regards,

 

[Joel]

You can put a worksheet in a new workbook by right clicking the tab on the
bottom of the worksheet (normally Sheet1) and select move or copy. On the
top pulldown ogf the Pop Up window select New Workbook and check the box to
make a copy. Next go to menu File - Save As and select the type of Workbook
as "CSV" and select the location and name of new workbook.

 

[Shikha]

Thanks Joel, but this did exact opposite of what I wanted. By following what
you have written, it copied existing worksheet into a new csv file. Instead
what I want is to open file2 (a csv file) in file1.xls. File1.xls already
contains a worksheet Sheet1. I want file1.xls to now have another worksheet
titled file2, which contains data of file2.csv file.
Any suggestions?

 

[Joel]

Crate new worksheet from menu

Insert Worksheet

Use the menu

Data - Import External Data - Import Data

 

[Shikha]

Thanks Joel. This worked.

Crate new worksheet from menu

Insert Worksheet

Use the menu

Data - Import External Data - Import Data