Ask Your Question

combine multiple calc files

asked 2019-03-13 23:51:30 +0200

TSUM gravatar image

I have about 20 cvs files of the same format I want to combine into one sequential file. Is there a smart way to do this.

thanks Tim

edit retag flag offensive close merge delete


It might depend on where your CSV files originated and whether you want them to form a continuous record or not. Most of my CSV files come from an automated electronic data monitor with a complete set of headers on each one. To make a contnuous, sequential record of them, I edit each one in a text editor and then combine them in order. Then I open the combined text file with LO Calc and do my calculations, statistics, plot graphs, etc., saving it all as .ods file.

You can also copy and paste CSV files that have been opened by Calc into another Calc file to combine them. Giving due regard to formats of date/time, this can work quite well.

Your situation might require something else.

ve3oat gravatar imageve3oat ( 2019-03-14 00:34:15 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-03-14 00:38:25 +0200

Lupp gravatar image

This depends...
...on what you accept as "smart", and this in turn will depend
...on the question if you have to do it once and for all or again and again.

You can open each csv-file as a new sheet and then copy/paste the contents into one sheet sequentially.
You can automate the process based on user code.
You can write a little program in any programming language to read the csv-files line by line and to write the lines as one sequence into an intermediary file which you later can import into a spreadsheet.
You can ...

You can not write more than 1 048 576 rows into one spreadsheet.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-13 23:51:30 +0200

Seen: 65 times

Last updated: Mar 14