Import Series - Import CSV TXT File into Excel

No video

Import Series - Import CSV TXT File into Excel

Рет қаралды 136,008

Күн бұрын

MY FULL EXCEL VBA COURSE [35% Discount]: www.teachexcel...
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
How to import CSV/TXT files into Excel - this includes how to get back to the Legacy import wizard feature that Excel used to use by default as well as how to use the new version of the import wizard.
This tutorial also covers the mechanics of Excel's import so that you understand how it works and the consequences of the links that are created when importing using the default settings - hint: it's not just a copy/paste kind of import by default.
Let me know your thoughts and I hope you enjoy the tutorial!
TeachExcel.com

Пікірлер: 88

@TeachExcel 2 жыл бұрын

MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_wZX_5oXd540 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

@conniekidd1 7 ай бұрын

thank you tech guy. I got excel 21 and I clicked on your video explaining the text import wizard. Everything was importing to a table format and I only wanted the data without the table. That 15 second review saved me from pulling my hair out. Thank you so much!!

@aderonkeobatuyi6319 2 жыл бұрын

God bless you.. I said God bless.. This video just relieved me. If you are stuck in importing csv to excel.. This is the right handle 👍👍

@junevendetti2850 11 ай бұрын

Thank you for refreshing my memory! I used to import txt files all the time, but, like anything else-what you don't use, use lose! I'm having fun relearning my favorite app

@alejandra1888 4 жыл бұрын

THANKS! I was getting soooooo mad with this new excel 2019...

@Hartley_Louise 4 жыл бұрын

Halleloo import wizard! This video saved me from throwing my work computer out the window, thank you.

@TeachExcel 4 жыл бұрын

You are very welcome! I'm glad it helped :D

@77sparkles77 3 жыл бұрын

I feel your pain! LOL

@alterchannel2501 2 жыл бұрын

God bless you forever! I've been searching online how to import txt files with the old import wizard method, for certain things it is much more convenient and fast than the power query

@valerienava8230 Жыл бұрын

Thank you, exactly what I needed to solve my homework. Adding the wizard was the solution. Thanks

@beewilldid4485 3 жыл бұрын

Bundle up all the good comments and apply them here. Thanks heaps. Exactly what I needed.

@sarahm.jordan1960 3 жыл бұрын

Thanks I'm getting a better understanding of how this works. Thanks ,will visit again.

@Kntygrl 2 жыл бұрын

Thank you so much!! It was taking me forever to figure out how to import the "old" way. Thanks again!!

@lucashelmer1252 4 жыл бұрын

Exceptional! I didn't figure out yet how it works on my Excel, but you are a lonely Ranger who explains things in a fantastic way!

@ppasri 3 жыл бұрын

thankyouu sooo much, it's such a big help, I was frustated becuase I can't process my data with excel 2019. But this totally saved me.

@TeachExcel 3 жыл бұрын

I'm very glad to hear it :))

@BrianThomas 4 жыл бұрын

What if you need to import the text into specific cells within the spreadsheet? Great video and thank you for the help.

@jimbolee1239 2 жыл бұрын

You make Excel very simple and you solved my problem thank you!

@markfannin3975 4 жыл бұрын

In my 365 Excel 2016, the Data option is missing. It should be between Formulas & Proofing but it's gone. Dang! This is a great tutorial. New subscriber!!!

@cosmophanthom9760 2 жыл бұрын

Try going to files > more > options !! pls confirm if this helps you ,, thank you !

@nuraisyahzahrasumadipura5391 2 жыл бұрын

Thanks bro really appreciate it, this is what i have been looking for the past hour

@MariaRodriguez-kw1bq 4 жыл бұрын

Thank you i was getting frustrated but you save my day.

@cathychats Жыл бұрын

Thanks but I’m still unable to use formula like usual and summing etc doesn’t work so I don’t understand what the purpose is if you can’t use it for calculations etc.

