---
title: "Import and export data in grid questions"
canonical_url: "https://www.nutrient.io/guides/workflow-automation/admin-guide/forms/importing-data-into-grids/"
md_url: "https://www.nutrient.io/guides/workflow-automation/admin-guide/forms/importing-data-into-grids.md"
last_updated: "2026-05-25T14:09:00.410Z"
description: "Import data from spreadsheets, CSV files, and tables into grid questions. Export to CSV format. Includes workflows and troubleshooting guidance."
---

# Import and export grid data

Grid questions support importing data from multiple sources and exporting to comma-separated values (CSV) format for working with spreadsheet data and other tabular information.

## Prerequisites

Before using import/export features:

- **Form editor access** — Permission to create and modify forms

- **Import/export enabled** — The grid question must have import/export functionality enabled

- **Live form access** — Import and export functionality is only available in published forms, not in the form builder preview

## Enabling import/export

To enable import and export functionality for a grid question:

1. Open the grid question configuration by clicking the **Edit** icon

2. In the **Basics** tab, check the **Enable Import/Export** checkbox

3. Click **Save**

Once enabled, the grid menu icon (☰) appears in the upper-right corner of the grid, providing access to import and export options.![Grid question interface with grid menu icon displayed in upper-right corner for accessing import and export options](@/assets/guides/workflow-automation/admin-guide/forms/grid-import-export/grid-initial-state.png)

## Importing data into grids

You can import data into grid questions using four methods.

### Import from CSV file

To import data from a CSV file:

1. Click the grid menu icon (☰) in the upper-right corner of the grid

2. Select **Import CSV** from the menu![Expanded grid menu displaying Import CSV option along with export and other data management tools](@/assets/guides/workflow-automation/admin-guide/forms/grid-import-export/grid-menu-open.png)

3. Choose a CSV file from your computer

4. Review the data preview in the confirmation dialog

5. Choose to **Append Data** or **Clear & Import**

The CSV file should have column headers that match your grid’s column structure. The system supports standard CSV format including:

- Quoted fields with embedded commas

- Multiple date formats (YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY)

- Currency values with dollar signs and commas

- Empty cells

### Copy and paste from spreadsheets

You can copy data directly from Excel, Google Sheets, or other spreadsheet applications:

1. In your spreadsheet application, select and copy the cells you want to import (`Ctrl+C` or `Cmd+C`)

2. Click anywhere in the grid question

3. Paste the data (`Ctrl+V` or `Cmd+V`)

4. Review the data preview in the confirmation dialog

5. Choose to **Append Data** or **Clear & Import**

The system automatically detects whether the first row contains headers or data, and handles the import accordingly.

**Supported sources**

- Microsoft Excel

- Google Sheets

- Microsoft Word tables

- HTML tables from web pages

- Any application that copies table data in HTML format

### Paste tab-delimited text

For text-based data:

1. Copy tab-delimited or space-delimited text data

2. Click inside the grid area

3. Paste the data (`Ctrl+V` or `Cmd+V`)

4. Preview the data

5. Choose to **Append Data** or **Clear & Import**

The system detects tabular text data that uses tabs or multiple spaces as column separators.

### Drag and drop

You can drag tables or files directly onto the grid:

1. Drag the data from your source application

2. Drop it onto the grid area

3. Review the data preview

4. Choose to **Append Data** or **Clear & Import**

Drag and drop works with HTML tables from web pages and tab-delimited text.

## Import confirmation dialog

Before importing data, the system displays a confirmation dialog with a preview.![Import confirmation dialog displaying data preview with row count, first ten rows of data, and options to append or clear existing data](@/assets/guides/workflow-automation/admin-guide/forms/grid-import-export/import-confirmation-dialog.png)

The dialog shows:

- **Row count** — The number of rows that will be imported

- **Data preview** — The first ten rows of data with column headers

- **Existing data warning** — An alert if the grid already contains data

You have three options:

- **Append Data** — Adds the new rows to any existing data in the grid

- **Clear & Import** — Removes all existing data and imports the new data

- **Cancel** — Cancels the import operation

## Imported data results

After importing, the grid displays all imported data with correct formatting based on column types.![Grid question table fully populated with imported spreadsheet data showing multiple rows with formatted columns for dates, currency, and text values](@/assets/guides/workflow-automation/admin-guide/forms/grid-import-export/grid-with-imported-data.png)

The import process:

- Converts data types based on column configuration (numbers, dates, currency)

- Preserves data formatting where possible

- Updates row indexes automatically

- Triggers form validation and change events

## Exporting grid data

To export grid data to CSV format:

1. Click the grid menu icon (☰) in the upper-right corner

2. Select **Export all data as csv**

3. Save the downloaded CSV file

The exported CSV file includes:

- All visible columns with proper headers

- Type-aware formatting (dates formatted as YYYY-MM-DD, select list values using their display text)

- Automatic exclusion of hidden columns, delete column, and static text columns

## Best practices

