Hello Johnmulholland.

Thank you for your purchase.

You can add URLs to cells using "string" type columns, and then adding values to cells like this:

<a href="http://www.google.com" target="_blank">Google</a>
<a href="http://www.yahoo.com" target="_blank">Yahoo</a>
<a href="http://www.amazon.com" target="_blank">Amazon</a>

so it looks like this:

Then, my advice would be to enable "selectbox" filtering, with "Exact filtering" enabled:

You can also hide the table before filtering, if you want.

When the user opens the page where the table is, they can select the product/item ID (which will already be linked to a new window for that item) and the table will filter showing only that result, so when they click on the ID in the table it will take them to a new page:

You can, of course, do this in Excel, and then either import the table, or link to the Excel file. If you import it, the table will be editable in wpDataTables, but any changes in it will not affect the Excel file and vice versa. If you link the file, you will not be able to edit the file in wpDataTables, but all changes will have to be made in the file stored in ../wp-content/uploads/YEAR/MONTH/file.xlsx

I hope this helps.

Best regards.