Forum Discussion

Helpinghandindiango's avatar
Helpinghandindiango
Copper Contributor
Mar 12, 2020

Daily auto export excel filtered data to csv

I want to auto export perodically data in a filtered Excel (date sorting) export to a .CSV file .  I need data on specific date basis with relevent fields.   Any advice please.
excel
ExcelExciting's avatar
ExcelExciting
MVP
Mar 14, 2020

Hi Helpinghandindiango 

 

Your requirement can be done using Power Query if you have Excel 2010 & Above

 

Note : Excel 2010 & 2013 you need to download the add-in 

https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=aa630546-2a31-40b9-a8cb-8b1cba32acbc

 

Before installation make sure that your window is updated with the latest .net framework 

 

If you still need any assistance feel free to write back.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

 

Helpinghandindiango's avatar
Helpinghandindiango
Copper Contributor
Mar 14, 2020

ExcelExciting 

 

thanks for your reply.

this is google doc excel file.

I need auto filter on specific date wise and relevent fields needs to export in csv file.

pls see.

 

Resources