Import From File

Return to Introduction  Previous page  Next page

WinCalendar can accept Excel (xls / xlsx / xlsm) or CSV (comma separated values) files for conversion to graphical Calendar/Schedule/Agenda/Gantt in Excel format.

See Sample_Import_Format.xlsx for sample Excel import file.
See Sample_Import_Format.xls for sample older Excel import file.
See Sample_Import_Format.csv for sample CSV import file.
...Depending on your system/security settings, above links may not work.  The sample import files can also be found in the install folder (by default: c:\Program Files\WinCalendar V4\ or c:\Program Files (x86)\WinCalendar V4\ )
...to select custom color numbers see wincalendar.com/Color-Picker

 

Notes:

CSV & Excel import format are otherwise the same format (besides file type), except that CSV files do not support the color "match" feature.  In CSV files you must use color number to specify custom background or Font Colors (optional).
Header row ('Summary', 'Start Date'...) is required.
You can exclude Optional columns (like 'Start Time' and 'location') or simply leave the value blank.
See the Excel header cell comments in the file Sample_Import_Format.xlsx for more info on each import field.