@joycemodau974 9 ай бұрын

This was very informative, thank you 😘

@allabout1135 5 жыл бұрын

Filaly the best series are here. Will wait next. I hawe the question. Is it possible load from folder multiple workbooks with multiple worksheets and chose specific tables to combine them? Thanks in advance.

@TeachExcel 5 жыл бұрын

Yes. The main thing is how you want to do it. Take a look at the Consolidate feature and I think that will get you pretty far in this case. Data tab > Consolidate.

@allabout1135 5 жыл бұрын

@@TeachExcel Thanks I find already solution. It is actualy wery simple. New Query from folder. And there in further steps can get all specific data.There can sort and pick just needed data. Amazing discovery and works perfect.

@rajuar1955 5 жыл бұрын

@@allabout1135 you can use Power Query ,Just go to data -->Getdata--->From File----> from folder. you can combine it by using this trick.

@77sparkles77 3 жыл бұрын

This was PERFECT! Thanks. It answered my question within minutes. LOL

@mikerouleaubass 5 жыл бұрын

I LOVE YOU BRO!!!!! THANKS FOR SAVING MY DAY :)

@mehmetfatihayten8269 4 жыл бұрын

thank you soo much, this tutorial saved my project :D

@alirashdi2003 3 жыл бұрын

Thank you that help alot

@XuanPham-gi6ol 3 ай бұрын

It's so useful ^^

@annemeredith9576 3 жыл бұрын

I don't have the extra tabs in the ribbon.....Heck I don't have the options when I try to SAVE AS

@mamunbiman3267 3 жыл бұрын

thanks a lot for this video

@mohamedmorsy1862 3 жыл бұрын

what if I want to edit in excel and directly it editing occur in txt file .. i mean i want to reverse the opearation you have done

@MotorScotti 4 жыл бұрын

Thanks a lot! Found what I needed!

@bluedominator650 4 жыл бұрын

Thank you for the video, I learned the workaround by using legacy import. However, I would still like to know this: At the end of the data set there is a green handle ┘ I think that delimits something... this is the issue. When I import in legacy mode I can select the entire worksheet and the filter button is not greyout. When I import the other mode, the filter button is greyout if you select the entire worksheet, however if you select everything within the data set, where the handle ┘ is, the filter button is available. How do you clear that limitation or how do you remove the END handle ┘ ?

@nathalievandam8811 3 жыл бұрын

Thank you whatever your name n is, my husbandj Mr. Shawn Parker whom I admire and love to kiki every steps of the ways, thanks to help me import from Clickfunnels CSV because I didn't know how too, and you made it up for me because you didn't want me to have an account with thier excell import csv files, so thank you, I hope it works, please send me more of your videos on how to get paid with click funnet and set up thier account because I am behind of 1 to 7 not all. Ok? ok.

@nasrinparveen7296 3 жыл бұрын

Thank you very much...

@aracelidreitzler7220 5 жыл бұрын

Omg THANK YOU SO MUCH! I could not figure out what I was doing wrong. My excel doesn’t have the wizard

@TeachExcel 5 жыл бұрын

I'm so glad I could help :)

@Vin2k410 3 жыл бұрын

You've helped me more in the last 4 minutes than my professor has in 6 weeks. Can I send you my tuition instead?

@TeachExcel 3 жыл бұрын

100% yes you can! Also how about some pizza and beer to get through lockdown 2.0 hahahah. I'm really glad I could help you! If you need any more help in the future, I have tons of videos, but sometimes its faster to just ask in the forum and you are welcome to do that. www.teachexcel.com/talk/microsoft-office?src=yt_comment

@LotfyKozman 5 жыл бұрын

Very impressive video. My question is: why and when should we disconnect the connectivity since PQ helps us to maintain connections between old and new additional files?

@TeachExcel 5 жыл бұрын

