Filtering and analyzing large datasets can be a challenge. Whether you’re trying to pinpoint specific product sheets or need to extract data based on unique identifiers, knowing how to navigate and filter this information efficiently is crucial. In this blog post, we’ll guide you through the process of using Excel to filter data from Icecat’s CSV files.
Open Icecat: https://data.icecat.biz/export/freexml/<Lang_Code>/files.index.csv.gz
https://data.icecat.biz/export/freexml/<Lang_Code>/files.index.csv.gz
Full Icecat: https://data.icecat.biz/export/level4/<Lang_Code>/files.index.csv.gz
https://data.icecat.biz/export/level4/<Lang_Code>/files.index.csv.gz
The list of the codes can be checked here: https://iceclog.com/icecat-locales-and-language-code-table/
path
product_id
updated
quality
supplier_id
prod_id
catid
m_prod_id
ean_upc
on_market
country_market
model_name
product_view
high_pic
high_pic_size
high_pic_width
high_pic_height
m_supplier_id
m_supplier_name
ean_upc_is_approved
Limited
Date_Added
ean_upc_format
2. Follow the steps shown above and once the files.index.csv is uploaded click on New Source
3. Upload the list of values as a second source
4. Transform the column of values into List entity using Transform → Convert To List
5. Return to files.index.csv Data, then use the Excel formula to filter the values based on the list of values you provided. For instance, here is the formula to filter the SupplierID on the external list: = Table.SelectRows(#"Changed Type", each List.Contains(Sheet1, [supplier_id]))
= Table.SelectRows(#"Changed Type", each List.Contains(Sheet1, [supplier_id]))
6. The general formula is: = Table.SelectRows(#"Changed Type", each List.Contains(<LIST_NAME>, [<COLUMN_TO_MATCH>]))
= Table.SelectRows(#"Changed Type", each List.Contains(<LIST_NAME>, [<COLUMN_TO_MATCH>]))
Read further: Icecat, CSV, Icecat, manual