Information & support > Knowledge base > Cookiebot Manager >Laatst bijgewerkt opFebruary 11, 2022The cookie catalogue can be exported as JSON. A JSON formatted file looks like this:Example JSON export CookiebotTo easily search and sort for different values or for comparing purposes it can be useful to import this JSON file in Excel. This can be done as follows:Download the catalog as JSON in the Cookiebot manager:Cookiebot download as JSONIn a new Excel file you select Data > Get Data > From file > From JSONImport JSON file in ExcelClick on List next to the field cookies:Select the cookie listClick on Convert to table:converter to tableClick on the icon on the top-right to select the columns. Tick the checkbox that says ‘original name as prefix’ (turn this off) and click on close & load: Selecter the columnsThe overview with the cookie catalog is now loaded into columns:JSON import in ExcelPrevious Facebook Twitter LinkedIn E-mailNext
Laatst bijgewerkt opFebruary 11, 2022The cookie catalogue can be exported as JSON. A JSON formatted file looks like this:Example JSON export CookiebotTo easily search and sort for different values or for comparing purposes it can be useful to import this JSON file in Excel. This can be done as follows:Download the catalog as JSON in the Cookiebot manager:Cookiebot download as JSONIn a new Excel file you select Data > Get Data > From file > From JSONImport JSON file in ExcelClick on List next to the field cookies:Select the cookie listClick on Convert to table:converter to tableClick on the icon on the top-right to select the columns. Tick the checkbox that says ‘original name as prefix’ (turn this off) and click on close & load: Selecter the columnsThe overview with the cookie catalog is now loaded into columns:JSON import in Excel