Ask Your Question

How can I merge a csv file into a Calc file? [closed]

asked 2014-06-14 03:12:18 +0200

mpkettle gravatar image

updated 2014-06-14 15:06:39 +0200

bencomp gravatar image

I have exported a CSV file from file maker pro. How can I merge this file into a calc data file in LibreOffice?

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-25 10:29:51.296755

3 Answers

Sort by » oldest newest most voted

answered 2014-06-14 07:00:10 +0200

ROSt52 gravatar image

Right click on the file
select: Open with
select: Calc
an import windows pops up
make the right selection (you see the results immediately in the preview window)
click OK and you have it in Calc When saving make sure you save to ods format because it might save automatically to csv.


open Calc
File > Open > make sure File Type is set to "All Files" or select according to your needs
Rest is same as above.

Once you are in Calc, you can move many original csv-files into one Calc file. Each csv-file becomes one worksheet in Calc.

edit flag offensive delete link more


Thanks for your help

mpkettle gravatar imagempkettle ( 2014-07-02 05:40:22 +0200 )edit

This is not a very useful answer. It essentially says open the csv file in another instantiation of calc, or another sheet, and copy the contents to where you want them. Maybe there is no way to do this automatically?

pbfoobar gravatar imagepbfoobar ( 2015-06-17 22:19:17 +0200 )edit

answered 2014-06-14 04:52:05 +0200

mpkettle gravatar image

See my previous question "merging two separate csv files"

edit flag offensive delete link more

answered 2014-06-14 11:11:15 +0200

Lupp gravatar image

Might 'Insert Sheet' > 'From file' > (BROWSE csv-file) > (set import specifics)

meet your needs?

edit flag offensive delete link more


Thanks for that

mpkettle gravatar imagempkettle ( 2014-07-02 05:39:38 +0200 )edit

Question Tools

1 follower


Asked: 2014-06-14 03:12:18 +0200

Seen: 1,112 times

Last updated: Jun 14 '14