✅ What’s New – 15th July Update
We’re excited to introduce the new and improved Import Page! This update makes bulk data uploads into Matrak faster, smoother, and more flexible than ever.
Progress Persistence: Your uploaded files now stay put—even if you navigate away or close the tab. No more waiting on the page while your upload processes in the background.
Multiple File Uploads: Upload several documents at once.
PDF Support in AI Import: Upload PDF files directly into the AI Import List View. This includes support for packing lists, construction drawings, and project schedules in PDF format.
Custom Template Selection (Coming Soon): Select the config template you want to use before upload—no need to stick to strict formatting. Get more control over how your data is analysed.
Import History: A new section on the pre-import page shows a log of all import activity:
See who uploaded what, when, and to which project
Search and filter past imports with ease
Quickly access detailed results via direct links
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 use the Import Page upload the data？
How to use the Import Page upload the data？
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 into the Import Page. Or click Browse Files to select from your computer.
Currently supported: .XLSX, .XLS,.CSV, and .PDF
You’ll see a progress bar for each file, so you know what’s imported and what’s not.
How to Use the Import History:
On this page, you can:
Search across batch names, uploader names, and projects.
Filter by status, project, uploader, or import date.
Click a batch row to jump to the corresponding List View with the batch preloaded.
3. Preview the Information
Once uploaded, the document status shows as Analysing… , which means AI is analysing the document and extracting data
Once the analysis is complete, it will display which configurations this file is using under the Template column:
Number of Records Created
Number of Records Updated
Number of Records Linked
Each uploaded file will also show a real-time status:
Analysing: The file is being analysedReview this file: Issues were found and need your confirmationReady to Import: No issues found—file is ready for action
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. Set Import Preferences
Click the Settings button to adjust global import behaviour:
Toggle overwrite matching values
Choose to use US date format
Enable or disable manual review and approval before importing
This ensures consistency and control over all import actions.
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.
You can download the processed output, fix errors, and re-upload the document if needed.
You can remove any in-progress or problematic documents.
You can choose to ignore specific sheets in Excel files to avoid importing irrelevant data.
✅ 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.
Basic Excel File Template: