Smart Import – AI Column Mapping

Import items, customers, vendors, or chart of accounts from your own Excel or CSV file. LocalizeBook matches your columns to its fields automatically (Smart Import).

Last updated: Nov 18, 2026

Overview

Smart Import lets you import data straight from your own Excel or CSV file — you don't need to copy it into the LocalizeBook template first. When the file isn't the template, LocalizeBook reads your header row and matches your columns to its fields automatically, for example:

Column in your file

LocalizeBook field

Product Name

Item Name

SKU

Item Code

You check the matches, change anything that isn't right, and import. The file itself doesn't need to change.

Smart Import works with Import Items, Import Customers, Import Vendors, and Import Chart of Accounts. Other imports, such as Import Price Levels, still need the LocalizeBook template. If you choose a different file there, LocalizeBook shows "The Excel template is out of date. Please download the latest template."

How to import with Smart Import

Step 1: Choose your file

  1. Go to Accounting > Bulk Operations > Import Data.
  2. Choose the import, for example Import Items.
  3. Click Browse File and choose your own file (.xlsx or .csv).
  4. Because the file is not the template, the Match your file screen opens (for example "Import Items · Match your file") with the message: "This file isn't the Import Items template. Match its columns here instead, the file itself doesn't need to change." The screen has three steps: File, Columns, and Values. Use Next and Back to move between them.

Step 2: File – sheet and header row

  1. Choose the Sheet to import if your file has more than one.
  2. Check the Header row. LocalizeBook finds it automatically (Auto). If it is wrong, click the number of the row that holds your column names.
  3. Rows above the header row are skipped. The number of rows found is shown, for example "Items: 2 · rows 2-3".

Step 3: Columns – which column fills each field

  1. LocalizeBook shows how many columns it matched, for example "Matched 4 of 4 columns automatically".
  2. Fields are grouped (for example Item, and Price & Stock). Required fields are marked with *.
  3. For each field, check Comes from. You can choose a different column, choose One value for all rows, or choose Leave empty (the field is not imported).
  4. The Values column shows sample values from your file, and Check shows how many rows have a value.
  5. Every required field must come from a column or have one value for all rows. Until then, a message lists the missing fields, for example "Choose where these come from: Cost, Asset Account, COGS, Revenue Account".
  6. If no column in your file matches a field that uses fixed values, LocalizeBook may set one value for all rows. For example, if no column contains the item types STOCK_PART or SERVICE, one item type is set for all rows, and you can change it.
  7. Remember this mapping is ticked by default. The next time you import a file with the same columns, your mapping is restored automatically.

Step 4: Values – your words to ours

  1. For fields that use set values (such as item type, item group, or unit), match the words used in your file to the values in LocalizeBook. You can choose an existing value, or create a new one where offered.
  2. Rows with a problem, for example an empty required value, text where a number is expected, or a number below zero, are listed. They also appear on the error sheet after you click Continue.

Step 5: Continue and import

  1. Click Continue. Your rows go through the same checks as a template file, and the import runs as usual.
  2. Optional: click Download as Template to save the matched rows in the LocalizeBook template, so you can check or change them in Excel and import that file later.

Tips

  1. Use a clear header row with one name per column.
  2. If a column has many different values, check that it is the right column for the field.
  3. Very large files may be over the import limit. Split them into smaller files.
  4. If the file cannot be read, save it as .xlsx or .csv and try again.

Common questions

Do I have to use the LocalizeBook template to import items? No. For Import Items, Import Customers, Import Vendors, and Import Chart of Accounts, you can import your own Excel or CSV file. LocalizeBook matches the columns for you.

Which file types does Smart Import accept? Excel (.xlsx) and CSV (.csv).

Why can't I click Next on the Columns step? A required field has no source. Choose a column for it or set one value for all rows. The message at the bottom lists the missing fields.

Will LocalizeBook remember my column matches? Yes, if Remember this mapping is ticked. A later file with the same columns is matched the same way.

Does Smart Import change my file? No. Your file stays as it is. You can optionally download the matched rows as a LocalizeBook template.

Why do I see "The Excel template is out of date. Please download the latest template."? You chose a file that is not the current template on an import that does not support Smart Import, such as Import Price Levels. Click Download Template and use the new template.

Related Articles