Excel output file to CSV using Drawloop

  • 13 January 2022
  • 1 reply
  • 114 views

Hi,

We export data to excel and everything works great.

Then user has to open file and save it as CSV file (with ";")

I cannot find out how to help users and cancel this additional step.

Is it possible to prepare csv template (but i cannot find any example of it and I do not know how to use field in csv temlate) or maybe a could reconfigure something in docgen package?

 

How to prepare csv output file ?


1 reply

Badge +2
I am assuming your current template in your doc gen package is the excel that you are exporting data into. You could try saving this excel as a CSV to start with, that way when it's generated, it's already of type CSV.

If that doesn't work you could create a second template and upload an excel file that has been saved as a CSV. Move data to this excel file by using Range Names from your first excel file template. This would then be the one that your user downloads.

Reply