Intrastat - technology and technicalities

Intrastat CSV generator tool

A simple way of preparing a Comma Separated Variable (CSV) file is to use the CSV generator tool, a pre-prepared Excel workbook that is available for download.

The file includes the following worksheets:

  • An introduction.
  • Help files for trader and agents
  • Trader Excel spreadsheet
  • Agent Excel spreadsheet. The agent CSV file has two header rows with subsequent lines for data

CSV generator tool.

Preparing a file

Using the help file and the example worksheet, copy your data onto the example.

Saving a file

Having prepared your file, you may prefer to save it as an Excel file (XLS), then as a CSV file. Alternatively, you can save it as a CSV file (this is a save option in Excel). It is slightly easier to correct errors in an Excel file than a CSV file.

Submitting a CSV file

To upload a CSV file, you should first log on to the Intrastat application. Once in the main menu, click on the "CSV file upload" button. Either enter the path and complete the file name (including .csv) of the CSV file you wish to submit in the input box, or use the "browse" button to bring up a choose file dialogue box to locate and select the required CSV file. Once the file is selected, click the "submit" button to upload the file.