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/1830553-combine-excel-files-into-one#comment_2421008
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2421008
Accepted Answer
67 Comments
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2421888
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2421888
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2424853
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2424853
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2424983
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2424983
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2428598
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2428598
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2429173
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2429173
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2429628
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2429628
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2430448
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#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/1830553-combine-excel-files-into-one#comment_2430733
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2430733
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2430773
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2430773
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2447258
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2447258
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2447333
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2447333
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2447723
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2447723
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2449893
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2449893
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451293
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451293
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451443
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451443
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451478
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451478
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451493
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451493
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451503
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451503
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451643
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451643
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451688
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451688
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451723
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451723
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451728
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451728
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451748
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451748
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451853
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451853
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451878
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451878
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451988
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2451988
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2452038
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2452038
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2452273
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2452273
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2453028
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2453028
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2453233
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2453233
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2453353
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2453353
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2454513
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2454513
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2455218
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2455218
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639045
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639045
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639555
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639555
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639605
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639605
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639655
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639655
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639670
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639670
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639685
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639685
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639695
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639695
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639800
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639800
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639920
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2639920
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2640670
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2640670
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2643485
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2643485
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2643505
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2643505
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2643545
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_2643545
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3130606
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3130606
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3131831
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3131831
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133311
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133311
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133461
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133461
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133501
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133501
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133551
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133551
- readcell function with csv2cellfast
- writecell function with cell2csv
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133641
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3133641
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134206
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134206
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134276
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134276
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134311
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134311
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134351
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134351
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134411
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134411
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134426
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134426
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134466
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134466
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134626
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134626
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134651
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134651
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134666
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134666
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134696
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134696
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134731
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134731
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134776
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134776
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#comment_3134781
-
Link
Direct link to this comment
https://www.mathworks.com/matlabcentral/answers/1830553-combine-excel-files-into-one#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 (한국어)