There are a few ways to read spreadsheets in R.
Today we are going to show you how to do it the easiest way by using our free tool API Spreadsheets.
If you don’t want to use our tool, the second easiest way is to use the xlsx package with R. You can read how to do that in this blog post.
Step 0: Install the API Spreadsheets R Library
In your R environment install the API Spreadsheets library using the github install tool
Step 1: Create an Account on API Spreadsheets
Go to www.apispreadsheets.com and sign up for an account
- Click on Sign up in the Navbar
- Sign up with your email and password
Step 2: Upload your spreadsheet
Click on Upload or Drop Files and select your spreadsheet from your computer
Step 3: Copy the R Code from the dashboard
Copy the R code and run it in your R script
This will read the file as an R Data Frame with the Column Names as the Data Frame keys.
You can read the file in a different format be changing the Choose Data Format.
Step 4: Enjoy!
Relax with all the time you have saved or get working on your models and data cleaning!
If you have any questions with the tool, you can email us at firstname.lastname@example.org