Ask Your Question

Is it possible to make a cell refer to a TXT file?

asked 2019-07-11 21:39:32 +0200

Village gravatar image

Is it possible to make a cell's value linked to the data in a TXT file, e.g.:

A1= line 1 of file1.txt A2= line 2 of file1.txt A3= line 3 of file1.txt

If the value in the TXT file changes, then the Calc document is opened, then the cell value would change.

Is this possible?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-11 22:10:29 +0200

m.a.riosv gravatar image

Open the TXT file from calc, on the import dialog disable all separators, a new spreadsheet should open with a line by row.
Copy the first cell of this file in the destination file, using past special [Shift+Ctrl+V], mark link and Ok. A link to the first cell in the TXT should be there, now you can close the TXT file and copy and past or drag the formula down.
This can be done with a large range of TXT file, a matrix link with the range it's pasted. Play a bit to find your way.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-11 21:39:32 +0200

Seen: 215 times

Last updated: Jul 11 '19