When working with products and suppliers in prduct, Excel is often the easiest place to gather and update your data. Many of our users start in Excel – and that’s completely fine!
Below you'll find guides and tips to help you:
get started with importing and exporting
update multiple products at once
review and clean your data before uploading
1. Importing and exporting – pull data out, and push it back in
What’s it useful for?
If you want to make changes to many things at once – e.g., prices, names, or descriptions – it's easy to export all your data, edit it in Excel, and then import it back into prduct.
How to do it:
Click Export in prduct – you'll get an Excel file (CSV). See more here.
Open the file and make your changes.
Save the file (as CSV – this means "comma-separated file").
Go back to prduct and click Import.
Important: Do not edit the ID column – this tells the system which product is which.
2. Review and clean your data – tidy up your table
What’s it useful for?
Sometimes there are small issues like extra spaces, incorrect capitalization, or empty fields. These can cause errors when uploading.
Useful Excel tricks:
Remove extra spaces:
=TRIM(A2)Make everything uppercase:
=UPPER(A2)Check if something is missing:
=IF(A2="","Missing","OK")Find duplicates: Use Excel’s "Conditional Formatting" → "Highlight Duplicates"
3. Combine columns – e.g., name and variant
What’s it useful for?
You might want to create a column where the product name and color appear together, like “Chair – Black”.
How to do it:
In a new column, write: =A2 & " – " & B2
You’ll get: “Chair – Black”
4. Look for specific values – and show a message if missing
Example:
If you want to check whether a cell contains "yes" and show a message if not:
=IF(B2="yes","Approved","Needs review")
5. Fetch data from another sheet
What’s it useful for?
If you have a list of suppliers in one sheet and products in another, Excel can automatically match the correct supplier to each product.
How to do it:
Place your supplier list in one sheet (e.g., Sheet2).
Use the formula:
=VLOOKUP(A2, Sheet2!A:B, 2, FALSE)
6. Filter your data – quickly find what you need
What’s it useful for?
When you have many rows, filters help you easily view:
All products with a missing price
Only products from a specific supplier
Products with errors or missing data
How to do it:
Select your column headers
Go to the Data tab and click Filter
Use the arrows on each column header to sort or filter
Tip: You can combine filters – e.g., show only products from “Supplier A” where the price is missing
7. Split data – e.g., dimensions like "100x200 cm"
What’s it useful for?
Sometimes information is in a single column – but it's easier to work with when split into separate ones.
For example:
You have a value like:
100x200 cm
And you want to split it into:
Length | Width | Unit |
100 | 200 | cm |
How to do it in Excel – step by step:
Select the column with the measurements (e.g., 100x200 cm)
Go to the Data tab → choose Text to Columns
Choose Delimited → click Next
Check "x" and possibly also "space" (if the format is like "x200 cm")
Click Finish
Your data will now be split into two or three columns:
First column: 100
Second column: 200
Third column (if there's a space before the unit): cm
Tip: Once your data is split, it's much easier to search, filter, and analyze – and especially to import into prduct and other systems.
8. Checklist before importing to prduct
Checklist item | Why it matters |
Are all fields filled in? | Otherwise something will be missing in prduct |
No extra spaces? | Otherwise data might not match correctly |
Saved as CSV? | This is the format prduct accepts |
IDs unchanged? | Otherwise the system won’t know what to update |
You're always welcome to contact us at support@prduct.com or via the chat in the lower right corner – we’d rather help once too often than once too little.