Whenever the source file will remain static, I like to remove all connection to it. Most data that is imported into Excel is done on a one-off basis and no connection needs to remain. I would, instead, look at in the reverse: when do I need to keep the connection? In that case, keep it if the source file will change or be updated and you want to mirror those changes in Excel. Personally, I don't like the idea of an outside source file controlling what is in Excel, so I tend not to use connections for any period longer than required, but ,they can be more helpful in specific business use-cases where file and folder structures remain stable and procedures for dealing with source files are standardized.

@siguerhakim4723 5 жыл бұрын

Thanks a bunch sir for your appreciate course

@etienneerasmus728 3 жыл бұрын

Maybe i missed something but why is my number columns still text. I cannot use number formulas?

@AhlamLamo 4 жыл бұрын

Thank you sooo much !!!!!!!!!!!!!!!! this so helpful

@TeachExcel 4 жыл бұрын

You are Very welcome! I'm glad I could be helpful :))))

@joannemccormack2011 5 жыл бұрын

Great tutorial! Thank you 🤩

@suryaraj6593 2 жыл бұрын

Thanks alot man

@saurabhsharma-hr2qx 4 жыл бұрын

Hello .. I like the tutorial.. very much.. But, want to learn about it..

@rameshca7063 5 жыл бұрын

Can't we use legacy text import wizard in power query custom separator I am not getting it only it is asking numbers to separate plz reply

@denverli2008 3 жыл бұрын

Great Video. Thanks

@filipe3310 2 жыл бұрын

That's a wise move! Thanks a lot!

@jonashubacek1341 4 жыл бұрын

Thanks bro! Really helped!

@thomasjohn1504 2 жыл бұрын

GOOD, THANKS

@allabout1135 5 жыл бұрын

Can You touch in You series topic : Data model and Conections (meaning in using,building, update, add and remove source)

@TeachExcel 5 жыл бұрын

I think that will be in there at some point but I'm not sure how it will fit-in just yet. I decided to change the order of the tutorials around and do a Power Query tutorial this week and so maybe I can get on those topics sooner rather than later.

@edlynviloria2156 3 жыл бұрын

OMG you have saved my day! Thanks

@TeachExcel 3 жыл бұрын

You are very welcome! I'm very glad to hear it :))

@vijaymehra28 3 жыл бұрын

Thankk you!!

@nateblack972 3 жыл бұрын

Very helpful, thanks!

@TeachExcel 3 жыл бұрын

You are very welcome Nate! Glad you liked it!

@chopstickcheppo1511 3 жыл бұрын

absolute legend

@laurinuoska794 5 жыл бұрын

Than you SO much for this!

@TahitiNini 4 жыл бұрын

Best tutorial out there!

@ravishankarmaurya8242 3 жыл бұрын

very nice....

@lahcenrerbal5893 4 жыл бұрын

Great Tuto

@incoitaly 5 жыл бұрын

thanks for your help

@funnybunny5670 Жыл бұрын

Thank you!!!!!!

@nguyenvu6371 4 жыл бұрын

Hello sir, when the txt file updated some new datas, can the excel file update immediately?

@rameshca7063 5 жыл бұрын

I am appreciate your great Sir Thankyou Sir

@kristinamccartney6905 4 жыл бұрын

Thank you!

@miquelmartinez9709 4 жыл бұрын

Thank you!!

@greeting527275 4 жыл бұрын

Thanks! excel 2019

@longstreet7792 4 жыл бұрын

Thanks 🙏

@136306m 4 жыл бұрын

God Bless you

@ZubairAzam333 9 ай бұрын

nice

@bennydavid623 5 жыл бұрын

Thanks a lot!!!!

@TeachExcel 5 жыл бұрын

You're welcome!

@richardlaycock7747 5 жыл бұрын

I assume you know that there no longer is a "Data" selection under Options in the wretched POS that is Excel 2016. I did subscribe but if I don't find an update to this video in your catalog I'll undo that.