05 - Import Data from TEXT Files in Excel using Power Query

No video

05 - Import Data from TEXT Files in Excel using Power Query

Рет қаралды 80,455

4 жыл бұрын

In this video, I will show you how to import the data from text files into Excel using Power Query.
You can also transform the data and correct some formatting before you import the data from the text file into Excel. And also, since we are using Power Query, in case your data in the text file changes, you can easily import the new data with a single click.
✅ Power Query Course Download files: bit.ly/power-q...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
Free Excel Course (Basic to Advanced) - trumpexcel.com...
Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #PowerQuery #ExcelTips

Пікірлер: 37

@Swizzletwice Ай бұрын

Excellent presentation. Organized, to the point, well-explained. Thank you.

@lildon112 Жыл бұрын

Thanks to this video, I have learned about the usefulness of power query. Had I not seen this, I probably would've taken two full days preparing and importing a giant text file into excel in order to do lookups. Thank you so much!

@aprendepe 2 жыл бұрын

Sumit, thank you so much for your clear explanation and walk through, you are a great teacher!

@user-vf8vv1hl5e 9 ай бұрын

Thanks a lot ...bro ..it is very helpful I have watched untill 4 videos ..great learning .. will watch all videos...

@Zixik_ 3 жыл бұрын

Love it, clear and concise. Well done

@jenniferqiu9420 2 ай бұрын

Good Job 😊Excellent Video Thanks Again 😊

@maythamalmouthen5191 Жыл бұрын

Up to Now Amazing .....Many Thanks :)

@alinaqvi6203 3 жыл бұрын

great job Sumit, well done

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@kamleshchandel6952 11 ай бұрын

Great work dear

@pemba.sherpa5675 4 жыл бұрын

nicely done!

@robbysandhu4425 3 жыл бұрын

Thanks a Bunch man...

@nick999666able 3 жыл бұрын

thanks a ton!!

@kamalgupta5831 4 жыл бұрын

Thank you sir

@nazarkamal8831 8 ай бұрын

Superb

@valariewalls4474 Жыл бұрын

You saved me!! Thank you for walking me through how to import and utilizing the "text import wizard." I received a new laptop, newer Excel and I am not ready to work with Power Query. Thank you!

@gowthammaditati64 4 жыл бұрын

The only excel channel that I had subscribed is this one only ....such a simple and superb explanation ♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️.....if any doubts how can we reach you sir ??

@FRANKWHITE1996 4 жыл бұрын

Thanks

@karthikrajgopal8627 4 жыл бұрын

Thank u

@naijatalkertive 3 жыл бұрын

Great

@ExceluniForAll Жыл бұрын

great

@eyoo22 2 жыл бұрын

Hello sir, thank you very much for your valuable videos. They are the best ever in learning power query. I just have one question, how to extract data in different languages, not English, into a power query?

@otroleonarbe 6 ай бұрын

Good explanation, thanks. However, what happens if I wanted to add the July CSV file to the current data instead of replacing it? Can I append one file to the next? Or should it be on a separate sheet when copying from the first one that you created for June?

@user-hs6ec2nu5k 10 ай бұрын

Thanks Sumit. One question, your text data was in a formatted shape however, i have a data which is not structured in text file and while loading from text file, power query is ready it as only one column. Can you pls help how can i format this file in power query?

@nevado. 4 жыл бұрын

Hi dear trump So many thanks for your clear explanation. I've just one query when you changed the source from Jun to July, The query editor name remains Sales Data June which confused me. I believe we also need to change the name as well. Am I right?

@vsddkkjjhgrreertyfdserrftyh 4 жыл бұрын

If my data is in random text format and I want to fetch data from it and arrange in table then what should I need to learn

@kamalgupta5831 4 жыл бұрын

Sir if when you changed the source data of june with july then the original data of june got replaced with july. But if we want to have both june & july month data then how can we import the July data on the same formating & alterations as we did for june data.

@shahid007inc 2 жыл бұрын

Hi.. How can i extract specific data from text file to excel as my my data fill sheet.. I am network engineer and copying running configuration of devices which is in text file and from that file i need to rearrange data into rows and coloum

@shanthasampath6429 11 ай бұрын

And what if I want to see June in excel again?

@nevado. 4 жыл бұрын

Hi, dear Sumit again and thanks for your outstanding explanation. The date wasn't changed to a date format in the query editor automatically. It is still in the text format. I changed it manually into date format but I got an error starting from line 127 in the query editor. When I click Save & Close, it shows the date format is correct up to row 127 in the excel document but in row 128 it was blank. In the text file, it wasn't blank. There is a date. Any idea?

@Entertainmenthuba 4 жыл бұрын

Hi Why there is no option of Microsoft word in power query ? Word also contains data in the form of text and tables.

@ariah5093 Жыл бұрын

How do do this on mac?

@akashdeshmukh116 4 жыл бұрын

Hi Sir, @trumpexcel If I change the date type in Query editor instead of following the text date type then I'm getting error after 127th row.. same happen in CSV file also.. Please help..

@ram-it.damn-it 3 жыл бұрын

I have a text file with 1st 11 rows which I need to delete. Also, the 12th row needs to be put in as header and then 13 deleted again. And, 12th row repeats as header row in every page of my text file which I would like to delete in excel. Is there a detailed video to deal with text files for that matter?