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.

 

[alansidman]

I suspect that you will need to Refresh the Excel file once the new data is input. Then you will need to save the Excel File as a .csv file. I see no option to close and load your PQ editor to a CSV file.

 

[sandy666]

You can try PowerBI (Desktop) which allows you to export csv file directly

 

[snaplink22]

I suspect that you will need to Refresh the Excel file once the new data is input. Then you will need to save the Excel File as a .csv file. I see no option to close and load your PQ editor to a CSV file.

That's what I was thinking as well, but I'm hoping for a solution where the CSV file would update automatically every time new data was entered and saved into the Excel file. Basically, I'm trying to create a live calendar in Google Calendar from some of the data that is entered into the Excel file.

 

[snaplink22]

You can try PowerBI (Desktop) which allows you to export csv file directly

I've never used Power BI before, can you sync an Excel (not CSV) file to Google Calendar?

 

[sandy666]

I don't know...
You can read about Power BI here

Power BI - Data Visualization | Microsoft Power Platform

Visualize any data and integrate the visuals into the apps you use every day with Power BI, a unified platform for self-service and business intelligence.

powerbi.microsoft.com

or

Power BI Desktop—Interactive Reports | Microsoft Power BI

Create interactive reports with data modeling tools from Power BI Desktop. Connect to any data and easily gain actionable insights—for free.

powerbi.microsoft.com

 

[snaplink22]

I don't know...
You can read about Power BI here

Power BI - Data Visualization | Microsoft Power Platform

Visualize any data and integrate the visuals into the apps you use every day with Power BI, a unified platform for self-service and business intelligence.

powerbi.microsoft.com

or

Power BI Desktop—Interactive Reports | Microsoft Power BI

Create interactive reports with data modeling tools from Power BI Desktop. Connect to any data and easily gain actionable insights—for free.

powerbi.microsoft.com

Just started playing around with it, but it appears to be a limitation with Google Calendar and not anything else. It appears that it will only accept .CSV or .ICS files and since those are static it doesn't seem possible (currently) to get Google Calendar to automatically upload new data when it's entered.

 

[sandy666]

I don't know any software which do what you want. Each software need to be refreshed with data to show new entries, even google calendar with another google calendar known as sync (another name of refresh )
Refresh time can be defined but it's still refresh not live

 

[snaplink22]

I don't know any software which do what you want. Each software need to be refreshed with data to show new entries, even google calendar with another google calendar known as sync (another name of refresh )
Refresh time can be defined but it's still refresh not live

And that would be okay, but when you enter in data to the Excel file you would then need to save it as a CSV and upload it to Google Calendar, each time. If I could just go in and hit Refresh on the CSV file, once I finished entering in the data in the Excel file, and that would upload to GC I would be okay with that, but that doesn't work.

 

[sandy666]

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