Ask Your Question

Merge multiple spreadsheets files into one

asked 2018-01-01 15:42:50 +0200 gravatar image

updated 2018-01-04 01:40:10 +0200

I have a number of separate ODS files all formatted exactly the same (columns and rows) that I want to merge into a single master spreadsheet.

edit retag flag offensive close merge delete


Similar question asked here

Is copy/paste an option, or is the number of files too large?

robleyd gravatar imagerobleyd ( 2018-01-04 02:23:33 +0200 )edit

How are the "multiple ... files" identified as a group? (A folder? Systematic names? ...)
How many files? How many sheets per file?
Shall the merging be done onece and for all?
Shall independent files remain, and the master link them in?
How shall the sheets from different source files be distinguished in the "master file"?
Are they differently named from the beginning?
Do you want an automatic procedure?
You will need to consider a few things yourself.

Lupp gravatar imageLupp ( 2018-01-04 11:27:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-01-04 15:47:21 +0200

Lupp gravatar image

updated 2018-01-04 15:55:27 +0200

Having only 12 files, automation wouldn't pay.
-1- Create a new Calc document based on the same template as "the 12" are. Keep it open.
-2- Open the 'January' document.
-3- Open the context menu of it sheet tab and select 'Move/Copy'.
-4- Select the newly created document as the target and the end position there. Accept 'Copy'.
-5- Goto -2- adapting the month till 'December' is copied.
-6- Delete the still empty sheet(s) originally created with the new document.
-7- Save and close the new document.

Spreadsheet documents spliting date on a "per week" or "per month" basis often cause problems concerning evaluations. You may consider to keep just one sequence of data rows in one sheet, and to do any selecting and additional evaluation including prints in/from different sheets.

edit flag offensive delete link more


Thank you! gravatar ( 2018-01-08 19:56:00 +0200 )edit

answered 2018-01-04 15:16:40 +0200 gravatar image

The multiple ODS files are identified in a single folder. There are 12 files (one for each month) each containing a single sheet. Merging should be a one time thing. Individual files do not have to remain after a merge takes place. Each file in the folder is named differently (month of year). I can certainly copy and paste but was looking for a quicker way if available.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-01 15:42:50 +0200

Seen: 4,081 times

Last updated: Jan 04 '18