Link spreadsheets together like database tables with Related Rows
Link rows between worksheets to connect data and eliminate data duplication, even across different workbooks.
Open linked rows from other worksheets to see all details and navigate to other related rows. Each worksheet is both a traditional spreadsheet and a relational database table.
Create Views that show data grouped and filtered by specific relationships.
1-way relationships work like formula lookups, automatically pulling related data from a different worksheet. 2-way relationships keep related data synced between two worksheets, like relational database tables.
Make complex data entry easy for users by restricting related row cells to a specific set of rows in the target worksheet. For example, only allow selection of fulfillment centers in California.
Use Related Row Lookup and Relate Row Rollup data types to look up and aggregate information from related worksheets. Replace complex VLOOKUP, HLOOKUP, and XLOOKUP formulas. Or use both, the choice is yours.
Use a visual no-code workflow editor to create automations and integrations that run when relationships are created, changed, or removed.
Learn more >