Manipulating data for Excel

Try it out!

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

Interact with Excel

Simplify exhausted operation,
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.

Get smooth experience by clipboard

Compare with Add-in

Call SPL in Excel

Load SPL add-in first

Use SPL function as formulas

Use SPL script in VBA

Not using some clumsy VBA functions anymore.

Extract and Fill in

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 and Split

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
...

Find and Filter

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
...

Find duplicates and Counting

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 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
...

Sorting and Ranking

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
...

Association and Comparison

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
...

Special Grouping and Aggregation

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
...

Convert rows and 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
...

Calculate Date and Time

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
...

Expansion and Complement

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
...

Processing Text

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
...

Convenient IDE

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

Unique coding environment

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.

Easy to learn

Cookbook - Various Practical reference

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.

Course - Business Programming with SPL

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.