Swiss National Bank (SNB) Instructions on handling Excel forms

Excel-type forms are freely available from the SNB for use in its surveys. The institutions required to report data can use them to complete their reports and then submit the Excel files to the SNB for processing.

The Excel files generally contain a delivery note, one or more SNB forms and, in some cases, additional tables containing information. They do not contain any macros.

The tables with the forms are protected so that entries can only be made in designated data entry fields. Entries cannot be made in fields such as totals that are calculated by the system. Some tables may also include validation tests, and error or warning messages are produced when necessary. The errors and warnings are transferred to the delivery note.

Please always send complete Excel files.

The names of the sheet tabs in the Excel files may not be changed.