Скачать или смотреть 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

SUBSCRIBE: https://goo.gl/c46YPs

VIDEO INFO: These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:
How to combine tables side by side in excel    • How to combine tables side by side in excel  
How to combine tables with different columns in excel?    • How to combine tables with different colum...  
How to rename multiple files in Windows    • How to rename multiple files in Windows