Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Adobe to Excel

Avatar

Avatar
Level 1
JCallaghan2
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
JCallaghan2
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
JCallaghan2
Level 1

04-05-2021

Hi all,

 

I am wondering if there is any way to export data from Adobe to Excel automatically?

 

I ask as I no longer have access to report builder and struggling to think of alternate method.

 

Any help will be gratefully received and much appreciated.

 

Kind regards

 

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Affirm 5
Level 3
salimj
Level 3

Likes

16 likes

Total Posts

28 posts

Correct Reply

6 solutions
Top badges earned
Affirm 5
Give Back 3
Contributor
Applaud 5
Boost 10
View profile

Avatar
Affirm 5
Level 3
salimj
Level 3

Likes

16 likes

Total Posts

28 posts

Correct Reply

6 solutions
Top badges earned
Affirm 5
Give Back 3
Contributor
Applaud 5
Boost 10
View profile
salimj
Level 3

04-05-2021

+1 to leveraging the API - it will give you a lot finer-grained control to your data pulls and it will break you away from Excel's performance limitations if you're consuming large amounts of data. One potential barrier would be if you're unfamiliar with APIs and programming for data pulls/processing.

 

The second option, if you absolutely must use Excel is to use Power Query + the API above. It still requires the same level of programming though. 

 

Another method, mentioned by @WayneV  is to structure your data in Workspace or Data Warehouse and get CSV data.

 

Also there is another convoluted method to push AA data to Google Sheets, but that would require a few different tools and accounts - you would also have to consider if your organization permits that process.

 

 

Avatar

Avatar
Boost 5
Level 2
WayneV
Level 2

Likes

5 likes

Total Posts

9 posts

Correct Reply

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

Avatar
Boost 5
Level 2
WayneV
Level 2

Likes

5 likes

Total Posts

9 posts

Correct Reply

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

04-05-2021

None that I am aware of. Report builder is your only option here.

 

Alternative options are: 1) Date warehouse to email/FTP csv 2) data feed 3) API and push data 4) save workspace as csv/copy paste to xls from a workspace project