Ask Your Question
0

How do I import numbers from a text document to a cell or cell area in Libre Calc? [closed]

asked 2013-11-13 02:59:10 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi all, I have a lot of text documents to copy into Libre Calc sheets. I can't do regular file import because there is other stuff in the sheet as well. I would like to have either each cell call numbers from the text document, or import the file into a certain cell range/area of the sheet. Is there a function for this? If not, a way to write a script that would do this? The text files are all organised into columns by being tab or space delimited.

Thank you very much!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 14:54:39.634492

1 Answer

Sort by » oldest newest most voted
0

answered 2013-11-13 09:00:45 +0200

JohnSUN gravatar image

Select data in text document and copy it to clipboard.

Switch to workbook and select top-left cell of range to paste.

Use Paste Special - DDE Link

DDELinkToData

edit flag offensive delete link more

Comments

hi JohnSUN, thank you a lot for the answer. i was looking for a solution that didn't involve using copy/paste because this is very time consuming when there are a lot of sheets! do you know of anything more automated or command-like that lets you grab files? any idea if i can use a macro or something for this? thank you!!

binarygirl gravatar imagebinarygirl ( 2013-11-15 07:17:13 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-11-13 02:59:10 +0200

Seen: 107 times

Last updated: Nov 13 '13