Forum Discussion

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.

2 Replies

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
  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