List Template

The List template style generates a basic list of events or tasks for a specified date range, optionally including events or tasks that have no associated date.


List templates provide the following options when creating a calendar...

Start date The first date to include in the output.
Number of days The total number of days to include in the output.
Time format The time format. Supported formats are 12-hour (8:00 PM), 24-hour (20:00), Shortened (8pm), Military (2000), and Numeric (20.0). An example time is shown for each format in the drop-down list.
Include items without dates When checked, tasks without due dates will be included in the output.
Include completed items When checked, tasks that have already been completed will be included in the output.
Include overdue tasks  When checked, any tasks that will be overdue before the specified start date will be listed, even if they were scheduled to be due on an earlier date.
  • Hi ynpmoose, if you're referring to the List template, there isn't a mechanism to add formulas which will not result in blank space at the bottom. I could develop a custom template for you which does exactly what you need. If you're interested, please send an email to with more details about what you'd like the output to look like, so I can estimate what it would cost.

    You can probably work around the problem by generating in Excel and then copying only the rows with data before pasting into Word.

  • Is there any way to add custom columns populated with Excel formulas. For example, I want to only show two columns: Start Date and a custom string concatenation.
    Example: Time & " " & Title & " " & if(Location<>"", "(" & Location & ")")
    This helps me to narrow the width considerably. I could add a column, but had to paste the formula into 50 rows as a placeholder. If there are less than 50 events, the resulting Word grid has blank space at the bottom.

  • Thanks for the quick reply! That worked.

  • Hi ynpmoose, the horizontal lines come from a custom format. To remove the lines, click the "Conditional Formatting -> Clear Rules -> Clear Rules from Entire Sheet" button on the Home tab of the ribbon menu.

  • How do i remove the horizontal lines between entries? It doesn't appear in the template if you customize it.

  • Hi dglp, the template doesn't support categories, but I've added this to my to-do list. PrintableCal already imports categories from most data sources, so this would be relatively easy for me to implement.

    You can customize the current template to include a Duration column, which would consist of a formula for subtracting the values in the Start column from the values in the End column, and formatting the result as a time-span. The documentation linked below explains how to customize templates:

    Unfortunately, including custom tags from iCalendar files would be a bit more involved. It would require creating a custom data source using the PrintableCal API, and a custom template for using the additional fields. It's definitely possible, but it would require programming knowledge. You can learn more about the API here:

    If you'd prefer, I can develop the custom data source and template for you. Please send an email to with more details about the custom fields you'd like to import and how you'd like those fields displayed in the output. I'll put together an estimate on how many hours it would take for me to complete and how much it would cost.

  • I'm wondering if this template can be modified to include other info from the iCal fields. Specifically, I'd like to have Categories, and Duration. If there are options for custom fields, tags or similar, I'd like to make use of that too.

blog comments powered by Disqus