Sharing spreadsheet data with other people can be inconvenient and messy. However, API Spreadsheets makes it easy for you to collaborate with your co-workers or friends.

---

What Can API Spreadsheets Do?

Sharing spreadsheet data can get tricky. With API Spreadsheets, even if that data changes, your code would never have to change. And it will also read in the most up to date Spreadsheet data.

Even if the Spreadsheet is on Dropbox, AWS, Google Sheet, Local Computer or directly created.
Our tool, API Spreadsheets, lets you do that.

How?

We use the power of APIs to create a URL to your spreadsheet data, whether it is on Google Sheets, Dropbox, AWS, Quickstart or Locally. Then that URL stays current no matter what.

So you, John and Koya can all have the same URL in your Python code. And when the data changes, you won’t have to do anything :)

If you don’t know what an API is, feel free to check out our article describing APIs.

Okay, that sounds interesting. But how does it actually work?

Let’s walk through a scenario.

You are the team leader of a Data Analytics team. John and Koya are your direct reports and all three of you do experimental modeling in Python to figure out why your customers might be leaving.

You get a Customers.xlsx file every week from your sales team. And your team maintains a Regions file on Google Sheets. Both are essential to your modeling.

So instead of re-downloading and re-emailing the file to everyone every time the data changes, you can use API Spreadsheets to get a URL for each of your files.

You pick one person in charge of creating the URLs. It is important to have just one leader for Data Governance.

This person creates an account on API Spreadsheets and then uploads the Customers.xlsx file and connects to the Regions file on Google Sheets.

After a file has been uploaded and connected, you will get an API URL. And a Python code snippet on how to read your data.

You can play around with the data format and see how you would like to read your data. You can see how each Data Format looks in the Sample Response.

Now, all three of you can use the same Python code to read in the data!

---

Wait, so how will the Data update automatically?

For Google Sheets, the data will always just update automatically as you add, delete or update any rows.

For the Excel file, in this case Customers.xlsx, the Data Governer will need to replace the current version with the new version in their Dashboard on API Spreadsheets.

This is very simple AND it maintains your API URL. That means your code in Python will not need to change.

1. Go To The Files Tab

2. Go to your Customers.xlsx File, Click More Options, Click Replace File and Replace with your current version

That’s it! Now your Customers.xlsx file is up to date and your URL will give you the most recent data.