How to import multiple text files into excel

How to put lots of text files into a single excel spreadsheet all in one go.

Sometimes you have data in lots of separate text files and you want to be able to put that data together in an excel document without having to copy and paste each text file individually. You can do this using Power Query. This is a really useful feature in Excel 2016 which lets you organize large amounts of data. This only works if all your text files have the same columns. This works with .txt and .csv files.

---------------------------------------------------------------------------------
#exceltutorial #powerquery #exceltipsandtricks

VIDEO INFO: These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:

[mstee]

Beautifully orchestrated, this is what data analyst do make data user friendly for analysis !

[robthue]

Excellent video! Clear! Concise! Perfect instruction! Very helpful! Thank you so much!

[coltenneath]

Oh my goodness this literally saved me HOURS! Thank you, thank you, thank

[Rennautobrumm]

Awesome! Just told my colleague: I thought this would take all afternoon, now its done in 5 minutes! - the reply - thats what she said. :) anyway, thanks a lot!

[jaejinkim]

Thank you for teaching the easy way to combine TEXT files.

[MatheusCorreiaGomes]

Excellent, saved me A LOT of time. Thank you very much!

[mofoho]

Genius! Massive time saver - thank you!

[davidtaglieri]

Thank you! Just made my thesis research analysis much much easier.

[stephenstephen]

Just what I needed. Thank you so much.

[hakmatullahtookhi]

Thank you so much for sharing the valuable teachings & information

[lorenzohuamanchay]

Magnífica presentación Karina. Gracias.

[lanternofthegreen]

Thanks a lot. You saved me from days of work.

[hannahterry]

Thank you very much Karina! This saved me from having to do a ridiculous amount of copying and pasting LOL!

[farisal-amer]

This is an excellent video and well explained. Thank you very much.

[Craqerzrus]

U just saved me 5 hours thank you so much

[lozfitz]

Thank you, sounds like you were on the verge of tears!

[aikendrum]

Thanks !!! needed this in a hurry !! In Office 365 Excel 2019 it's the 'GetData' option under the 'Data' menu :)

[ayhobbyist]

you literary saved me with this video 👍

[unchurched]

Nicely done. A perfect solution for my task.

[thabokgotsa]

hi there... thanks a lot for this.. how do I get the query to only pull through data after a certain line and before another in the text file