Split Excel Data

Overview

With this app, you can split the data in the first sheet of your Excel file into separate sheets. Each new sheet will be named after the unique values found in the first column, allowing for organized data management by categories like cities or departments. This functionality is particularly useful for efficiently categorizing and accessing relevant data.

How to Use

1. Download the app from Octoparse AI app store.

2. Launch the app in your list.

   

   1.   Parameter Description

      

      1. FilePath: Enter or select the path of your Excel file (e.g., "D:\RPA_tutorial\example1.xlsx").

      2. StartRow: Specify the row number where data processing should begin.

      3. EndRow: Specify the row number where data processing should stop.

   2. Click "Run application"

3. Output

   The app creates new sheets within the same Excel file, each named according to the unique values from the first column.

Notes

1. All the launch parameters are required.

2. By default, the data to be split is from the first sheet.

3. The split data is based on the first column data, as shown in the figure below.

4. The sheet should include a header, with data being split starting from the second row.

Troubleshooting

Encounter obstacles but don't know how to resolve when executing the app?

Please contact our support team at [email protected] to find the way out!