You are now following this question
 You will see updates in your followed content feed.
 You may receive emails, depending on your communication preferences.
Combine excel files into one
1 Comment
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2421008

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2421008
Accepted Answer
67 Comments
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2421888

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2421888
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2424853

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2424853
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2424983

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2424983
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2428598

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2428598
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2429173

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2429173
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2429628

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2429628
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2430448

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2430448
 which folders you want ( first and last folders number are used in the name of the output excel file, so you don't have to rename manually each time)
 which columns of data you want (we could also put first / last columns values in the output excel file name if that is interesting for you)
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2430733

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2430733
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2430773

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2430773
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2447258

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2447258
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2447333

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2447333
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2447723

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2447723
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2449893

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2449893
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451293

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451293
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451443

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451443
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451478

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451478
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451493

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451493
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451503

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451503
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451643

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451643
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451688

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451688
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451723

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451723
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451728

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451728
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451748

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451748
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451853

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451853
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451878

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451878
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451988

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2451988
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2452038

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2452038
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2452273

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2452273
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2453028

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2453028
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2453233

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2453233
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2453353

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2453353
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2454513

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2454513
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2455218

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2455218
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639045

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639045
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639555

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639555
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639605

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639605
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639655

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639655
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639670

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639670
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639685

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639685
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639695

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639695
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639800

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639800
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639920

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2639920
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2640670

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2640670
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2643485

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2643485
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2643505

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2643505
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2643545

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_2643545
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3130606

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3130606
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3131831

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3131831
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133311

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133311
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133461

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133461
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133501

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133501
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133551

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133551
 readcell function with csv2cellfast
 writecell function with cell2csv
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133641

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3133641
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134206

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134206
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134276

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134276
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134311

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134311
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134351

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134351
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134411

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134411
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134426

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134426
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134466

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134466
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134626

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134626
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134651

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134651
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134666

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134666
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134696

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134696
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134731

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134731
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134776

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134776
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134781

Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553combineexcelfilesintoone#comment_3134781
More Answers (0)
See Also
Categories
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
 América Latina (Español)
 Canada (English)
 United States (English)
Europe
 Belgium (English)
 Denmark (English)
 Deutschland (Deutsch)
 España (Español)
 Finland (English)
 France (Français)
 Ireland (English)
 Italia (Italiano)
 Luxembourg (English)
 Netherlands (English)
 Norway (English)
 Österreich (Deutsch)
 Portugal (English)
 Sweden (English)
 Switzerland
 United Kingdom (English)
Asia Pacific
 Australia (English)
 India (English)
 New Zealand (English)
 中国
 日本Japanese (日本語)
 한국Korean (한국어)