Easiest way to read spreadsheets in R

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.

Image for post

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

$ devtools::install_github(asharma327/apispreadsheets_r_lib)

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
Image for post
Sign Up Button on the Toolbar
  • Sign up with your email and password
Image for post
P.S. feel free to email us with anything spreadsheet, data science and web dev related!

Step 2: Upload your spreadsheet

Click on Upload or Drop Files and select your spreadsheet from your computer

Image for post
You can also select a Google Sheet or from your Dropbox

Step 3: Copy the R Code from the dashboard

Copy the R code and run it in your R script

Image for post

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!

Image for post
Photo by Simon Migaj on Unsplash

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 info@apispreadsheets.com

Products and resources that magically simplify hard spreadsheet tasks. Check us out at www.lovespreadsheets.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store