Start a free trial to see if esProc is the right tool for you.

Solve difficult calculation.

Through esProc, you can do a lot of sophisticated data manipulation in Excel. The methods can be 10 times simple compared to VBA.

Load SPL add-in first

Use SPL function as formulas

Use SPL script in VBA

- Extract data from complex row-style text
- Extract data from uncertain rows
- Extract specified cell data
- Extract repeating cell areas
- Extract mixed-style structure
- Extract data in the column direction
- ...

- Combine tables with same columns
- Combine columns and deal with duplicate data
- Combine tables with summarizing duplicate columns
- Combine tables with different columns
- Remove duplicates with combining rows and columns
- Summarize duplicates with combining rows and columns
- ...

- Filter data by multi-condition
- Filter data by location
- Filter with maximum and minimum in a category
- Find the first and last
- Find the maximum and minimum
- Find and filter by adjacent values
- ...

- Counting repetitions
- Counting repetitions for uncertain columns
- Deduplicating for row-style Excel
- Deduplicating without changing original orders
- Deduplicating with related columns
- Removal with paired data
- ...

- Calculate cell and Summarize value
- Calculate columns by some columns
- Calculate data by adjacent rows and intervals
- Calculate adjacent rows with continuous same data
- Calculate adjacent rows with not continuous same data
- Calculate cumulative value in category
- ...

- Aligning in specified order
- Aligning with repeated values in the specified order
- Concatenate members with the same rank
- Sorting in the same category
- Ranking in category
- Shuffle orders
- ...

- Handle association by formulas
- Single column associating another table
- Multi-column associating another table
- Interval association in the formula
- Use association table for interval association
- Use a two-dimensional association table
- ...

- Every N members as a group
- Grouping with adjacent data
- Grouping by empty or non-empty rows
- Grouping by data interval
- Concatenate the same group of data into text
- Aggregating with uncertain columns
- ...

- Row to fixed column
- Convert row-style table and cross table
- Put data in category horizontally into columns
- Convert every N columns into multiple rows
- Convert categories into columns
- Convert rows and columns in a category
- ...

- Summarize date by year and month
- Calculate time repeat interval
- Generate all dates between two dates
- Generate consecutive time
- Generate consecutive Sundays
- The first Friday of a month/quarter/year
- ...

- Generate continuous intervals
- Convert one row into multiple rows based on the value
- Split a text into multiple rows
- Complement missing parts in continuous values
- Complement a number of blank lines every N rows
- Expand multiple columns horizontally
- ...

- Split a text into multiple
- Get multiple texts after splitting and concatenating
- Take out numbers from texts
- Take out date from texts
- Split different types of characters from texts
- Parse key-values from texts
- ...

Desktop level data computing tool, ready to use, perfect debugging, inline with natural thinking, simpler than other languages.

Write code in the cell, not in a traditional text editor.

The cell value is the result calculated by an expression.

The cell name is used as a natural variable to refer to the cell value.

Through hundreds of samples covering most of the scenarios the data analysts may encounter in real-world businesses. Once you learn how to implement these tasks, you can handle the tabular data effortlessly and enjoy the daily work.

With simple syntax and moderate learning curve, esProc enables business people who are only familiar with Excel and have never writen a single line of code to experience an automatic and efficient data processing through programming.