Introduction

The purpose of this page is to outline the CSV format requested by Sopht for importing the client's employee count into the solution (headcount). This number is used to define "relative KPIs" that adjust certain metrics per employee.

Version of the document

CSV File Format

Character encoding: UTF-8 (without BOM)

The line separator is the character set CRLF: Carriage Return (carriage return) and Line Feed (line feed). The last line may or may not end with this separator.

The file must have a first "header" line reminding the names of the fields defined below.

Columns are separated by the character ,

Each value can be surrounded by double quotes “. If a value contains the character , it becomes necessary. If the “ character must appear inside a surrounded value, the character must be doubled.

For further details on the CSV format, see the RFC 4180.

You can remove optional columns altogether, or change the order of the columns, although the names of the columns must remain unchanged.

Employee count CSV

<aside> ℹ️

We process the data only once, so the data processed for a given date will not be modified later.

</aside>

File example

The file name should follow this format: “headcount_information_YYYYMMDD.csv” :

headcount_information_20240524.csv

Columns

Sans titre