Open app

Exporting chip sample data and supplier averages to Excel

Updated November 2026 · Features

Exporting chip sample data and supplier averages to Excel

Sooner or later the numbers have to leave the system: a quarter of one supplier's loads for a supplier meeting, a trial write-up, a cost model kept in a workbook. Copying rows off a screen does not scale.

In The Chip Lab, the pages that show your samples and their averages can also download them as a spreadsheet, narrowed by the same kind of choices you use to search.

The Samples grid filtered to two suppliers and a date range, with the download menu open

Where to find it

Under Chip Data in the menu, View Sample Data opens the Samples grid and View AVG Sample Data opens Aggregate Sample Data. On both, the More actions button at the right of the toolbar holds the downloads. How to narrow a search — dates, suppliers, specifications, data conditions — is covered in Finding samples.

What you can download

From the Samples page:

  • Download Samples (.xlsx) — the page's samples as rows of a spreadsheet.
  • Download Supplier Average (.xlsx) — the samples averaged per supplier, specification and sample purpose, with how many samples each average is built from.

From Aggregate Sample Data, the download follows the period you picked: Download Daily Average (.xlsx), Download Weekly Average (.xlsx) or Download Monthly Average (.xlsx), one averaged row per supplier, specification and sample purpose for each period of the year.

Files are Excel workbooks (.xlsx), named after your mill, the date and what they hold — for example Weekly Average Samples — so a folder of exports stays readable. They open in Excel and in other programs that read .xlsx files, and the plain layout — one header row, then one row per record — is easy to bring into other systems.

Narrowing what you download

There is no separate export screen to set up. On the Samples page, choosing suppliers, a date range, specifications and data conditions narrows what is downloaded:

  • By supplier — pick one supplier, several, or a supplier group, supply type or product form. A supplier login is offered only the supplier groups it can view.
  • By date range — the range in the toolbar, or the most recent N per supplier with Per-supplier limit.
  • In bulk — leave the suppliers open and the file holds samples from across your suppliers.

A data condition on combined fractions — fines and pins together, say — adds a (sum) column to the file. The samples download also follows the On hold condition, so you can pull the loads still waiting for review.

On Aggregate Sample Data, you pick the suppliers, specifications, year and period for the averages you download.

An excerpt of a downloaded workbook: supplier, specification, date and purpose, the fractions, and a combined fines + pins column

What is in a row

In the samples download, each row starts with the supplier, its product form, the specification, the sample date and the purpose. The measured values follow, with generated values such as recoverable fiber where your specifications calculate them, and the quality score and rating, along with the sample's own details, such as its test ID where it has one. An averages file includes the number of samples behind each row.

Benchmark suppliers before you download

The Supplier AVG tab beside Samples shows the supplier averages on screen first. Press Load supplier averages and each supplier's averages for the current filter line up under your specification targets, with Samples Taken beside them and an Averages & Totals row across the whole set. Values outside the specification are red and the quality column is colored by rating, so the suppliers that need a conversation stand out before anything leaves the system. Where delivery data is available to you, Tons Delivered and % of Deliveries are added to each supplier.

Supplier averages for the window, with sample counts, spec targets and an averages row

Who can use it

Everyone who can see your mill's samples can download them, and a download holds only samples that person is allowed to see. Someone with Contributor access enters samples rather than reading them, and does not have these pages.

Downloads are made by the person who wants them, from the screen. If you are looking for a direct, automated feed into another system, talk to The Chip Lab team about what fits your mill.

Read next

Have feedback or a question about this article? Let us know.