Can you please explain, How to convert CSV files into Excel (.xlsx) files Automatically..
I want to compare and insert .CSV column data into mssql table.
You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.
In your case you will need to parse your CSV into an array using this action, then you can use Create XLSX document from template action from the same connector to generate an XLSX file. Please read this article describing how to work with XLSX templates.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.