cancel
Showing results for 
Search instead for 
Did you mean: 

convert .CSV data into .xlsx data.

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.

Status: New
Comments
Super User

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.