Creating an Import Format (Delimited File / Excel)

The file does not contain the VAT number of the declarant, the statistical period, or the flow

Creating an import format for a delimited file.
The delimiter in this example is ";".

ⓘ This guide is also valid for creating an import format for an Excel file.

Display of the CSV file in Excel.

Import Format

Display of the CSV file in Notepad++.

Import Format

To create an import format, use the "Import" menu, then select "Import Format".

Import Format
Import Format
Import Format
Import Format

Since the file does not contain information about the declarant's VAT number, the statistical period, or the flow, the import type to choose is "Declaration".
For file type, you must choose "Text".
For text type, choose "Delimited".
For delimiter, choose ";".
The field "Headers/Lines to ignore" defines the number of lines to skip during import (headers).
Since the file contains one header line, the number of lines to ignore is "1".

ⓘ This guide is also valid for creating an import format for an Excel file.
Import Format
ⓘ Launch the wizard to define an import format.
Import Format
Import Format
Import Format
Import Format
Import Format

Click "Save" to save the changes made in the import wizard.

Import Format

Click "Save" to save the import format.

ⓘ See File Import (Simple Import) for how to use the created format.