August 2023 Newsletter#
Work at Grist#
Grist is currently looking for a Video Creator & Graphic Designer who has a good understanding of spreadsheet-database tools. If you’re skilled at creating engaging videos and visually compelling graphic designs, come work with us!
This is a contract position. For more details, check out the job description.
Grist CSV Viewer#
Another month, another exciting update – this time for the venerable file format we all know and love, the
.csv. The Grist CSV Viewer is a free tool that gives CSVs the power of Grist on the web. No more downloading and opening CSVs in an external app, now you can preview and interact with CSVs in a Grist-powered spreadsheet!
The viewer is open source, supports features like filtering, sorting, copy/pasting, and even formulas. And it’s easy to install, with just two lines of HTML added to any website.
AI Assistant – Support for Llama#
𝓢𝓽𝔂𝓵𝓮𝓭 column headers#
You can now style column headers! Look! (Thanks to @CamilleLegeron and the ANCT for the PR.)
.grist file download options#
You can now download a
.grist file’s structure without any data, which is useful for templating. Or you can download a
.grist without document history which reduces file size.
In our tests, we’ve seen documents go from 10.8mb to 1.5mb after omitting file history. 😲
File importing redesign#
File importing has been updated with a new flow, with better support for multiple files/sheets and column mapping.
- Grist has been upgraded from Python 3.9 to 3.11. This update brings with it the following new features:
- Links are now clickable in widget and column description tooltips.
- Grid selection now supports
CTRL/CMD+Shift+<arrow>shortcuts. If you’ve used this shortcut in other popular spreadsheet products, you’ll be right at home! (Thanks to @Ocarthon for contributing to this!)
Tips & Tricks#
Grist for spreadsheet users#
New to Grist but an expert with Excel/Google Sheets? Our new blog post covers what makes Grist different and why it’s designed that way, specifically for users familiar with the usual spreadsheet apps.
Working on something cool with Grist? Let us know by posting in the Showcase forum!
Webinar: Deconstructing the Payroll Template#
In September we’ll rebuild our Payroll Template. This template uses formulas to look up hourly rates based on person, role, and date. You’ll also learn how to build dynamic summary dashboards that summarize data by categories and let you drill into the records in those categories.
Thursday September 21st at 3:00pm US Eastern Time.
Deconstructing the Class Enrollment Template#
When looking at our templates you may wonder why templates are structured in a particular way. In August we rebuilt our Class Enrollment template. This template uses reference columns to relate data in five different tables. Learn when to use reference columns, in which direction, and how to use helper tables to better structure your data.
Proposals & Contracts#
Natalie has created a detailed tutorial showing how this (very advanced) template was created. We actually use a version of this very template at Grist to handle contracts, so it’s tried and tested!
Not only can this template be used to generate printable contracts with dynamic content, it can also generate contract templates themselves. So you can have several versions of dynamic contracts created from the same Grist document. 🤯
Help spread the word#
If you’re interested in helping Grist grow, consider leaving a review on product review sites. Here’s a short list where your review could make a big impact. Thank you! 🙏
We are here to support you#
Sprouts Program. Grist often surprises people with its capabilities. Schedule a free Sprouts call with an expert to see if Grist can address your needs. Learn more.