Formatting import files

When it comes to importing your data, such as orders, customers or products, into Brightpearl, you're going to need it formatted in a way that Brightpearl recognizes.

Formatting dates for import

When importing data, dates will need to be formatted in a specific way so that Brightpearl is able to read them correctly.

Data Type Format Required
Date / Time YYYY-MM-DD hh:mm:ss

How to format dates in Excel for imports

  1. Click on the column header to select the entire column. In this case it's column H, so click on the grey box with H in it. The whole column will be highlighted.
  2. Right-click anywhere on the highlighted area to display the menu.
  3. Select Format cells.
  4. In the displayed window, in the Number tab, select Custom from the category list on the left.
  5. If the format you need is already listed it can be selected. If it is not listed use the Type field above to enter your own, "yyyy/mm/dd hh:mm:ss".

    Note: The date only format can be found under the Date category.


  6. Once you have selected or entered the format you need, click the OK button.
  7. Save your Excel file.

You are now ready to import it into Brightpearl.

Have more questions? Submit a request