Create a view in a Google Sheet when creating a [[tidy endpoint]] to export data or share with other sheets or applications. A view is simply a calculated table. ## best practices To include a column in its entirety, for example column A from Sheet1, use an array formula like `={Sheet!A:A}`. This will allow subsequent users to add and remove columns from `Sheet1` without impacting your tidy endpoint. To join data, use `VLOOKUP` To concatenate data from a many-to-many table, use `JOIN`