05 - Import Data from TEXT Files in Excel using Power Query
Вставка
- Опубліковано 25 сер 2024
- 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
Excellent presentation. Organized, to the point, well-explained. 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!
Sumit, thank you so much for your clear explanation and walk through, you are a great teacher!
Thanks a lot ...bro ..it is very helpful I have watched untill 4 videos ..great learning .. will watch all videos...
Love it, clear and concise. Well done
Up to Now Amazing .....Many Thanks :)
Good Job 😊Excellent Video Thanks Again 😊
Thanks so much.
great job Sumit, well done
Thanks a Bunch man...
nicely done!
thanks a ton!!
Superb
Great work dear
Thank you sir
Thanks
Thank u
Great
great
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 ??
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!
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?
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?
And what if I want to see June in excel again?
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?
How do do this on mac?
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?
respected sir you need to go through your concepts again as you can not do changes in text file the change option is only available on CVC file
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
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
Hi
Why there is no option of Microsoft word in power query ? Word also contains data in the form of text and tables.
Hi Sir, when I trying to use this file, the month become day, is there any way to fix this?
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.
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?
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..
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?
My date data type is throwing an error while I make it as Date