Eduardo-Lucas/django-sheets

Use Google Sheets as context variables in Django templates

django-sheets

Use Google Sheets as context variables in Django templates

Usage

In your template:

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

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

Documentation is available at https://django-sheets.readthedocs.org.