Google Play Billing Reports – modify csv to display only specific columns

To avoid having to do manual modifications to the csv file, we can use a script ready for this.

cat PlayApps_202205.csv| csvcut "," 1 2 4 6 7 14 15 16 17 18 > GooglePlay.csv

To use it – first we need to download the script from Zigazou’s GitHub and build it (follow the instruction).

Once we builded the script. we can move the file to

/usr/local/bin

so it will be available to use globally.

Let’s assume it’s done. Now we can work with our csv.

Here is my use case: I want to select specific columns in csv and save them as an output to the another file:

cat PlayApps_202205.csv| csvcut "," 1 2 4 6 7 14 15 16 17 18 > GooglePlay.csv