R readxl Range Tutorial with RStudio and R Package

In this short tutorial, I will show you how to use R and RStudio and the readxl package to import an Excel Range into your data.

Use the readxl package to easily get data out of Excel and into R. Compared to many of the existing packages (e.g. xlsx, xlsReadWrite) readxl has no external dependencies (no Java!), so it’s easy to install and use on all operating systems. readxl supports both the legacy .xls format and the modern xml-based .xlsx format.

👇SUBSCRIBE & HIT THE 👍 BUTTON 👇

Do you have more to add? Let me know how you liked the video or if I need anything corrected in the comments below.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TECH GEAR I USE DAILY

OTHER COURSES I CURRENTLY TEACH

Let's chat
#CommissionsEarned

“As an Amazon Associate I earn from qualifying purchases.”
I've started a blog about IT and software development projects along with some sound career advice. Check it out:

[dcruz]

Great tutorial !! Hopefully you continue as you mentioned with data manipulation.

[mattburgess]

Is there a way to read certain columns from the excel spreadsheet? For example, if you didn't want the blank column and just wanted to import columns "d", "e" and "g".

[aliramadan]

Thanks Mark! I have been using read_excel for a while and never knew there was a "range" argument. Wanted to ask with the write.xlsx function is there any argument where I can name the sheet of the workbook I want to write to? If not, would appreciate if you can advise how to do it.