✅ What’s New?
We’ve made the data upload experience even smoother with a few exciting new features:
New “Import” Button in the Top Navigation Bar – Quickly launch from anywhere.
Full-Screen Interface – Easier to view and manage files.
Multiple File Uploads – Upload several documents at once.
Real-Time Feedback – See what succeeds or fails, right away.
Detailed Success Screen – Shows records created, updated, and linked.
Downloadable Output – Get a file summary with both success and error details.
In just a few simple steps, you can now upload data from your Excel spreadsheet or internal software into Matrak. This feature is especially useful for updating bulk records quickly and efficiently. Read on to learn more!
How to set up your file correctly
How to set up your file correctly
In order for Matrak to process your data upload, you need to make sure your file is set up correctly - the minimum columns required are the material 'ID' and 'Record Type' columns.
You can also add Qty and Suffix columns which is super handy for bulk updates, as well as Description columns and Linked columns.
Note: To ensure the upload works, your file must include 'ID' and 'Record Type' columns. You can use this basic Excel file template with pre-populated ID and Record Type column headings linked at the bottom of this article.
Below, is an example project where a company is updating the status of their materials from 'Not started' to 'Manufacturing', and also linking these materials to a stillage.
How to format dates from files
How to format dates from files
When importing Excel (.xlsx) files into Matrak we support most date format. To format your dates:
1. Right click the column header
2. Select format cells
3. Choose a date format
Tip: Matrak supports most date formats in your reports, allowing you to upload and manage your data, regardless of the date format used.
Please be aware that if you're dates are not written in a correct date format you wont be able to upload your data until they are correctly formatted.
Examples of acceptable date formats:
ISO 8601 (International Standard)
YYYY-MM-DD(e.g., 2024-06-19)
Common European Formats
DD-MM-YYYY(e.g., 19-06-2024)
Common Asian Formats
YYYY/MM/DD(e.g., 2024/06/19)
Common US Format
MM-DD-YYYY(e.g., 06-19-2024)
How to upload a .CSV or Excel file to update records in Matrak
How to upload a .CSV or Excel file to update records in Matrak
Great, I've set up my file, and everything looks good, now what?
1. Locate the “Import” Button on the Navigation Bar
You can now launch the import from anywhere in Matrak via the Import icon in the top nav bar. Alternatively, go to the Custom Reports page and click ‘Import’ in the toolbar.
2. Select or Drag Multiple Files
You can drag and drop one or more files (.xlsx or .csv) into the import window.
Or click Browse Files to select from your computer.
You’ll see a progress bar for each file, so you know what’s uploaded and what’s not.
3. Preview the Information
Once you drag and drop files into this screen, you will get a detailed page for each file about
Number of Records Created
Number of Records Updated
Number of Records Linked
A download button allows you to download the generated file and see the results
A remove button allows you to remove the file from the import list of documents
4. Import the data
Once everything confirm, click import all button and you're good to go.
How to Fix Errors During File Upload
How to Fix Errors During File Upload
Sometimes, you may run into errors when uploading your file to Matrak. Don’t worry—these are usually easy to fix! If your upload contains issues, Matrak will show an on-screen error message and automatically generate a downloadable file that highlights exactly what went wrong.
✅ Next Steps to Resolve Errors
1. Review the Error Messages
Read the on-screen error summary.
Download the generated error file(s), which contain specific details about which rows failed and why.
2. Correct Your File
Open the downloaded file and check the highlighted errors.
Common issues include:
Missing ID or Record Type columns
Spelling mistakes in the Status column (e.g., using Delective instead of Defective)
Using a Status that hasn’t been set up in your material list
3. Re-upload the Corrected File
Once you’ve made the necessary fixes, import the updated file again.
Matrak will process the file and update any rows that are now valid—no need to re-upload everything from scratch.
Pro Tips
Common Error | How to Fix It |
ID column is missing | Add a valid ID column and try uploading again. |
Record Type column is missing | Include a valid Record Type column to proceed. |
Invalid Status value: Delective | Correct the spelling to match the valid list of statuses. |
Invalid Status value: Defective | Make sure Defective is set up as a valid status in your material settings. |
By following these steps, you can quickly fix any upload issues and get your data into Matrak without hassle.