How To Use CSV upload Files As Input
The CSV file format is pretty common when dealing with contact lists, a product list, and customer email addresses in your CRM or email marketing software.
Dealing with CSV files is very similar to Google Sheets. The only difference here is that you can not consolidate workflow output data to the CSV format or write on it. For this, you would need Google Sheets.
First, click "CSV FILE UPLOAD" at the bottom to open the CSV dialog box to upload your CSV source file:
Drag and drop your input file in the CSV importer window or click "upload a file" to select the CSV sample file on your computer:
TexAu will show you the basic file description of your import file with its column headings and field values.
TexAu will pre-map the columns on your CSV import file.
Optional parameter: If you have column headings on your import CSV file, don't forget to check the box "Does this CSV have the first row for headers?"'
Then for each column, select the corresponding variables in the dropdown labeled "select matching input field" that TexAu needs to read the CSV header row to process the data.
💡 Quick Tip: Depending on your location, language, and OS, you may have CSV file type formatting issues. This is a source of common errors: The sample CSV file may appear as valid but when opened on Excel, it might have compatibility issues when used in TexAu or other tools. It's especially true with foreign and special characters in other languages than English.
Our recommendation: import the CSV file to a google sheet and re-download it as CSV. It will be formatted in UTF-8 format. Neat.
The difference with Google Sheets input is that TexAu will only show the required input variables to process the automation. Those field names will differ depending on each automation module settings.
In the example below, the required column names are "Website URL" and "Max Depth":
Those are the field names that you will have to map in the CSV importer modal:
Now that you mapped the variables to the column headings on your CSV import file click the blue button labeled "Execute CSV" to launch the automation:
In automation workflows, CSV import is a similar process but looks different.
First, click on the upper menu called "Variables":
Here, create a local variable:
Give a name to your local variable and leave the "variable value" field empty. That's because we will take that value from the CSV column header itself.
Once you have created your local variable, add it in the first automation in the workflow via the "insert variable" button next to the input field:
Click on the "CSV/Sheet" upper menu, select "CSV File", then import your CSV upload file:
Finally, let's map that local variable to the CSV column headings that contain the data we want to process. Simply make the correspondence between the column headings numeric fields and the variable you want to map. You can then pick the variable from the drop-down list.
To run this automation, click on "Execute CSV". Done!