Ask Your Question

I want to import a text file to Calc in the form of a table [closed]

asked 2014-06-06 02:19:08 +0100

FsantoX gravatar image

Hi there I need to import a text file that is written as a single giant column with 100 or more lines

But I need to import in a way that it becomes a 10x10 table

I wanted to try something like "every 10 lines, skip to the noext column"

Is there anything such as that?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-24 21:04:03.849189

1 Answer

Sort by » oldest newest most voted

answered 2014-06-06 04:32:00 +0100

ROSt52 gravatar image

All depends on the details formatting of the text file.

I would try to do:

Make a backup file!

Right click on the text file Select Open with > Calc Look at the possible settings. In this window one sees already how the file spreadsheet will look like.

Worst case: Get all in 1 column and move in units of 10 lines into the next column. Time needed: 10 x 20 sec

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-06-06 02:19:08 +0100

Seen: 72 times

Last updated: Jun 06 '14