Importing Data

In May, we explored all the cool import features that Grist offers, such as incremental imports, merge fields, and formula transformations.

Timestamps

00:07 Questions submitted during sign-up
05:55 Webinar overview and sample use case
06:45 Importing to create a new document v. importing into an existing data
07:18 Importing from Google Drive
08:50 Importing to create a table with columns from a spreadsheet
10:30 Importing only one table from a spreadsheet with many sheets
12:39 Importing data incrementally into an existing table
13:05 Column mapping when importing to existing tables
14:39 Extracting month, year from date columns
17:44 Summarizing data by a column, such as month
18:52 Merging data on a field to avoid duplicates & update existing records
26:37 Transforming data during import with a formula
30:52 Summarizing by multiple columns
32:53 Game time! Flashcards about Grist built in Grist: https://docs.getgrist.com/ffjN2J3kJYM5/Grist-Quiz

Recent Webinars

Creating Custom Invoices

Create and customize invoices in Grist—set up, brand, and generate professional, printable invoices with the Invoice custom widget.

Access Rules for Distributed Organizations

Learn to secure and manage data across multiple locations, control access at every level, and keep sensitive information in the right hands.

Integrating an open-source solution into a national digital strategy

Learn how governments build a national digital strategy around spreadsheets that’s both sustainable and truly sovereign.