How to Schedule an Automatic Save As for an Excel File into a CSV file format in OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-1604666%22%20slang%3D%22en-US%22%3EHow%20to%20Schedule%20an%20Automatic%20Save%20As%20for%20an%20Excel%20File%20into%20a%20CSV%20file%20format%20in%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604666%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20company%20just%20recently%20converted%20from%20Google%20Drive%20to%20OneDrive%20from%20Microsoft%20365.%20I%20am%20working%20in%20an%20analytics%20team%20a%20lot%20of%20the%20time%2C%20we%20have%20to%20work%20on%20processing%20a%20Google%20Sheet%20that%20is%20being%20used%20to%20track%20project%20progress%20into%20a%20Power%20BI%20readable%20data%20in%20Snowflakes%20using%20the%20Alteryx%20software%20to%20create%20a%20dashboard.%20Since%20our%20company%20is%20moving%20into%20OneDrive%20that%20uses%20cloud%20excel%20format%2C%20we%20have%20to%20figure%20out%20a%20way%20to%20reconnect%20the%20data%20that%20is%20now%20in%20the%20Excel%20format%20in%20OneDrive.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDuring%20my%20research%2C%20I%20am%20finding%20a%20stumbling%20block%20because%20the%20Alteryx%20OneDrive%20Input%20tool%20has%20a%20limitation%20on%20the%20file%20type%20that%20it%20can%20read%20to%20only%20JSON%2C%20CSV%2C%20or%20Afro.%20In%20this%20case%2C%20our%20interim%20solution%20would%20be%20to%20automate%20the%20save%20as%20a%20process%20to%20save%20the%20original%20Excel%20file%20into%20a%20CSV%20file%20in%20OneDrive.%20This%20was%20our%20Alteryx%20input%20that%20can%20read%20the%20latest%20converted%20CSV%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20feature%20in%20OneDrive%20that%20would%20allow%20us%20to%20somehow%20code%20and%2For%20automate%20the%20save%20as%20process%20from%20Excel%20original%20file%20into%20a%20CSV%20file%20for%20our%20workflow%20processing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3CBR%20%2F%3EAndika%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1604666%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

 

My company just recently converted from Google Drive to OneDrive from Microsoft 365. I am working in an analytics team a lot of the time, we have to work on processing a Google Sheet that is being used to track project progress into a Power BI readable data in Snowflakes using the Alteryx software to create a dashboard. Since our company is moving into OneDrive that uses cloud excel format, we have to figure out a way to reconnect the data that is now in the Excel format in OneDrive. 

 

During my research, I am finding a stumbling block because the Alteryx OneDrive Input tool has a limitation on the file type that it can read to only JSON, CSV, or Afro. In this case, our interim solution would be to automate the save as a process to save the original Excel file into a CSV file in OneDrive. This was our Alteryx input that can read the latest converted CSV file.

 

Is there a feature in OneDrive that would allow us to somehow code and/or automate the save as process from Excel original file into a CSV file for our workflow processing?

 

Thank you!
Andika

0 Replies