Bank of Spain Logo, link to homepage

Boletín Estadístico

Downloading files with time series

Analysts and "watchers" of the Spanish economy wishing to have time series in a spreadsheet format, or loaded on to a database, can download files with the full time series relating to the tables of the Boletín.

DOWNLOADING THE USER'S MANUAL PDF File: Link in a new window

This manual describes the structure and content of each of the fields of the time series files and of the catalogue file, along with the systems of keys and codes used. It also offers brief guidance on how to use these files with a spreadsheet or load their content on to a database.

DOWNLOADING THE CATALOGUE FILE OF ALL THE SERIES IN THE BOLETÍN CSV File: Link in a new window

The user's manual describes the structure of this file, which contains an entry for each series with its identification key, the name of the file in which it is included and the related metainformation (description and frequency of the series, type of variable, unit code, number of decimal points, date of first and latest observation, sources, notes, etc.)

DOWNLOADING A COMPRESSED FILE WITH ALL THE SERIES RELATING TO ALL THE TABLES OF THE BOLETÍN ZIP File: Link in a new window

A ZIP file of approximately 5 MB can be downloaded which, once decompressed, gives access to a batch of files whose characteristics are described in the user's manual. There are more than 8000 full time series relating to the content of the Boletín.

FACILITIES FOR DOWNLOADING COMPRESSED FILES RELATING TO THE SERIES OF EACH OF THE CHAPTERS OF THE BOLETÍN

On the contents of the Boletín, an icon ZIP File: Link in a new window can be seen alongside the heading for each chapter. Clicking on this icon enables a ZIP file to be downloaded which, once compressed, provides a set of files whose contents are the series relating to each of the tables making up the chapter.

FACILITIES FOR DOWLOADING CSV FILES RELATING TO THE SERIES OF EACH OF TABLES OF THE BOLETÍN

Access can be gained through the contents of the Boletín to a series of CSV File: Link in a new window icons featuring alongside the description of the tables making up the various chapters of the Boletín. These icons allow a CSV file to be downloaded which contains the full time series relating to the table. Once this file is on the user's computer disk, a double click on its name will enable it to be directly downloaded onto an EXCEL spreadsheet.

NOTE: RECOMENDATIONS FOR VIEWING CSV FILES

CSV files have been devised using the following numerical punctuation symbols:

  • decimal points: .
  • to separate thousands: none
  • to separate lists: ,

They may therefore be viewed correctly if this configuration is defined in the Windows control panel (regional configuration).

If the regional configuration is different (as is usually so, for example, in Spain, where the symbols , . ; are used in the three foregoing cases), the CSV files can be viewed correctly on an Excel spreadsheet. It may be necessary to use the Assistant for converting text in columns from the Data menu of Excel or some other procedure controlled by the user. Further, if the file contains data with decimal figures, it will have to be edited to change the field separator and the decimal point separator before opening it with Excel.

BACK