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+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
Privacy Policy: http://www.documentfoundation.org/privacy