The Data Import Wizard lets you bring all your clients or suppliers into QuickFile in one go, by uploading a CSV spreadsheet instead of entering them one at a time.
It imports contact details only. To bring in invoices, see Importing sales and purchase invoices.
Prefer a video walkthrough? Watch our How to Import Clients and Suppliers in QuickFile tutorial on the QuickFile Help Guides YouTube channel.
Your CSV file can contain any combination of the columns below. Include only the columns you have data for, in any order.
| Client column | Notes |
|---|---|
| Company Name | Required. |
| Address Line 1, 2 and 3 | |
| Town/City | |
| Postcode | |
| Country ISO Code | For example GB. |
| VAT Number | |
| Account Number | Your own reference for the client. See the note below. |
| Contact First Name | If you include contact details, supply all three together. |
| Contact Surname | If you include contact details, supply all three together. |
| Contact Email | If you include contact details, supply all three together. |
| Contact Telephone | |
| Trading Style ID |
Here is an example of a CSV file for clients, shown as a table. The first row holds the headings:
| Company Name | Address Line 1 | Town/City | Postcode | Account Number | Contact First Name | Contact Surname | Contact Email | Contact Telephone |
|---|---|---|---|---|---|---|---|---|
| Acme Plumbing Ltd | 1 High Street | Leeds | LS1 1AA | ACC-001 | Jo | Smith | jo@example.com | 0113 496 0000 |
| Brightside Cafe | 22 Mill Lane | York | YO1 7AB | ACC-002 |
Tip: Use the same names as the drop-downs for your headings, for example Town/City rather than Town. QuickFile then maps those columns for you. Columns that do not match are left for you to set on the mapping screen.
Important: Avoid commas in your spreadsheet values to prevent problems.
Please note: If you map the Account Number column for clients, QuickFile links your invoices to a client by its account reference. If no account reference is supplied, it uses the client name instead.
Click Account Settings on the top menu.
Click Import Data, then click Import clients.
Alternatively, you can go to Account Settings > All settings and click Data import wizard. This opens the Data Import Options page, where you can choose Import Clients or Import Suppliers.
On the Import Client Records page, click Choose file and select the CSV file on your computer.
Click Upload.
After the upload, QuickFile shows a short preview of your file with a drop-down above each column. Use the drop-downs to match each column of your spreadsheet to a QuickFile field.
Check the Mandatory fields shown at the top. A green tick means that field is mapped. Fields with a dashed outline are required only as a set.
Leave Ignore the first row in the CSV file ticked if your file has a headings row. It is ticked by default.
For each column that contains data, choose the matching field from the drop-down above it. Leave other columns as –.
Click Save to import your clients.
Please note: Only map the columns that contain data.
After you click Save, QuickFile shows a confirmation of how many clients were imported.
You do not need to worry about creating duplicate client or supplier profiles. QuickFile includes built-in duplicate prevention for imports.
The steps are the same, but choose Import suppliers from the Import Data menu. Only Company Name is mandatory on the supplier mapping screen.
The supplier drop-downs offer: Company Name, Address Line 1, 2 and 3, Town/City, Postcode, Country ISO Code, VAT Number, Contact First Name, Contact Surname, Contact Email, Telephone and Web Address. There is no Account Number column for suppliers.
The contact fields work as a set. Make sure Contact First Name, Contact Surname and Contact Email are each mapped to a column, then click Save again.
Map one of your columns to Company Name, then click Save again.
Choose the matching field from the drop-down above that column. Headings that match the field names exactly, such as Town/City, are mapped for you.
Importing invoices uses the client name only. Import your clients first, with their addresses, then import the invoices. See Importing sales and purchase invoices.
The supplier mapping screen has no Account Number column, so a supplier reference cannot be imported.
Moving to QuickFile from another system? Start with Importing data from another system for the whole picture.