[libreoffice-users] opening a csv file in a calc sheet

2022-02-25 Thread Philip Jackson
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

Re: [libreoffice-users] opening a csv file in a calc sheet

2022-02-25 Thread Steve Edmonds
Hi Philip. In the menu 'Sheet' there is an insert sheet from file. This will insert the CSV as a new sheet. Steve On 26/02/2022 11:31, Philip Jackson wrote: 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

Re: [libreoffice-users] opening a csv file in a calc sheet

2022-02-25 Thread Steve Edmonds
And you can also right click in the sheet list at the bottom and insert a sheet from file. Steve On 26/02/2022 11:31, Philip Jackson wrote: 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