To move data from Pipedrive to Microsoft Excel 365 automatically, use a ready-made scenario — no manual exports.
You can launch this Pipedrive + Microsoft Excel 365 integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.