1. Learn
  2. /
  3. Courses
  4. /
  5. Intermediate Importing Data in R

Connected

Exercise

Import Excel files from the web

When working with multiple data sources, .xls is a common format for storage and exchange. You have been provided with a URL which you'll be using to download and import a .xls file. The URL is already available in the sample code. Once downloaded, you will import the file using readxl and inspect its content.

Instructions

100 XP
  • Load the readxl package. It is already installed on DataCamp's servers.
  • Use download.file() to download the .xls file behind the URL and store it locally as "local_latitude.xls".
  • Import the .xls file located at the URL url_xls using read_excel(). Store the resulting data frame as excel_readxl.