HMAG60855 - Excise Movement and Control System: EMCS searches: downloading search results

Search results can be downloaded to a comma separated variable (CSV) file that can be viewed in excel. A dialogue box appears on screen asking whether you want to ‘open’, ‘save’ or ‘cancel’. If the open option is selected, you can also save the information within a spreadsheet. If the save option is selected, you must define the location where the data is to be saved.

One of the implications of saving the data as a CSV file is that when the software finds a comma, it puts the next block of data into the next field, which appears in a column. This might need fixing by you depending on the data analysis to be performed.

Example

ARC, Consignee, Date

11GB123456718910111213141, J Smith, & Sons, 20/11/2011 will appear in a CSV file as:

ARC Consignee Date
11GB123456718910111213141 J Smith & Sons 20/11/2011

Whilst UK names tend not to have commas in such positions, other MS may have additional columns for some records. You may need to manipulate the data for this reason. A simple answer is to place the cursor on the field where the split data is (ie in this example ‘& Sons, select the ‘edit’ function on the toolbar, select ‘delete’ then select “shift cells left” which moves 20/11/2011 into the cell where ‘& Sons’ was previously shown. If there are many instances of this, you may wish to sort or filter the data first.