Using Monkey Tools - Export Data Model Data to CSV Files
Unfortunately, Power Pivot doesn't have an "export to CSV" function. So what do you do if you have over 1M rows of data and you need to create a CSV for upload into another system? Or maybe you simply want to export the data on a regular basis to append during an import, thereby offloading the transformation overhead of non-transformed files?
The good news is that Monkey Tools has a monkey for that. Choose the columns you want, right click to rename them, click Export and (optionally) go get a coffee while our monkey does the job for you. It really is just that easy!
With added bonuses for pro users such as changing the delimiter, file output type and even pre/post pending the file names, you'll find this monkey super useful!