Importing an Excel file

The Excel file that can be downloaded from our site contains two sheets.
Download sample Excel file

Exemple fichier Excel

The first sheet can be used for data encoding.

Exemple fichier Excel

The second sheet explains the contents of the different fields depending on the type of declaration to be completed.

Exemple fichier Excel
Download sample Excel file

Ecran de connexion
⚠ It is not possible to edit/delete columns in the Excel file!

Importing the file into Idep.Web

In this example, the third-party reporter "Jossa Tiers Declarant" imports a report for his client "Statec".
This information is displayed at the top of Idep.Web.

Exemple fichier Excel

First it is necessary to create a declaration.
Click on "Create a declaration".

Import fichier

Click on "Create a declaration" to create a new declaration.

Import fichier

You must choose the correct import format corresponding to the layout of your file.
For this example the format name is "Excel Statec".
Import fichier

Click on "File name" to select the file you want to import.

Import fichier

Click on "Upload file" to load the file in memory.

Import fichier

Select the sheet containing the data to be imported.

Import fichier

Click on "Start the import" to start importing the data.
Import fichier

Idep displays the message "In progress" when processing the file.

Import fichier

If no error is detected you will get the message "Succesful".
Click on "Successful" to see the details of the import.

Import fichier

If errors were detected you will get the message "With errors".

Import fichier

Click on "With errors" to see the details of the import.

Import fichier

More details are displayed by clicking on the sign "+".

Import fichier

Click on the declaration number to see all the eroneous lines or a line number to see the details of this line.

Import fichier

This line contains an incorrect destination country.
Then click on "Save, then next" if the declaration contains several errors.
If the declaration contains no more errors click on "Save and back" to display the line overview.

ⓘYou must correct all errors before being able to submit the return.

Import fichier