Import from spreadsheet

Introduction

 To import a spreadsheet the file needs to be in either .CSV or .XLSX format.

1. Click the magnifying glass to browse to a spreadsheet containing the businesses VAT information.

2. Once the spreadsheet loads, right-click in any cell and select which box you’d like the cell mapped to. Only numeric cells can be mapped with empty cells being treated as zero.

The Import option will be disabled until at least one box has a mapping.

3. The mappings will be stored after running an import. If these need to be changed, either remap the cells or select Reset Mappings to remove all stored values.

It is possible to map cells within different sheets of a spreadsheet.

The following software should allow files to be saved into .xlsx format:

• Microsoft Excel 2007 onwards
• Google Docs
• Apple numbers
• OpenOffice
• LibreOffice