Working with CMS Data

Google Sheets

No items found.
Overview
Useful Tools & Techniques
Google Sheets
5:45
201
Find Duplicate CMS Items
202
No items found.

Google sheets is a fantastic tool for preparing your data for the Webflow CMS. It's easy to use, free, and highly capable.

Just as important, your client can access it to complete and review data work before you do the load.

Useful Functions

These are some of the functions and techniques worth knowing about;

Named Ranges

Name ranges for reference and administration. Ranges can be open-ended with e.g. Team = A2:A

COUNTA

Determine the number of populated cells in a table

COUNTA(Team) = 223

SEQUENCE

The SEQUENCE function allows you to generate numeric sequences.

  • Generate integer sequences for explicitly sorted data. Here I recommend organizing your data the way you want, and then generate an integer sequence with a step of 10. That makes it easy for your client to insert new items later with minimal collision.
  • Demonstration data. If you need to show 100 items and identify them as they shift and move about the page, this is an ideal way to numerically identify them.

RANDOM SELECTION

Random Selection from a List, a technique outlined by Kieran Dixon here.

=index(Team, RANDBETWEEN(1,COUNTA(Team)))

Internal Resources

e.g.

https://docs.google.com/spreadsheets/d/1zKSd2hxTz-F0a8U6LxsTPicAZGoeQq05PAJkHXm-fKc/edit#gid=348733693

Table of Contents
Did we just make your life better?
Passion drives our long hours and late nights supporting the Webflow community. Click the button to show your love.