How To Export Data To CSV File Output
Among the many export options available, TexAu can export automation results in a CSV output file format (comma-separated value file extension).
This is a very common file type, used in CRMs to store contact lists, for instance.
TexAu uses cloud storage temporarily to store the CSV export file: the results will stay there as long as you don't delete the execution. You can store this CSV downloadable file on your computer for archiving purposes too.
You can activate email notifications in your TexAu preference settings to receive a downloadable link to export your CSV result file.
For single automaiton, you can't send automation output data to a Google spreadsheet.
But you can export results in CSV file format and then manually upload them to Google Sheets or use them in a new workflow.
You'll find the CSV export file in the "Results" menu tab on the left panel.
Just click on the automation "result" button to access it:
Here you will be able to extract the result of this execution in CSV and reupload it in Google Sheets manually to use it in another automation:
In workflows, TexAu stores each automation result as individual CSV files. After that, you can combine all these separate text files from recipe results export settings and merge the column headers to a Google Sheet.
Note: at the moment there is no way to consolidate workflow results as a single CSV file, you need to map all headers to Google Sheets.
You can access the CSV result file from the Logs menu (1.), navigate to the "Recipe" (Workflow) tab (2.) tab then click on the green "Result" CSV download button on the right of the automation execution name (3.):
Here, you can export the automation execution results as a CSV file by clicking on the button "Download CSV":
Here's the whole process:
Depending on your computer's regional settings, you might experience issues reading the CSV file format with Microsoft Excel. If this happens you can:
Upload the file to a Google Sheet and it back as a CSV output file to your hard drive.
This issue is pretty common for customers using other languages than English on Mac OS X.
To solve this you have to change your regional settings:
- Go to System Preferences
- then Text and Language
- Click to Formats
- Under Numbers select Customize
- Change the Decimal list separator from a comma (,) to a full stop (.) as the default delimiter character.
- Hit save then reopen your CSV file.
By simply changing the CSV delimiter, you will be able to properly open and read the CSV database table on your device.