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
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.