Please enable JavaScript to view this site.

 

Navigation: Saints and Namedays > Importing

Importing Saints and Namedays Exceptions from Excel

Scroll Prev Up Next More
To import saints/namedays exceptions from an MS-Excel file, use the Import button located on the Saints/Namedays Exceptions tab of the the saints and namedays manager.

 

Importing saints/namedays exceptions from an Excel file consist of 2 parts:

 

Preparing the Excel file.

 

Importing into the currently selected holidays set.

 

Expected Column Layout

 

To import saints/namedays exceptions, make sure your Excel file contains the expected information in the expected columns:

 

Column A

Column A should contain the date.

Date Format 

Make sure you enter a date as 1/1/2024 or 3-5-2024, not as free text. If the date you supply is not understood, it will appear as Incorrect Date Format, as shown in the image on the right, in the Date column of the preview grid at the bottom of the import from Excel dialog.

Column B

Column B should contain M or F or nothing to indicate the gender.

 

If always use the same format of displaying the saints/namedays exceptions in your diaries, then it might be easier to enter the prefix and name into the column C (eg. Saint Olivier). Otherwise you can have just the name in column C (eg. Olivier) and the gender in column B (eg. M), in which case you can use a combination of various saints tokens to show the name and prefix or just the name.

Column C

Column C contains the saints/namedays exceptions name.

 

You can include special character markers, such as &t or &s or &c, to include tabulations or returns in the saints/namedays exceptions names.

Column D-E-F- ...

Generally, the columns D-E-F-... to the right of column C are left empty, but there are cases when you might want to use these columns.

Multiple Holidays Sets in the same Excel File

If you have 2 or more lists of saints/namedays exceptions in the same Excel file, then you can specify, for each importation, which column to use, with column values starting at 4, which corresponds to the default column D. In the example on the right, taken from the middle section of the import from Excel dialog, the importation would use the text of column E as the names of the imported saints/namedays exceptions.

The importation could then be repeated using column D or G as the source for another holidays set.

 

Importation Procedure

 

To import saints/namedays exceptions from an Excel file, prepared as described above:

 

1.Select the holidays set into which you want to import.

2.Use the Import button located on the saints/namedays exceptions tab of the the saints and namedays manager.

3.At the top of the import from Excel dialog, select an Excel file (both the XLSX and the XLS file extensions are accepted).

the Excel file contents preview

the Excel file contents preview

4.Use the preview to specify at which row to start the importation (as shown in the example on the right, make sure you do not include title headers in the rows selected for import).

IMPORTANT: If the dates you see in the preview are 4 years earlier than what you are expecting to see, then this is due to the way the Excel file was saved on the Macintosh.

5.Decide if you want to import the contents of only one specific column, or of all non-blank columns (in which case you should specify the text to be used to separate each column's text, as shown in the examples of the previous section covering Columns D-E-F).

6.Click on the Import button. Once importation is complete, a dialog will come up informing you of the number of saints/namedays exceptions successfully imported.

Contrary to the importation of recurring holidays, at this stage there is nothing else to do, and you can start using the imported saints/namedays exceptions immediately.

 

See also: importing saints and namedays from Excel.

 


Topic 171520, last updated on 04-Nov-2023