Google Excel – Create and edit the spreadsheets online for free. Google Sheets is an online spreadsheet app that lets users create and format spreadsheets and simultaneously work with other people. Google Sheets isn’t only for consumers: it’s used every day by businesses and schools to manage spreadsheet data. With the new Sheets API v4 and Sheets add-ons, that data can be accessed by code as well as users.
Rich integrations with Google Excel data
The features that make Google Excel so successful are available through the Sheets API. With the API, your code can access and update spreadsheets just like any other user. The API lets your apps:
- Import, export and format Sheets data
- Control conditional formatting
- Build and edit charts embedded in a sheet
- Configure data validation
- Create and update named and protected ranges
- Add and adjust filtered views
- Create and manipulate pivot tables
… and even more!
Comprehensive access to spreadsheets
Sheets API v4
Read, write, and format data in Sheets. Programmatically create and update pivot tables, data validation, charts and more.
Getting started with the API
Our quickstarts are there to help you get something running right away. Once you’ve seen the basics, our codelab gives you a detailed look at the process of building a Sheets API application.
API Guides and Reference Docs
These guides explain how you can implement some of the most important use cases. The reference documentation contains detailed information about the API types and methods.