- **Review before importing** — Always review the data preview in the confirmation dialog to ensure the data aligns correctly with your grid columns.

- **Use append for adding data** — Choose **Append Data** when you want to add new rows while preserving existing data in the grid.

- **Use clear & import for replacement** — Choose **Clear & Import** when you want to start fresh and replace all existing grid data.

- **Check column alignment** — Ensure your imported data has the same number of columns as your grid, or that extra columns can be ignored.

- **Use supported date formats** — For date columns, use YYYY-MM-DD, MM/DD/YYYY, or DD/MM/YYYY formats for best results.

- **Clean currency data** — The system automatically handles dollar signs and commas in currency values, but ensure data is numeric.

## Common workflows

Below are typical workflows for importing and exporting grid data.

### Excel to grid workflow

This is the most common workflow for importing spreadsheet data:

1. Open your Excel spreadsheet and select the data range including headers

2. Copy the selected cells (Ctrl+C)

3. In the form, click in the grid question area

4. Paste (`Ctrl+V`)

5. Review the preview showing your Excel data

6. Choose **Clear & Import** to replace existing data or **Append Data** to add to existing data

7. Verify the imported data appears correctly in the grid

### Grid to Excel workflow

To export grid data for use in Excel:

1. Click the grid menu icon (☰)

2. Select **Export all data as csv**

3. Save the CSV file

4. Open the CSV file in Excel

5. Excel will automatically parse the CSV data into columns

### Updating grid data

To update existing grid data with new information:

1. Export the current grid data to CSV

2. Open the CSV file in Excel and make your changes

3. Save the CSV file

4. Import the updated CSV file using **Clear & Import** to replace all data

## Troubleshooting

- **Import button not available** — Verify that **Enable Import/Export** is checked in the grid question configuration. The feature must be explicitly enabled.

- **Paste not working** — Ensure you’re in a live form, not the form builder preview. Paste functionality only works in runtime forms.

- **Data not aligning correctly** — Check that the number of columns in your source data matches the number of columns in your grid. Extra columns will be ignored.

- **Wrong data types** — Verify that your source data matches the column types in your grid (numbers for number columns, dates in supported formats for date columns, etc.).

- **Headers treated as data** — If the first row of your import is incorrectly treated as data instead of headers, manually add a header row to your source data before importing.

- **Export missing columns** — Check if columns are hidden in the grid configuration. Hidden columns, static text columns, and the delete column are automatically excluded from exports.

- **Special characters causing issues** — Ensure your CSV file uses UTF-8 encoding to properly handle special characters, currency symbols, and international text.

For additional information on creating and configuring grid questions, refer to the [grid questions guide](https://www.nutrient.io/guides/workflow-automation/admin-guide/forms/using-the-grid-question.md).
---

## Related pages

- [Add attachments to your forms](/guides/workflow-automation/admin-guide/forms/adding-attachments-to-forms.md)
- [Dynamic calculations for streamlined form entries](/guides/workflow-automation/admin-guide/forms/calculations-in-forms.md)
- [Configure contact search groups](/guides/workflow-automation/admin-guide/forms/contact-search-question.md)
- [Calendar fields in forms](/guides/workflow-automation/admin-guide/forms/calendar-field.md)
- [Create a new form](/guides/workflow-automation/admin-guide/forms/create-a-new-form.md)
- [CSS styling](/guides/workflow-automation/admin-guide/forms/copy-and-paste.md)
- [Create form questions](/guides/workflow-automation/admin-guide/forms/create-form-questions.md)
- [Customize forms with CSS](/guides/workflow-automation/admin-guide/forms/css-styles-in-forms.md)
- [Design custom HTML forms with full control](/guides/workflow-automation/admin-guide/forms/developer-form.md)
- [Form library overview](/guides/workflow-automation/admin-guide/forms/form-library-overview.md)
- [Master form question editing with ease](/guides/workflow-automation/admin-guide/forms/edit-form-questions.md)
- [Edit and preview your forms effectively](/guides/workflow-automation/admin-guide/forms/form-preview-and-editor.md)
- [Mastering form rules for dynamic responses](/guides/workflow-automation/admin-guide/forms/form-rules-show-hide.md)
- [Form template management](/guides/workflow-automation/admin-guide/forms/form-templates.md)
- [Import and export forms](/guides/workflow-automation/admin-guide/forms/importing-and-exporting-forms.md)
- [Forms](/guides/workflow-automation/admin-guide/forms.md)
- [Integrate with external REST APIs](/guides/workflow-automation/admin-guide/forms/restful-data-elements.md)
- [Enhance form management with request records](/guides/workflow-automation/admin-guide/forms/set-up-a-request-record.md)
- [Use AI data extraction to populate forms](/guides/workflow-automation/admin-guide/forms/using-ai-data-extraction-question.md)
- [Generate forms using AI](/guides/workflow-automation/admin-guide/forms/using-ai-form-generator.md)
- [Using grid questions in forms](/guides/workflow-automation/admin-guide/forms/using-the-grid-question.md)