Normalize a Customer Import Sheet

A single customer import sheet repeats customer, plan, invoice, product, and account-manager facts in every invoice-line row. Normalize by dependency: key, whole key, and nothing but the key. The common trap is keeping the wide sheet as the operational table because it matches the import file. That makes every future update a multi-row hunt. Find row grain One row in the import is one invoice line, not one customer or one invoice. This matters because customer_name and plan_name do not depend on the invoice-line key. They are repeated context, not line facts. Separate parents Create customers, plans, products, and account_managers…

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in