How do I export a large project with custom fields and subtasks into a CSV or spreadsheet

@Jeff_Schneider thanks for the info!

I have 2 questions I hope you can help with.

  1. I don’t see the export to google sheets option under my project.
  2. If I export to JSON i’m not sure how to plug it into Excel and the make a report that will give me all completed tasks in a project that can be filtered by custom fields and then for the tasks that are not completed I want to know a count of subtasks and which ones are completed.

Any tips or guidance would be highly appreciated.

I’m trying to get reporting standardized for the whole department and the goal would be to report on a per sprint level but roll up by quarter and the year.