function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SFmonkeySFmonkey 

downloading an existing SF report into an excel spreadsheet

Hello there

I have an existing Custom report built in SF.
This report has an ID that can be read in the report URL

Now I would like to use the excel connector to suck up this report from SF and to insert the data in excel . ( today I manually run the report in SF, export it and paste the data into my excel existing file.)
any idea ?

I haven't played a lot with the connector but what i saw so far is that we can query only one table at a time, the custom reports are made with few tables joined.

thx for any light, if its not possible with the connector I will think of another way

Y.
lmjohnsonlmjohnson
Instead of using the excel connector, have you looked at using the Office add-in for Excel. This allows you to refresh information directly from a report created in Salesforce.
 
L
SFmonkeySFmonkey
Thx a lot - tis exactly what i was looking for.

cheers dude.

Y.