Ask Your Question

How to insert contents of TXT / CSV file directly into current sheet of Calc?

asked 2019-01-31 14:03:33 +0200

ModDM gravatar image

updated 2019-01-31 14:36:34 +0200

In Excel you can insert data in several types (CSV / TXT) directly into the current sheet, to be more precisely, to the current selected cell, and the data will be added in the cells. No extra steps needed, like opening a separate document and copy the data from there.

In LibreOffice I seriously studied how to get this done, but it seems the data will not be added to the currently open sheet. Insert Sheet unfortunately has nothing to do with 'insert', as you read it as 'insert into current sheet'. But it just opens a new sheet!

How do I really add text data (from a txt file / csv file) to the current spreadsheet? The direct way? Without opening the TXT / CSV file in another window, select from begin to end, copy to clipboard, go to target document, select position, paste data.

Those are much to much steps compared to Excel, in which it´s 1 click that does this all (insert from TXT file / insert from CSV file).

NOTE: In Excel the added data from a file, is placed in the cells of the current sheet. Inserting an OLE object in Libreoffice is not the same function: It does not add data into the cells of the sheet, but it adds it as a separate object, which behaves as separate data. So, you can not (easily) calculate that data together with the data of the rest of the sheet.

edit retag flag offensive close merge delete



"Insert Sheet" - well, it inserts a sheet. I wonder how that could be read as "insert into current sheet"?

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-31 14:41:48 +0200 )edit

not because of the word 'sheet', but because of the word 'insert'. Right? 'insert' (definition) includes the word 'into'. If it´s not told into what it´s up to the user, that´s how it can be read as 'insert into current sheet' or 'insert into the current row / column / cell'. But I understand you Mike.

ModDM gravatar imageModDM ( 2019-01-31 15:02:13 +0200 )edit

sorry, I was not complete, I meant 'insert sheet from file'. (not just insert sheet).

ModDM gravatar imageModDM ( 2019-01-31 15:10:02 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-01-31 14:54:41 +0200

There is no such built-in function in LO. You are welcome to file an enhancement request. Or even better - to step in and implement that :-)

edit flag offensive delete link more


Ok, great. This will be an enhancement. I will request it. Thank you.

ModDM gravatar imageModDM ( 2019-01-31 15:03:17 +0200 )edit

answered 2019-01-31 15:33:23 +0200

ModDM gravatar image

I filed the enhancement request: Bugzilla link

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-31 14:03:33 +0200

Seen: 1,013 times

Last updated: Jan 31 '19