Export data to csv from Excel Power Query

[ilcaa]

i have a .csv file that gets downloaded everyday. I import that into Excel as a connection and it gets refreshed automatically.

I do a little transformation on the data and load the transformation into a new sheet, (1 sheet original data, 2nd sheet transformed data)

as part of the transformation I want to export the Table as a csv file to a shared folder on my desktop. Is there a M language function that will export table to csv? thanks

 

[Kerryx]

Have a look at Matt's info at

Export from Power Query directly to CSV

Do you know how to export data from power query directly to a csv file? Exporting it to a table does not work....I guess my file is too big. Any workaround will do. So far I love Power Query but can't use it at all if I can't get the data back out to upload somewhere else. Thank you in...

www.mrexcel.com

 

[ilcaa]

Have a look at Matt's info at

Export from Power Query directly to CSV

Do you know how to export data from power query directly to a csv file? Exporting it to a table does not work....I guess my file is too big. Any workaround will do. So far I love Power Query but can't use it at all if I can't get the data back out to upload somewhere else. Thank you in...

www.mrexcel.com

thanks but that answer sucks. another tool to download and it needs to be done manually, im looking to automate it... within PQ would be ideal, it outputs your transformed data to Excel and simultaneously saves a copy as a csv to a location...

i guess VBA with a sheet 'on change' event. but that triggers on anything. thanks for reply.