Align column headers in exported Excel reports

Avatar

Avatar
Boost 5
Level 2
yuhui22720
Level 2

Likes

12 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 2
yuhui22720
Level 2

Likes

12 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile
yuhui22720
Level 2

22-02-2010

When exporting a report in Excel format, the column headers in the data table are always misaligned. For example, if I export the "Tracking Code" report, the "Tracking Code" column header will be in column B, but the list of codes is actually in column C. This can be extremely irritating when sharing the reports with other people, who may be unaware of the misaligned columns. The misaligned columns also make the report more difficult to read quickly.

 

This bug has been around since day one of SiteCatalyst 14. It would be really, really, really cool if this bug could finally be fixed.

5 Comments

Avatar

Avatar
Boost 500
Level 10
markc44481791
Level 10

Likes

911 likes

Total Posts

96 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
markc44481791
Level 10

Likes

911 likes

Total Posts

96 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
markc44481791
Level 10

22-02-2010

This has been a real issue not just enhancement. More than once have seen analytst grab the wrong total directly below a given column in Excel but was really for another column.

Avatar

Avatar
Applaud 5
Level 1
umilan
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
umilan
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile
umilan
Level 1

23-02-2010

Yes, this would be helpful and it would be less time consuming to keep correcting excel docs when reporting on data. Thx!

Avatar

Avatar
Boost 1
Level 1
jkade19438
Level 1

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile

Avatar
Boost 1
Level 1
jkade19438
Level 1

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile
jkade19438
Level 1

23-02-2010

I couldn't agree more strongly.  I just brought this up with ClientCare a week ago.  It's really not an enhancement request, though, it's a bug fix.

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

23-02-2010

Shout-out to David Labbe in ClientCare for pointing out that we actually did implement this feature in SiteCatalyst v14.5. However, we didn't automatically enable it for all users because many had automated processes that relied on the old format. The good news is that you can turn it on and see if it does the trick by going to Admin > Admin Console. Once in the Admin Console, go to Admin Console > Company, then the Preferences tab. Choose the current versions of Excel Renderer and CSV Renderer. This should really resolve the majority of Excel alignment problems, except for some found in dashboards. Look forward to dashboard alignment fixes in the upcoming release of SiteCatalyst v14.7.

Avatar

Avatar
Boost 500
Level 10
markc44481791
Level 10

Likes

911 likes

Total Posts

96 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
markc44481791
Level 10

Likes

911 likes

Total Posts

96 posts

Correct reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
markc44481791
Level 10

23-02-2010

Thanks - that does work! 

 

Now if we could only get Excel to download the full event/metric names instead of  "Even..."   Seriously why not download the full names - Excel knows how to wrap cell contents?