Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Use Google Sheets as context variables in Django templates

Project Description

Use Google Sheets as context variables in Django templates


In your template:

{% load sheets %}
{% csv "1uPsdcGUnUsf3d2xGHRGUUb7_k5IQPtBvfQY61u8Z8wE" as data %}
        {% for header in data.headers %}
            <th>{{ header }}</th>
        {% endfor %}
        {% for row in data.rows %}
            {% for cell in row %}
                <td>{{ cell }}</td>
            {% endfor %}
        {% endfor %}

View the output, you should see

Origin (English) Name (English) Origin (Native) Name (Native)
Australia Nicole Kidman Australia Nicole Kidman
Austria Johann Strauss Österreich Johann Strauß
Belgium (Flemish) Rene Magritte België René Magritte
Belgium (French) Rene Magritte Belgique René Magritte
Belgium (German) Rene Magritte Belgien René Magritte


Documentation is available at


0.1.2 (2014-24-03)

  • Added gid parameter for multi-sheet documents

0.1.1 (2014-22-01)

  • Added .headers and .rows methods (aliases for [0] and [1:])

0.1.0 (2014-18-01)

  • First release on PyPI.

Release History

This version
History Node


History Node


History Node


Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, Size & Hash SHA256 Hash Help File Type Python Version Upload Date
(5.8 kB) Copy SHA256 Hash SHA256
Source None Mar 24, 2015

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Google Google Cloud Servers