Skip to content
Nappai Documentation

CSV to Data List

CSV to Data List reads information in CSV format (the table format exported by Excel, Google Sheets and many business tools) and turns it into a list of records: one per row, with the column names as fields.

This lets you process a list of customers, orders or products row by row with other components in your flow.

When to use it

  • Load a customer list exported from your CRM and send each customer a personalised message.
  • Process a product catalogue in CSV and write a description for each item.
  • Review an order export and keep only the orders that meet a condition.
  • Test a flow by pasting a few sample rows directly into the component.

Configuration

Fill in only one of these three fields. If you fill in more than one, or none, the component returns an error.

FieldWhat it does
CSV FileUpload a .csv file.
CSV File PathThe path to a .csv file, written as text.
CSV StringPaste the CSV content directly, with the first line as the header row.

The first row is always used as the column names.

Output

The Data List output returns a list with one record per row. Each record has one field per column, holding that row’s value.

Empty cells come through as a null value (null).

If the CSV has no data rows, the list is empty.

You can connect the list to components that work with several records, such as Filter Data Values, Loop or any component in Batch Mode.

Example

You want to send birthday wishes to customers born this month.

  1. Export the customer list to CSV with the columns name, email and birth_month.
  2. Upload it in CSV File.
  3. Filter the list to keep the records for the current month.
  4. Send each customer a personalised email with their name.

Good practices

  • Use simple column headers without spaces (for example signup_date): they are easier to refer to in other components.
  • Make sure the file is saved with UTF-8 encoding so accented characters are read correctly.