I want to merge 496 excel sheets into one sheet using LibreOffice Calc

HI all,

I have around 495 excel data sheets, each having 3 columns and 101 rows. The first column values are same for all the sheets. The Title for column No 2 and 3 are same however their values are different. Now I wish to append column no 2 and 3 from all these excel sheets into one master sheet. Can somebody please help me in doing this.

Merge sheets of spreadsheet documents
Merge sheets of one spreadsheet document

1 Like