Use Excel to view CSV files

• Create a new Excel Sheet in your workspace folder.

  • Let's call this file overview.xlsx

The is a sample pre-configured Excel sheet in you Templates folder and you may this instead of starting from scratch.

Using Data -> From Text / CSV we reference an existing CSV file. So, make sure you ran the GET - Deployments and Packages before!

Select your deploymentOverview.csv and Import that file. In Excel you can the use conditional formation to highlight your deployment status. Unfortunately I don't know how to copy existing formatting from one table to another. Find here a recommended format for three environments (columns G, H, I).

The last formulars with MID compare the deployed versions from each environment to highlight differences. If you look at the following output, you can quickly see that the deployments to Local and Cloud are not aligned:

• Red stands for different versions

• --- stands for: not available

• black means: same version as left system.