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

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.

Supper table data processing ability

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.