Prepare Destatis & Eurostat data for the Leontief calculator
Import data
Upload input-output tables from Destatis or Eurostat.
Embedded sheets of Statistical Report 2180200227005 (revision 2024, as of August 2025) β no file upload. Then choose sheet "81511-03"; start row, number of sectors and output row are detected automatically. The sheets keep the original German labels.
π Click to upload
Excel (.xlsx, .xls) or CSV file
π Click to upload
e.g. naio_10_cp1700 (symmetric input-output table, product Γ product)
π Data sources, current tables & licences
Procedure:download the tables from the source locally and upload them here. Uploaded files are processed only in the browser and not stored; only what you explicitly transfer to the databox is stored.
Destatis (Germany): Statistical Report "Input-Output-Rechnung" (EVAS 81511, Excel) at www.destatis.de β search for "Input-Output-Rechnung Statistischer Bericht". Sheet 81511-03 is required (domestic production, basic prices); final use is in the same sheet (columns BXβCI). Newer years have the same structure; the rows are detected automatically.
Database: GENESIS-Online, tables 81511-0005 (IO table from 2021) and 81511-0011 (persons employed). Older reports: Statistische Bibliothek.
Licence: Data licence Germany β attribution β version 2.0 (dl-de/by-2-0); source note "Statistisches Bundesamt (Destatis)", mark modified data as own calculation.
Eurostat (EU countries): dataset naio_10_cp1700 (symmetric IO table at basic prices). In the Data Browser filter country (geo), year, unit MIO_EUR and origin (stk_flow: DOM = domestic production, TOTAL = incl. imports), then "Download" β SDMX-CSV (or TSV), filtered data only. Choose "Data source: Eurostat" here.
Licence: reuse permitted with source attribution (dataset code, link, retrieval date); mark modified data. Data on countries outside EU/EFTA/candidate countries for non-commercial use only (Copyright notice).
Generic: own Excel or CSV tables with intermediate flow matrix (volumes) and output row.
Select sheet
Configure data structure
π‘ Important - new aggregation logic:
Intermediate flow matrix X: volumes (EUR million) are read from sheet 81511-03
Aggregation: volumes are summed, then technical coefficients are calculated
Sector names: are read from the 2 columns BEFORE the matrix (number + name)
Additional coefficients: sum volumes, then divide by total input
Final use: volumes are aggregated as a sum
Row in which the intermediate flow matrix starts
Column in which the matrix starts (e.g. column C = 3). Sector names are read from the 2 columns BEFORE it (A+B)
Row containing the output (for technical coefficients). Detected automatically for Destatis sheets (report 2022: row 90 in 81511-03).
Data overview
Matrix preview
Sector names
Aggregate sectors
Group sectors into a smaller, clearer matrix.
Current size:
No data loaded
Sector assignment
Drag and drop sectors into the target groups or use the dropdown menu.
Original sectors
β
Target groups
Aggregated matrix
Export for the Leontief calculator
Export the prepared data as CSV files.
π¦ Datenbox-Integration
Save matrix A and vector Y directly in the central databox - without CSV export!
Saves matrix A and vector Y directly - without CSV files!