opening a csv file in a calc sheet

users
#1

I sometimes have to work on data which arrives to me in csv text files. I would like to have each csv file's data in a separate sheet within a single calc file. No matter how I try to open the csv files, each one opens in a fresh calc spreadsheet and I have to manually copy / paste the data into a new sheet in my main calc spreadsheet.

Is there a way to open a csv file and have the data imported directly inside a new sheet of an existing calc file ?

Philip

#2

Hi Philip.
In the menu 'Sheet' there is an insert sheet from file. This will insert the CSV as a new sheet.
Steve

#3

And you can also right click in the sheet list at the bottom and insert a sheet from file.
Steve

#4

Thank you everybody. It is the 'insert sheet from file' that does the job for me.

I couldn't find it in the help docs because I wrongly focused on looking for info on 'import file into sheet' rather than 'insert sheet from file'.

Just shows the need for more lateral thinking. Thanks again.

Philip