Easiest way to read spreadsheets in Python

There are a few ways to read spreadsheets in Python.

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 Pandas with Python. We wrote a blog post on how to do that and you can read all about that here.

Step 0: Install the API Spreadsheets Python Library

In your python environment on your computer, install the API Spreadsheets library using Pip

$ pip install apispreadsheets

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 Python Code from the dashboard

Copy and run the python code in your script.

Image for post

This will read the file in an array that is the length==rows of the file.

Each item in the array will be a dictionary with the column names as the 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