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

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

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?

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

Great work dear

Hi Sir, when I trying to use this file, the month become day, is there any way to fix this?

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!

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!

great

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

How do do this on mac?

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?

Thanks so much.

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

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

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?

My date data type is throwing an error while I make it as Date

Great

Love it, clear and concise. Well done

thanks a ton!!

Thanks a Bunch man...

great job Sumit, well done

nicely done!

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

Thanks

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..

Thank u

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 ??

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

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.

Thank you sir

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?

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?