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

4K members online now
4K members online now
Get started with Google Ads - learn the basics to get set up for success
Guide Me

Exporting Report - can't sort by date order.

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Here is what I am doing:
1) Creating the report.
2) Sorting by date within AdWords report.
3) Exporting to Excel csv.
4) This is the result
Since the final 'Date' is not in Date Format, I can't sort it by Date in Excel. How do I rectify this, at either end?

1 Expert replyverified_user

Exporting Report - can't sort by date order.

Top Contributor
# 2
Top Contributor

Hi Ben S,


What's happening is the dates are being delivered as a quoted string when you use the excel csv option. That makes the imported data text instead of dates. You could edit the csv file and remove the quotes before importing, or you can import the csv file and create a macro to remove the leading quote in the cell.


My version of Excel is ancient, so I am not able to test with a current version.


Best of Luck!




petebardo -- Deadhead doing AdWords