Sonbola SONBOLA

From Excel to Sonbola Web: prepare your data before importing

Moving an untidy spreadsheet into accounting software can carry the confusion with it. Start with the right template and fields, then review a sample before importing the full list.

What does this guide cover?

This guide covers preparing master data and the import flow in Sonbola Web setup. The setup flow includes item, contact and account templates, reads xlsx, xls and CSV files, and provides column matching and a preview. Importing a customer list does not migrate every invoice, payment and historical transaction from another program.

Use the template downloaded from your account. A free stocktaking worksheet or a template from another edition is not the import template.

Before uploading: four useful checks

  1. Keep the original file and work on a copy. Give each column a clear heading.
  2. Review record identity and duplicates: does a repeated name refer to one record or two different parties? Do not merge solely by name.
  3. Preserve leading zeros in barcodes and phone numbers using text formatting in Excel. Review units and currencies rather than mixing them into one column.
  4. Separate master data from opening balances. Adding a customer name does not establish the correct debt balance.

Training example: barcode 001234 differs from 1234 when its zeros are part of the identifier. Check the value in the import preview, not just the spreadsheet cell’s appearance.

The import flow in web edition setup

  1. Open import from the relevant setup step and download its template. For contacts, select customers or suppliers for the list you want to enter.
  2. Fill a copy of the template and upload the file for reading.
  3. Review how file columns map to fields. Correct mismatches and check rows with errors or warnings.
  4. Select the duplicate-record policy available for this data type. Understand which records an update would change before selecting it.
  5. Review the counts of created, updated, skipped and failed records, then open sample records to check their values.

These steps concern web edition setup; details may vary with updates to your account. Try a small file in a training company first and check that your account and permissions expose the setup step. Do not upload again after an unclear result before checking records, to avoid duplication.

What comes after importing lists?

Read preparing opening balances to define the starting point and choosing a training or empty company before trying the process. Desktop users should follow their edition’s instructions and confirm its template with the team; the steps above concern the web edition.

Content reviewed: 5 October 2026. Examples are for training.

Try Sonbola on your own work

Start a free 14-day Sonbola Web trial in your browser, or download the Windows version and try it for 30 days or 500 invoices, whichever comes first, with no payment card.

Or message us on WhatsApp, download the Windows version, or see pricing.

Free Excel product lists for your shop

Explore furniture and clothing starter lists in Excel and CSV. Preview the items, edit your copy and read the preparation guide before importing into Sonbola.