excel data price list conversion

I have a price list from the supplier , it has thousands of line items , i need only the products i have listed to be manipulated.
i will provide markups for the various price lists i have and pricing for the price lists.