Import From Excel Ranges

Return to Introduction  Previous page  Next page

Import calendar data directly from any Excel spreadsheet range. Red lines below reflect required fields. Green lines reflect optional import fields.

Excel-Data-to-Calendar

 

Notes:

Optional values can be blank or the input can be omitted all together.
This data can then be used to create any of the supported Calendar layouts in Excel including Monthly Calendar, Weekly Calendar, Schedule, Agenda, and Timeline (Gantt Chart).
Do not include the header in the input ranges.
All data must be in contiguous rows (you cannot have completely blank rows within the data).  Data cells cannot be merged.  
Description (a.k.a. Appointment Body) are only supported in Layouts: Schedule, Agenda, and Spreadsheet Table.  All other layouts will not display this input.
Dates must be in an Excel date format.  Tip: to set as a date format in Excel use shortcut Ctrl + 1 then select a date format...
Excel-Date-Format
...note you may then need to re-enter the date(s) for Excel to recognize as a date.
WinCalendar stores a 'snapshot' cache of the data every time 'OK' is pressed on the form shown above.  This data can then be re-used for future runs without having to open the source file.
Background and Text color columns (optional) can have the color number as inputs or match telling WinCalendar to match the cell background/font color.  For color number selector see WinCalendar Color Selector.
Similarly, WinCalendar can also import from Excel or CSV file.