Excel Tips & Tricks: How to fix up your PriceFile before upload

If you work with Price Files regularly in Burdi, you’ll know that a clean, well-structured Excel file makes all the difference. A few small formatting issues — like hidden spaces, merging cells, inconsistent headers or incorrect GST settings — can cause upload errors, messy product data, or time-consuming fixes later on.

In this article, we’ll walk you through practical Excel tips and tricks to tidy up your Price File before uploading it into Burdi. Whether you’re importing a supplier list for the first time or updating an existing file, these simple steps will help you avoid common mistakes, speed up the upload process, and ensure your pricing data comes in accurate and ready to use.

1. Quickly expand column

Double click the line to the right of the letter 

2. Deleting a Whole column

Select the column's letter, right click, delete

Deleting multiple columns in one go 

Hold down shift, Select the column letters, right click, delete

3. Same value for all column cells

Type in value, double click green box in right corner

4. Merging 2 cells into one 

Sometimes, suppliers split descriptions up into 2 columns. It is good practise to keep both. Use the CONCAT function to merge the two cells.

Formula: =CONCATENATE(B1," ",C1) 

• Related Articles

• Why Won't my Price File (price book, product list) upload?

  Why Won’t My Price File Upload? Uploading your price file (also known as a price book or product list) into Burdi is usually quick and easy — but sometimes the upload can fail or get stuck. If your file won’t upload, don’t stress. In most cases, it ...

• I Haven't Set My Supplier up yet, Can I Still Upload a Price File?

  Not yet — you’ll need to set up your supplier in Burdi before you can upload a price file. Price files are linked directly to a supplier, so Burdi needs the supplier created first to know where the products belong. How Do I Set Up a Supplier? In ...

• Where Do I Upload a CSV File?

• how can I get a Pricefile from Reece?

• What Information Is Required For a CSV Upload?

  When uploading a price file (product list) into Burdi, your CSV must include the correct columns so Burdi can successfully create or update products. Below is a breakdown of the required fields and what values Burdi accepts. Required CSV Fields ...