Connecting Excel to Matik provides users with a powerful yet simple way to get data into Matik. You can use an Excel spreadsheet as a simple data source and pull data from a single cell or range of cells. You can also enter input values into a sheet and capture any desired output calculations. This allows you to build out complex calculations within your dynamic content. Excel makes it possible for Matik users to create pricing calculators, perform lookups on simple tables that are not in databases, and more.
Creating Excel Dynamic Content
To create dynamic content from an Excel Spreadsheet, add the Spreadsheet into your data sources if you have not done so. Then, create a new piece of dynamic content. Select "Data-Driven" and select your Excel Datasource from the list of data sources.
The next steps are to 1) Define inputs and 2) Define outputs. Inputs are the data you want to pass through to the spreadsheet. You do not need to add any inputs if you do not want to input any data into your spreadsheet. If you are not using inputs, skip to the Define Outputs section below.
Matik will place inputs into your Excel spreadsheet at the generation time and capture the output cells you define. Note that no changes are made to your original data source spreadsheet. Consider the following sheet:
Let's imagine I have an input in Matik called "Number_of_Seats". I can assign the "Number_of_Seats" input into cell B2 and set cell B4 as my Sheet output. When a user creates a presentation that contains this dynamic content, they will fill out the "Number_of_Seats" input. That number will be passed into the Pricing calculator Sheet in Cell B2. Matik will then insert the result in Cell B4 into the presentation.
You will walk through this wizard below when configuring your inputs and outputs. You can select cells from a preview of your Excel Spreadsheet by clicking on the spreadsheet icon to the right of the text box.
To tell Matik which cells in your spreadsheet you want your input to go to, click the appropriate field in Matik under “Sheet Inputs" and then select the input cells in the spreadsheet view. For example, if you select cell B3 in the spreadsheet view, Matik will automatically enter this cell reference into the appropriate input field in Matik in the required format (e.g., Sheet1!B3).
If you want to access other sheets within your spreadsheet data source, select it using the arrows in the bottom left of the sheet preview. Note that the bottom sheet tab will only display the current active sheet and does not display all sheets available.
In the box next to the input cell, enter the input you want to be inserted. You can use Matik inputs by entering
&: followed by the input name—to learn more, go to the Inputs page. You can also enter static values as inputs.
Outputs are the data you want Matik to pull from the Excel Spreadsheet and insert into your finished presentation. Outputs can be a single cell or a range of cells.
To tell Matik which cells in your spreadsheet you want to be outputted into your finished presentation, click again into the "Cells in Sheet" field in Matik under “Sheet Output," then select the output cells in the spreadsheet view. For example, if you select cell D3 in the spreadsheet view, Matik will automatically enter this cell reference into the appropriate output field in Matik in the required format (e.g., Sheet1!D3). You can also add optional column names in the "Comma-separated list of column names" field.
If you would like to access other sheets within your spreadsheet data source, select them using the arrows in the bottom left of the sheet preview. Note that the bottom sheet tab will only display the current active sheet and does not display all sheets available.
Matik will automatically strip leading and trailing whitespace from output cells when inserting values into presentations. E.g. A cell with the value " Example Text " will be inserted into a presentation as "Example Text".
Remember to test your new piece of content, and then press “Add” to save it to Matik.
Tagging Excel Dynamic Content
Once you have created Dynamic Content, the next step is to identify where you want this dynamic content to appear in your templates with tagging. Navigate to the templates page and select the template you would like to tag dynamic content in. If you do not have a template yet, you can create one using these instructions.
Click on the slide you wish to tag your dynamic content. Within the preview of the slide, you can highlight the text where you want your dynamic content inserted. Click the plus icon that appears near the highlighted text. Next, select your dynamic content and click save.
Tagged Dynamic Content will appear in the left menu when previewing a template and its slides. You can now test your slide to ensure that it was tagged correctly by clicking on the "Test Slide" button above the slide preview and following the on-screen prompts.
For more on tagging, including how to tag graphs, images, and tables, see our Tagging Overview article.
Large amounts of data, sheets, media, and complex formulas within your Excel spreadsheet can result in long load times and performance issues with your spreadsheet-based dynamic content. We recommend removing all data and sheets not required for your dynamic content output.
Matik is not capable of tracking changes to columns and cell locations. When updating your Excel files, be conscious of the cells Matik uses to input and output data and change any linked Dynamic Content if these cells' locations are altered. We recommend creating a separate tab in your spreadsheet containing all of your input and output cells referenced in Matik so that any changes to your spreadsheet (adding or deleting rows and columns) will not affect the cells referenced in your spreadsheet-based dynamic content.
Please sign in to leave a comment.