Companies can be imported from a pre-configured Microsoft Excel value (XLS) file. This file easily adds or appends a list of new companies. Please be aware of the high risk of unintentionally overwriting previous company settings or fields if you use this method to append.
Steps for creating an import file:
- Export an Excel file from the System Administration Company list to use as the template for your import. You will find a Quick Select option in the Display Options to export all columns. By selecting all columns, you include both the required and most common data columns used for the company import. We recommend exporting at least one company as an example for the different data fields. You can delete that line from the spreadsheet once you no longer need the example before the import
- Modify the data in Excel. Copy/paste is your friend
- Save the completed file as an Excel Workbook file
The format of the Excel file must be used as-is without modification to any data cell formatting prior to the import. It must also contain the following required fields:
The import process will take you through the following steps.
- Prompt for the Excel file to import
- List the companies available to import. YOU MUST select the checkbox by each company you want to import
- Confirm the completion of the import with a list of the imported companies