AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
1.4K members online now
1.4K members online now
Find out more about Google Ads billing options, forms of payment, and promotional codes
Guide Me
star_border
Reply

CSV export of billing transactions uses unusual negative sign that Excel does not recognize

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I export the Transactions view from Billing & Payments to place data in my accounting system since this includes both the expenses (clicks) and payments.

To export the data, I select the appropriate date range, and click on the download button near the upper right of the on-screen data.

This downloads a CSV file, which Excel opens.

The negative numbers in the "Amount" column are not recognized by Excel as numbers. Such numbers typically appear on the payment records.

The reason for this is that, instead of the "normal" minus sign (Unicode/ANSI 0x2D), the CSV file contains 0x2212 (Unicode "Minus Sign"), and as the file contents are encoded as UTF-8, the actual byte sequence in the file is E2 88 92. Excel does not recognize this as a negative sign, and so the value is treated as text.

To use the data, I have to perform a text replace to put in the 0x2D minus sign, then force the text to (again) be interpreted as numbers.

 

Altogether this is a pain to do and prevents any automation of this process.

1 Expert replyverified_user

CSV export of billing transactions uses unusual negative sign that Excel does not recognize

Rising Star
# 2
Rising Star

Thank you for posting your work-around.


Theresa
Google AdWords Top Contributor
*~*~*~*~*~*~*~*