File Upload 0:26 video

How to import data from CSV files into a SpreadsheetWeb application

Accept CSV uploads in a SpreadsheetWeb application, push the parsed rows into a named range, and verify that the target grid receives the file data.

A File Upload control can parse a CSV file and place its rows into a workbook-backed grid.

Configure the CSV upload

  1. Add or select a File Upload control in Layout & Controls.
  2. Under Validation Options, add CSV File to Accepted File Types.
  3. Enable Push Data to Named Range.
  4. Select the grid or table range in Output Named Range.
  5. Set an appropriate maximum file size and save the control.

Preview the application with a sample CSV whose columns match the target range. After the upload completes, confirm that the grid receives the expected rows and that calculation or validation behavior still runs as intended.