This article explains which files you can download from the Data Hub, what each file contains, and what one row represents in each CSV file. It helps you select the right file and work with the data in a spreadsheet.
01/ Introduction
The Data Hub provides two file types:
- PDF: Contains the full report, with one PDF per report. Use this format to read or share a complete report.
- CSV: Contains data organised into rows and columns. Use this format to compare suppliers or reports in a spreadsheet.
When downloading multiple files at once, the Data Hub combines them into a ZIP file.
- Side-panel download: data-hub-reports-YYYY-MM-DD.zip
- Export: DataHub_Export_YYYY-MM-DD.zip
Inside both ZIP files, each PDF is named using the supplier's organisation ID, report ID, module and report date.
For example: DataHub_01-XXXXXXXXXXXX-X_40-XXXXXXXXXXXX-X_incheck_2026-06-01.pdf
02/ Prerequisites
No additional prerequisites. Anyone with access to the Data Hub can follow this guide.
03/ Steps
- Find the downloaded file in the table below.
- Check the One row means column before counting, sorting or comparing rows in a spreadsheet.
- Open the CSV file in your spreadsheet program using a semicolon (;) as the separator.
04/ Data Hub File Overview
The table below explains where each file comes from and what one row represents.
| File | Where it comes from | One row means |
|---|---|---|
| InCheck Report (PDF) | Supplier table, side panel or Export with PDF | Not applicable. One PDF contains one full InCheck Report. |
| incheck-report-(supplier name)-(report ID).csv | Download CSV from the supplier table or side panel | One row summarises one InCheck Report. |
| InCheck_Export_YYYY-MM-DD.csv (side-panel ZIP) | Several InCheck Reports selected in the side panel, CSV | One row per selected report of that supplier. |
| InCheck_Export_YYYY-MM-DD.csv (Export ZIP) | Export with CSV | One row per supplier, containing that supplier's latest InCheck Report. |
| incheck-report-(supplier name)-(report ID)-ci.csv | Chemical Inventory (CSV) from the supplier table or side panel | One row per product in that chemical inventory. |
| InCheck_CI_Export_YYYY-MM-DD.csv (side-panel ZIP) | Several InCheck Reports selected in the side panel, Chemical Inventory (CSV) | One row per product per selected report. |
| InCheck_CI_Export_YYYY-MM-DD.csv (Export ZIP) | Export with CSV, for suppliers sharing their Chemical Inventory | One row per product from each supplier's latest InCheck Report. |
| ClearStream report (PDF) | Download PDF from the supplier table or side panel | Not applicable. One PDF contains one full ClearStream report. |
| clearstream-report-(supplier name)-(ClearStream ID).csv | Download CSV (parameters) from the supplier table or side panel | One row per tested parameter in one ClearStream report. |
| RCA/CAP (PDF) | RCA/CAP (PDF) from the supplier table or side panel | Not applicable. One PDF contains the RCA/CAP for one ClearStream report. |
05/ Columns in the CSV Files
InCheck summary CSV
The InCheck summary CSV includes:
- Supplier Name
- ZDHC AID
- Report ID and Report Date
- Inventory Type
- CtZ counts: Total, Foundational and Progressive
- For Level 1, Level 2, Level 3, Conformant, Registered and Unregistered:
- Percentage by count
- Percentage by weight
- Weight in kg
- Count
Chemical Inventory CSV
The Chemical Inventory CSV contains:
- Organisation Name and ZDHC Reference ID
- Inventory ID, Inventory Month and Inventory Type
- Address
- Product ID and Product Name
- Formulator
- MRSL Version
- Certification Body and MRSL Level
- CtZ Conformance and Certificates
- Is Commodity
- Weight and Unit
ClearStream CSV (parameters)
The ClearStream CSV includes:
- Supplier details: Name, reference ID, discharge type, average wastewater generated per day, sector, materials and processes.
- Laboratory and sampling details: Laboratory name, test reference number, Test Report ID (TRID), wastewater and sludge guidelines, reporting period, sample date, reporting date, sample location and disposal pathway.
- Parameter information: Parameter Type, Parameter Name, High Level Score, Total Points Available, ClearStream Evaluation and Percentage of Total.
06/ Tips & Notes
Tip: If all CSV data appears in one column, import the file instead of opening it directly. In Microsoft Excel, go to Data > From Text/CSV and select Semicolon as the delimiter.
Notes:
- Data Hub downloads and exports are available in PDF or CSV format. Exporting directly to Excel is not currently supported.
- Verified InCheck Reports are available as PDFs only. There is no Verified InCheck CSV, and Verified InCheck data is not yet available in the Data Hub.
- Files contain only the data that suppliers share with your organisation. The Export function excludes Chemical Inventory data from suppliers who do not share this information with you.