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

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

On 26/02/2022 05:02, Steve Edmonds wrote:
> 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 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
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy