Excel Data Analysis 2 - Import CSV Files into Excel

Visit www.TeachMsOffi... for more, including Excel Consulting, Macros, and Tutorials.
Learn how to import CSV files into Microsoft Excel. This tutorial shows you how to use the import wizard in Excel 2007 to import text and CSV files into Excel. You will learn what delimiters are and how to use them as well as where to go for the properties to edit how the data imports into Excel. This is a great tutorial for everyone who needs to import data and text files into Microsoft Excel.
For Excel consulting or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!

[@dewars22]

Worked very well!!
As a piece of advice, sometimes you download the data and it automatically becomes an excel file. what I did was to copy the text that was in excel, pasted it in a notepad file, and from there I followed your steps. It worked significantly good, Thanks!

[@TheLivePatriot]

great video thanks saved me tons of time and headache looking for it

[@mk318020]

Excellent tutorials. Thanks a lot!!

[@nickbaker514]

This was the best video ever

[@kimvo1628]

Thank you so much. it is very helpful and make my job much more easier. thanks again.

[@donnarachellea.zeimen428]

glad I found this vid. tutorial,very helpful...thank u so much....

[@rossyqu]

thank you so much, big help :)keep it up sir :)

[@JoeBlack666]

Thanks! Saved my life

[@spocek]

Great job! Thank you very much.

[@HindKS]

Thanks, helped me at work :)

[@ioker131]

very helpful, thank you

[@ivory3908]

TY U SO MUCH!

[@hanshansen9777]

THANK YOU SO MUCH :-)

[@aleemshaikh6603]

Thank you

[@simoselfsky7101]

Thank you sooo much - Merci infiniment ^ _ ^

[@maggycol]

what about importing .log files (from STATA) into excel? Could you please explain us?

[@HindKS]

Any idea how to create invoices from a csv file?

[@vishal95446]

Very Nice and interesting topic, but can't access please help me

[@TeachExcel]

I'm not sure what the issue is but you can ask in our forum and upload a sample file and that will make it easier to help you: www.teachexcel.com/talk/microsoft-office?src=yt

[@rcx8666c]

WHY DO THEY USE COMMAS TO SEPARATE WORDS IN CSV.
COMMAS ARE TOO COMMON A CHARACTER.
THEY SHOULD USE A LESS COMMON CHARACTER LIKE :

[@michaelgranados6214]

.CSV stands for Comma Separated Value. It's an older format that is used to organize data where the comma character wouldn't be a common occurrence at all.