Bulk Paste Data in Grid View

Paste multiple rows of data directly into Grid View 

Brian Dollen avatar
Written by Brian Dollen
Updated over a week ago

Overview

The addition of bulk paste capability to the Grid View allows you to easily paste data copied from tools like Excel, Sheets, and Numbers, making it easy to transfer large amounts of data quickly and easily.

And the best part - our system is smart enough to understand that a pasted value is a table and automatically spreads it across multiple rows and columns.


To initiate the import process, users can simply highlight any cell in the grid and hit Cmd/Ctrl+V. This ensures that the import process does not affect any of the cells located to the left of the selected cell or any rows located above the selected row. This allows you to paste data into any location in the grid without disrupting existing data that you don't want to replace.

Note: The maximum number of pasted rows is limited to the maximum number of records supported by the Table.


The maximum number of pasted columns will depend on the particular grid, giving you the flexibility to import data into any grid. Data is only pasted into visible columns, allowing you to pick the specific fields you want to update. Additionally, if you paste more columns than you have visible, you'll be prompted to add new columns (fields) to hold the extra data.

From here you are able to easily modify the field settings to convert each text field to the appropriate field type.


Did this answer your question?