Exporting Planner to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1339902%22%20slang%3D%22en-US%22%3EExporting%20Planner%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339902%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20implementation%20of%20Exporting%20Planner%20to%20Excel%2C%20as%20I%20see%20it%2C%20is%20a%20dead%20end%20currently%20--%20I%20can%20export%20it%20manually%2C%20then%20interact%20with%20that%20stand%20alone%20excel%20sheet%20to%20make%20it%20better%20to%20read.%20However%2C%20when%20I%20want%20to%20do%20it%20all%20over%20again%203%20weeks%20later%2C%20I%20have%20to%20reformat%20everything%20from%20scratch.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20instruction%20exist%20on%20creating%20a%20smarter%20product%20out%20of%20the%20current%20Export%20to%20Excel%20implementation%3F%20How%20can%20I%20create%20a%20data%20connection%20between%20the%20planner%20and%20an%20excel%20workbook%2C%20so%20I%20can%20just%20hit%20refresh%20in%20Excel%20to%20pull%20hte%20latest%20data%3F%20Or%20at%20the%20very%20least%2C%20a%20better%20way%20to%20create%20a%20nice%20workbook%20template%20that%20I%20don't%20have%20to%20re-implement%20every%20couple%20weeks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341421%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20Planner%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341421%22%20slang%3D%22en-US%22%3EIt%20is%20possible%20to%20use%20Microsoft%20Flow%20to%20schedule%20periodic%20updates%20of%20a%20table%20in%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3EList%20Rows%20in%20a%20Table%20%26gt%3B%20Apply%20to%20each%20%26gt%3B%20Get%20Task%20%26gt%3B%20Update%20a%20Row%20in%20a%20Table%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1349645%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20Planner%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1349645%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F638066%22%20target%3D%22_blank%22%3E%40mike_302%3C%2FA%3E%26nbsp%3BYou%20need%20to%20use%20the%20third%20party%20app%20to%20schedule%20this%20export%20process.%20This%20app%20will%20export%20the%20tasks%20to%20Excel%20in%20the%20specified%20format%20at%20the%20regular%20intervals%20you%20have%20configured.%20Let%20me%20know%20if%20you%20need%20more%20details.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

The implementation of Exporting Planner to Excel, as I see it, is a dead end currently -- I can export it manually, then interact with that stand alone excel sheet to make it better to read. However, when I want to do it all over again 3 weeks later, I have to reformat everything from scratch.

 

Any instruction exist on creating a smarter product out of the current Export to Excel implementation? How can I create a data connection between the planner and an excel workbook, so I can just hit refresh in Excel to pull hte latest data? Or at the very least, a better way to create a nice workbook template that I don't have to re-implement every couple weeks.

2 Replies
It is possible to use Microsoft Flow to schedule periodic updates of a table in Excel.

List Rows in a Table > Apply to each > Get Task > Update a Row in a Table
Highlighted

@mike_302 You need to use the third party app to schedule this export process. This app will export the tasks to Excel in the specified format at the regular intervals you have configured. Let me know if you need more details.