Import Data, Copy Data from Excel to R CSV & TXT Files | R Tutorial 1.5 | MarinStatsLectures

How to Import CSV data into R or How to Import TXT files into R from Excel or other spreadsheets using function in R

►► Watch More:

◼︎ Table of Content

0:00:17 What are the two main file types for saving a data file (CSV and TXT)
0:00:36 How to save an Excel file as a CSV file (comma-separated value)
0:01:10 How to open a CSV data file in Excel
0:01:20 How to open a CSV file in a text editor
0:01:44 How to access the help menu for different commands/functions in R
0:04:10 How to save a file in Excel as tab-delimited text (TXT) file
0:04:50 How to open a tab-delimited (.TXT) data file in a text editor
0:05:07 How to open a tab-delimited (.TXT) data file in excel

This video is a tutorial for programming in R Statistical Software for beginners, using RStudio.

Follow MarinStatsLectures

Our Team:
Content Creator: Mike Marin (B.Sc., MSc.) Senior Instructor at UBC.
Producer and Creative Manager: Ladan Hamadani (B.Sc., BA., MPH)

These videos are created by #marinstatslectures to support some courses at The University of British Columbia (UBC) (#IntroductoryStatistics and #RVideoTutorials for Health Science Research), although we make all videos available to the everyone everywhere for free.

Thanks for watching! Have fun and remember that statistics is almost as beautiful as a unicorn!

[vamsi]

Trust me sir. After trying various various online tutorials and e-books, I am writing this review. These videos are the most amazing videos on R one could ever discover and it is almost impossible for anyone to not praise you for this awesome help you are doing to people who cannot afford to take courses. You will always be blessed for this help you are doing to thousands of people. I will make sure that all my friends in my college will watch these videos and get benefited.

Thanks a ton again sir. Keep up the good work going. You are truly loved by all of us here who are on your page.

Vamsi Krishna.

[gimbulino]

Finally handy videos extremely helpful for a guy aged 58 wanting to fill the technological gap and for the first time ever seriously considering investin time and energy in R and progressevely make the transition from Excel

[alfredkik]

Without having any background knowledge about r, I could analyze my data for MSc thesis really well by following your amazing videos. You high quality tutorials are really helpful, thank you very much.

[meganmeunier]

I know this video was posted years ago but I just wanted to say thank you! My professor at uni said that R was much better than excel once you got to grips with the coding language but unfortunately the uni only offers courses on using excel for data analysis. I'm so excited to start using these skills for writing papers and not having to deal with the whole messiness of excel.

[marinstatlectures]

Thanks, glad to know you're finding them useful...we've put a lot of work into them. Thanks for watching ;-)

[rabinkc]

This is the first excel datasheet I ever read in R. After 7 years with R, I thought I would visit Marinstats....It was a great start. Thanks.

[fincharus]

Thank you a bunch been screaming at the PC for hours only to find the header= TRUE would fix all my class issues.

[cutlass]

Hello good sir! I would like to personally thank you on the behalf of graduate students everywhere, who are being introduced to R for the very first time. You are a life saver.

Cheers sir!

[vitinho]

You're way more that a teacher! I'm really really grateful : D

[lukasiohan]

Thanks for sharing your knowledge with us!!!! The World needs more people like you. Greetings from Brazil.

[TheMadKaz]

Thank you for this!!! Spent 2 hours googling and getting irritated at all the patronising "help" blogs and the help sites full of computer jargon but finally cracked it. 

[naseerbhat]

Thank you so much. For someone like me with zero programming/coding background, you gave me an eureka moment.

[borisjankovic]

Wow, high quality lectures, very thouroughly designed, covering everything, easily understood by beginners + free?! You have a new subscriber, keep making these!

[adrianapetrova]

You make it so easy. Thanks, that's the second time I watch your videos. The first time I saw it all, after that I couldn't find anyone that explains like you do, I left it and I forgot it all. Now I'm back and you have even more videos :D

[pkhuntiable]

oh my god !!! these are best collection of R tutorials !!!

[ShahidIqbal-sqbf]

for someone like me you are an angel i struggled so much with it.

[LL-hjyh]

I've tried so hard finding why I couldn't input my csv data, since I just started R Studio. Thank you very much!!! Especially the first half part already solved my problem! Thanks!

[ramjielangovan]

most straight forward and easy approach
thank you so much

[redd]

Dude I want to thank you so much. You are helping me learn so much that my uni lecturers miss out

[gabrielbarros]

Best tutorial ever, you certainly have a teaching soul... congrats. Wish you all the best.