How to merge excel files into one?

K

Kotovasofa2020-08-12 08:26:18

excel

Kotovasofa, 2020-08-12 08:26:18

Hello everyone, there are 100 Excel documents, with the same dimension. Is there any service or program that allows you to combine all these 100 documents into 1, place the table one under the other, and all this on one sheet?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

J

John Smith, 2020-08-12
@Kotovasofa

PLEX, kutools - Excel add-ons with a bunch of useful features. The first definitely includes, the second - most likely. There are others.
There is VBA.
There is PowerQuery.
All three methods with pictures are discussed here.
https://www.planetaexcel.ru/techniques/3/7453/
PS It is recommended to google before asking a question .
Questions on Excel are often typical, and there are a whole crowd of sites on which they are chewed up with all the details.

O

Oleg, 2020-08-12
@Oleg_F

Use power query (it's an Excel add-in). It easily allows you to take files of the same type from a folder and merge them.