Help with CSV files

Creating CSV files for importing to Brightpearl

Some processes in Brightpearl require you to import a CSV file.

This is a "Comma Separated Values" text file, which can be made using any spreadsheet program, or even a text editor like Notepad if you really need to.

The commas define the columns, so the following CSV would be a 2 row, 3 column spreadsheet if opened in Excel:

Item name,Item SKU,Item Quantity
RFG Speaker System,RFGS004456,10

Files can be stored as a CSV by selecting this format when saving.

How to convert a file to CSV on a PC

  1. Open your spreadsheet file (typically a ".xls" or ".xlsx" file) in your spreadsheet program (e.g. Excel).
  2. Go to File > Save as.
  3. Choose the type as CSV.
  4. If given options to configure the format of the output file, use:

    Character set: Unicode (UTF-8)
    Field delimiter: ,
    Text delimiter: "

  5. Click save and check the newly created file has a ".csv" file extension. If you are using Windows you may have to enable the display of 'file extensions for known file types'.

You can then import this file into Brightpearl.

How to convert a file to CSV on a Mac

Macs produce CSV files in several different formats, none of which currently import successfully to Brightpearl.

In order to import your file, you will need to upload it to Google Sheets as a spreadsheet then download it again.

This will give the file all the necessary hidden data required by Brightpearl to read it when it is imported. 

Have more questions? Submit a request