Some ZDHC data exports are provided as CSV files rather than Excel workbooks. This article explains why and how to open a CSV file correctly in Excel on both Windows and macOS.

01/ Introduction

CSV is an open, standard format for exchanging structured data. It can be opened in Microsoft Excel and many other spreadsheet, database and data-processing applications.

ZDHC exports data as CSV rather than as an Excel workbook because CSV:

• Works with any application. Microsoft Excel, Google Sheets, Apple Numbers, database tools, business intelligence applications, and scripts and automated integrations can all read CSV files, so you are not dependent on one spreadsheet application.
• Keeps data separate from presentation. An export is meant to provide the underlying data, not formatting choices such as colours, fonts or formulas. This makes the data easier to reuse in other systems and processes.
• Has a simple, predictable structure. This makes CSV files suitable for automated processing, integrations and bulk data workflows, as well as manual analysis in a spreadsheet.
• Avoids unnecessary workbook complexity. Excel workbooks can include formulas, formatting, hidden sheets, macros and other application-specific features. These are useful for reports, but are not needed when the goal is simply to transfer data.

A CSV file does not define how Excel should display every value. When you double-click a CSV file, Excel automatically guesses the column separator, the decimal separator, whether a value is text, a number or a date, and the character encoding. These guesses depend partly on your computer's regional settings.

As a result, a correctly generated CSV file can appear incorrect when it is opened directly. For example, all data may appear in a single column, dates may be interpreted differently, identifiers with leading zeroes may be converted to numbers, or long numerical identifiers may be displayed in scientific notation. This does not necessarily mean the CSV file itself is wrong. It usually means Excel has incorrectly guessed the file's format.

CSV and Excel are not the same format. CSV is the exported data. An Excel .xlsx workbook is a tool for working with that data. Excel is one application that can read CSV files, but it is not the only one.

02/ Prerequisites

• No prerequisites — anyone with platform access can follow this guide.

03/ Steps

1. Open Microsoft Excel and create or open a blank workbook.

2. Go to the Data tab and select the option to import data from a Text/CSV file.

   

   

   

3. Select the CSV file you downloaded from the ZDHC Gateway.
   Excel shows a preview of the data before importing it.
4. Check the import preview. Confirm that each field appears in its own column, special characters display correctly, and numbers and dates appear as expected. Where Excel offers these options, set Encoding to UTF-8 and Delimiter to the one detected for the file, typically a comma or a semicolon. The correct delimiter can depend on the file and your regional settings.
5. Set the column type to Text for any column containing values that look like numbers but are actually identifiers, such as IDs, reference numbers, codes with leading zeroes, or long numerical identifiers, if Excel offers this option during import.
   This prevents Excel from changing the original value.

6. Select Load, or the equivalent import option, once the preview looks correct.
   The CSV data is now available in Excel.

   

   

7. Save the file as an Excel workbook if you want to add formatting, formulas, filters or additional worksheets: go to File → Save As and choose Excel Workbook (.xlsx). You can then work with it as a normal Excel file.

04/ Tips & Notes

Tip: Avoid opening a CSV file by double-clicking it. This lets Excel guess the file's structure before you can review it. Importing through Data → Text/CSV lets you check and correct that guess first.

Notes:

• If all your data appears in one column, Excel has likely selected the wrong delimiter. Re-import the file via Data → Text/CSV, then choose the correct delimiter in the preview.
• If special characters appear incorrectly, check that the file is being imported using UTF-8 encoding.
• If leading zeroes disappear from a value, for example, 001234 becomes 1234, Excel has interpreted the value as a number. Import that column as Text instead.
• If a long identifier displays as something like 1.23457E+17, Excel has interpreted it as a number and shown it in scientific notation. Import that column as Text instead.
• If dates change format, Excel has applied your computer's regional settings. Use the import method rather than double-clicking the file, and check the date columns in the preview before loading the data.