Upload Data in Excel File to CSV File Automatically

[snaplink22]

Hello,

I want to run a power query to upload the data in my Excel file to my CSV file, but as the CSV file is plain text I do not know how to accomplish this. Each time new data is entered into the table in the Excel file I want to add that data to the CSV file.

 

[snaplink22]

This is a problem of Google Calendar not Excel or Power BI
You can somehow define data in PowerBI then export to csv but GC should import this file
also you can enter data into Excel then use Power BI to import it then export to csv but there is still problem with GC

Yea that's something I just discovered after your post about Power BI. Seems it's been an issue for several years and users keep requesting that GC provide a live documents option for this type of application. Oh well, back to the drawing board. Thanks for all your help.

 

[sandy666]

You are welcome

--
you can try with outlook, define there google calendar (as I have) and it works (with refresh of course) - honestly you enter data into GC via Outlook
but you cannot make GC (network software) to import data automatically.

 

[snaplink22]

I went down that route, but Outlook wants a .CSV or .ICS file only too.

 

[sandy666]

but you can define basic folder where will be this csv (ics) and put there every new csv (replace with old file) then "refresh" outlook
something like with Power Query From Folder, if I put new file to this folder then after open excel file with defined PQ query - it will read new file and show the new data in the table in excel
ok, enough, too much theory

 

[snaplink22]

but you can define basic folder where will be this csv (ics) and put there every new csv (replace with old file) then "refresh" outlook
something like with Power Query From Folder, if I put new file to this folder then after open excel file with defined PQ query - it will read new file and show the new data in the table in excel
ok, enough, too much theory

Lol I often run too far down the rabbit hole in these scenarios. That's a good option and one I didn't consider, unfortunately, the person that would be responsible to perform that action is not very computer savvy (older gentleman about to retire) and I would worry that he would either abandon it or mess it up.

 

[sandy666]

it's easy, few steps only and always the same.
I would be more afraid that he would escape boredom

 

[snaplink22]

it's easy, few steps only and always the same.
I would be more afraid that he would escape boredom

I'm more hoping for an early retirement lol.