Append to Local File

Appending Data

When there are new rows of data to be added to the original data file, or when you want to consolidate data from multiple data files into one dataset, the append data feature can be used. The append data feature treats all the data in the newly uploaded file as new rows and appends them to the end of the current dataset.

When previewing the file, you can "Set Header": choose a row as the header, and the data structure will be set based on this standard in the next step.

You can also perform operations such as Select Rows and Columns and Transpose Rows and Columns. The role of Select Rows and Columns is to select a specific range of the file to import as a Dataset. The role of Transpose Rows and Columns is to switch the file’s rows and columns for use.

• When appending an Excel file with multiple worksheets, you can choose which specific sheet to append.
• When appending CSV-type files, you can select the column delimiter and file encoding.