AdWords
2.2K members online now
2.2K members online now
Get started with AdWords - learn the basics to get set up for success
Guide Me
star_border
Reply

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. http://imgur.com/a/9Oqjb
3) Exporting to Excel csv.
4) This is the result http://imgur.com/a/RPuZj.
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?
Cheers!

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!

 

Pete

 

petebardo -- Deadhead doing AdWords