No video :(

How to import multiple text files into excel

Подписаться 45 тыс.

Просмотров 176 тыс.

50% 1

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: 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 ...
- How to combine tables with different columns in excel? • How to combine tables ...
- How to rename multiple files in Windows • How to rename multiple...

Опубликовано:

28 фев 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 66

@karinaadcock 6 лет назад

Query is only included in Excel 2016. In Excel 2010 and Excel 2013 it is an add-in called power query. Watch this other video for more information. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VeS0fh8xUVA.html

@Mileisha_Lyann 2 года назад

How can I separate each of those text files ( or .asc) to a separate column? In my case they all have the same X axis values but different Y values . HELP please . I have 120 files, cannot do them one by one!

@mstee5346 2 года назад

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

@robthue7233 4 года назад

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

@coltenneath2404 4 года назад

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

@Rennautobrumm 5 лет назад

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!

@jaejinkim5773 5 лет назад

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

@MatheusCorreiaGomes 5 лет назад

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

@mofoho2004 5 лет назад

Genius! Massive time saver - thank you!

@davidtaglieri5882 2 года назад

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

@stephenstephen3279 2 года назад

Just what I needed. Thank you so much.

@hakmatullahtookhi8313 4 года назад

Thank you so much for sharing the valuable teachings & information

@lorenzohuamanchay7390 6 лет назад

Magnífica presentación Karina. Gracias.

@lanternofthegreen 5 лет назад

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

@hannahterry1676 5 лет назад

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

@farisal-amer7635 Год назад

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

@alyismael91 5 лет назад

Absolutely beautiful!!

@Craqerzrus 7 лет назад

U just saved me 5 hours thank you so much

@technodex8678 Год назад

Well explained ty .

@TrektoTomorrow Год назад

Thank you! this was really helpful

@saathvik2005 4 года назад

This really helpful. Thanks.

@armadooo8294 Год назад

Thank you. This video is helpful.

@danielpais 3 года назад

Amazing! Thank you so much

@theDfLopes 5 лет назад

thanks, save me a lot of time.

@natalivalim2653 6 лет назад

Thank you very much!!!

@lozfitz 3 года назад

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

@cactushong4931 5 лет назад

Great video! Thanks :)

@laurynasstonys3235 2 года назад

thank you a ton!

@aikendrum7301 4 года назад

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

@hardiksur8423 3 года назад

Really Helpful Video

@ayhobbyist 2 года назад

you literary saved me with this video 👍

@brianklebig8803 2 года назад

You are my new hero.

@jeansalazar7812 5 лет назад

Thanks a lot!

@Seftehandle 3 года назад

phenomenal saved me hours

@divinorodriguesdasilva5048 8 месяцев назад

Fantastic!

@talharehman9458 Год назад

Thanks!

@unchurched 3 года назад

Nicely done. A perfect solution for my task.

@unchurched 3 года назад

And clearly explained, I meant to add.

@thabokgotsa3174 6 лет назад

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

@baverabhargav6136 6 лет назад

thank you :)

@dharyamalhotra2701 4 года назад

YOU HAVE AWESOME VOICE...

@akasshvijayaddittan7647 7 лет назад

Hi, I have done uploading the text file but the Excel pop up a new query editor tab whereas in the video it just shows a small dialogue box (0:52 sec). Can you pls help me on this

@preethikaralapati5774 7 лет назад

Hi, I have done uploading text files into Excel but unable convert all the files into excel. can you please help me on this

@logesh1987 5 лет назад

Hope, similar procedure for multiple .dat files

@charlottehyland523 4 года назад

Is it possible to only get one row from the documents imported?

@estyanike 5 лет назад

Thanks. But this still seem difficult. Someone should help, I need to convert 84 text files(Tab delimited) into excel sheets and still retain each file column spacing. This procedure takes alot of time converting manually to excel. Can someone help make this seem-less for me? Thanks

@noobsnuper8356 3 года назад

i found your video very informative but can you tell me how many text files can be imported into one excel sheet

@twshengting 4 года назад

does this work if your data is in rows and not columns?

@tonyxatnaa1017 4 года назад

content click, this is , how to solve ? DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line 1, position 1705.) Details: Binary

@cristhiantorres7084 5 лет назад

Hi Karina, your video help me to move to the next step, but I have an issue with the "Combine Files" step, when I start to combine my files, the query requires open an "sample" file it can be opened successfully but later I don't know how I can combine the rest of the files to make the load. I appreciate your comments

@karinaadcock 5 лет назад

When you have loaded the files and you have only the first file showing is there a vertical bar down the left hand side called Queries? Click on the arrow to expand that Queries bar and then you should see two queries. One is called sample query and contains only the first file. The second one is called other queries and should contain all your files combined together.

@Mileisha_Lyann 2 года назад

Does anyone know how to do this with a Macbook? The settings seem to be different, as the option of "Data from folder" does not appear. I have to import 120 text files one by one...

@psagar 5 лет назад

you fucking legend. This saved my life

@Mileisha_Lyann 2 года назад

@hikariz2931 3 года назад

How can I import the multiple line into only one cell?

@krishna20100 6 лет назад

Hi Dear doing a wonderful full by transferring your valuable knowledge to us i am requesting you i have querie for automation reports can please help me

@karinaadcock 6 лет назад

what do you want help with?

@Russeellee 4 года назад

How to import the txt files into columns? I have numerous files with two columns and tens of thousands of rows, all formatted similarly. I can edit the query and transpose so the "binary" cells are the top row, but I can't seem to find a way to expand all of the columns. Or is there another way to do it? Thanks,

@karinaadcock 4 года назад

could you rearrange the data using a pivot table?

@thabokgotsa3174 6 лет назад

i basically want to keep the data separated by the source tx file name in the worksheet and be able to delete some rows and keep others to work with...

@karinaadcock 6 лет назад

You could just use column filters to remove the rows you don't want. Or you could click on the small icon of a table to the left of the column headings and then select 'remove alternate rows' and then select the number of rows you want to remove and the number of rows you want to keep. Or I think you can go to 'view' and then 'advanced editor' and then change the code so the query only takes the rows you want from the text files but I don't know how to do this.

@rtlinsn5085 3 года назад

amazing accent

@Craqerzrus 7 лет назад

If I only knew how to not get it to be in numerical order it may save even more

@karinaadcock 7 лет назад

You could try renaming the text files so there is a number in front of the name of each file. You could try inserting a column and then numbering the rows in the order that you want them to be in. You could try creating a Custom List to sort the data. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3rOXxzfRyIg.html

@Craqerzrus 6 лет назад

Karina Adcock ty