We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies


Sorting and filtering are Excel features that help view and manage large data efficiently. These features are supported by Syncfusion .NET Excel library (XlsIO) .

Sort Excel data

Sorting allows you to sort worksheet data like numbers, text, and colors in a number of ways.

Sort by value

Columns with number, text, or date values can be sorted in either ascending or descending order.

Sort by color

Cell values with different foreground or cell colors can be sorted, which helps in visualizing values by priority.

Multiple-level sort

Sorting can be customized by choosing multiple columns in a required order.

Filter Excel data

Auto filtering is a quick and easy way to find, show, or hide values in one or more columns. Applying this filter will display the rows that meet the filter criteria.

Color filter

Excel Library supports the Excel color filter to filter columns quickly based on the foreground color or cell color that is applied either manually or by conditional formatting.

Icon filter

Icon sets create visual effects in Excel data. Applying icon sets for numeric data adds icons to each cell based on its value. Excel Library supports filtering data based on cell icons.

Excel combination filter

Excel Library supports the Excel combination filter to filter data when a column contains different data types like text, time values, and date-time values. It also filters data based on multiple criteria.

Excel custom filter

The custom filter in Excel provides an option to filter data with various conditions based on cell type. Excel Library supports all the filter conditions of Excel.

Excel dynamic filter

The dynamic filter is a relative date filter that filters data based on cell date. Excel Library supports the dynamic filter types day, week, month, and year.

Advanced filter

Excel Library supports the Excel advanced filter to either filter data with complex criteria (like filtering data in the same location) or filter and then copy the filtered data to a new location. This helps identify duplicate records and copy the extracted data to another location within the worksheet.



Syncfusion’s file format components helped me create the reports I needed, fast. – J. Pereira, Software Developer.

The libraries have been built from scratch and refined for more than a decade to provide blazing-fast performance, comprehensive API, and compatibility across the latest and older versions of these files.

CONTINUE READING View all Customer Stories


Syncfusion File Format Libraries - Manipulate Excel, Word, PowerPoint, and PDF files

Read and write Excel, Word, PDF, and PowerPoint files. Also includes integrated visualization capabilities. Advanced features include support for pivot tables, pivot charts, mail-merge, and extensive formatting.


Succinctly Series: Statistics Using Excel Succinctly

Succinctly Series: Statistics Using Excel Succinctly

- by Charles Zaiontz


Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon