Help / Bringing your data in

How do I import my supplies from a spreadsheet?

Go to Admin, then Import. Choose Supplies and contracts and pick your file. You can use the template, or your own spreadsheet: we match the usual column names, such as MPAN, EAC, CED and Unit rate.

Check the file. Nothing is saved yet. You see how many rows are ready, how many companies and supplies will be added or updated, and every problem by row and column.

When you are happy, press Import and press again to confirm. Large files import in batches with a progress bar; 5,000 rows takes about a minute.

More on bringing your data in

• What columns does an import need?
• Why was an MPAN refused?
• How are dates and money read?
• What if I import the same file twice?
• Can I import past commission?

Not answered here? Contact us.