The Sheets & Excel Integrations allow you to quickly and easily embed your reports into the Zeck Section.
Included in this Article:
2. Google Sheets Integration
The Google Sheets integration allows you to link and display your sheets directly in Zeck. You'll also have the ability Sync the embedded Sheets to update the displayed data which makes duplicating and updating your Zecks lightning fast. ⚡
To Embed a Google Sheet:
- Click into the space where you would like to add a sheet
- Click the Add (+) button to open the Element Menu
- Select Google Sheets
- You can also type Forward Slash (/ ) and then start typing the Element (e.g. "Sheets") to jump right to your element of choice
- If this is the first time, click Connect Account and sign into your Google account
- Click Select a File
- Choose the file from your Google Drive and then click Select
- Choose a Tab or Named Range from this file and click Select
- To sync the report to update Zeck from your source file, click on the embedded Sheet and click Sync
3. Excel Integration
There are two options to embed an Excel file in Zeck: a direct upload and a OneDrive integration. The direct upload option allows you to pull in a file directly from your computer and the OneDrive option will allow you to Sync to update directly from your drive.
To Embed an Excel File through a Direct Upload:
- Click into the space where you would like to add a sheet
- Click the Add (+) button to open the Element Menu
- You can also type Forward Slash (/ ) and then start typing the Element (e.g. "Excel") to jump right to your element of choice
- Select Microsoft Excel and then Excel Upload from the list of Integrations
- Click Upload Excel File
- Choose the file from your computer's file finder and then click Select
- Choose a Tab or Named Range from this file and click Select
To Embed an Excel File through OneDrive:
- Click into the space where you would like to add a sheet
- Click the Add (+) button to open the Element Menu
- You can also type Forward Slash (/ ) and then start typing the Element (e.g. "Excel") to jump right to your element of choice
- Select Microsoft Excel and then Excel via OneDrive from the list of Integrations
- If this is the first time, click Connect Account and sign into your OneDrive account
- Click Select a File
- Choose the file from OneDrive and then click Select
- Choose a Tab or Named Range from this file and click Select
- To sync the report to update Zeck from your source file, click on the embedded Excel file and click Sync
4. Customize the Table View
If your embedded Google Sheet/ Excel table is longer or wider than the default view, you may want to freeze the first column or row to make scrolling through the table even easier for your Viewers.
To Freeze Columns and Rows:
- Click on the embedded table, this will bring up a Formatting Menu
- Click the dropdown (v) next to Freeze
- Choose the Number (1 or 2) of Rows and/or Columns to Freeze
🤓 Pro Tip: You can't freeze merged rows or columns. If you go back to the source report, modify the formatting to unmerge and re-sync in Zeck, you'll then be able to freeze the row/column.
👋 Need more help? Reach the Zeck Customer Success Team directly at success@zeck.app.