Match columns
After upload you choose which file column fills which Biznsbook field. Most of it is done for you.
Match your columns
- After upload you land on Match columns. Each column shows example values from your file.
- Biznsbook has already matched what it recognises, using field names, display names and known alternative spellings. If you imported a file with the same headings before, your earlier choices are applied whatever the column order.
- Change a column's target in its dropdown, or choose Skip to ignore the column. Required and key fields are marked. The key field is what Add or update and Update existing only use to find existing records.
- Watch the warnings: a required field with no column, or two columns mapped to the same field. Continue is blocked for duplicate targets and asks for confirmation if a required field is skipped.
- As you change a dropdown, the first 50 rows are re-checked and problems appear straight away.
- Tick Only show columns that need attention to focus on the rest, then click Continue.
Skip or leave blank
A skipped column means "this field is not in my file, leave it alone". A mapped column with an empty cell clears that field on update.
Learn more about Biznsbook Data Import on biznsbook.com.