Home

List Utils

If you are tired of using Excel for small operations like sorting a list, adding a comma to a list, then this is the site for you. Here you can easily do Day-to-day List operations without opening a Spreadsheet software like- Excel, Google Docs etc. Just choose what option you want to use and paste your list, it will give you the desired result.

Add a Prefix
Add any text as a prefix to a list of items.

Mr.
+
John
Rob
Sam

=

Mr. John
Mr. Rob
Mr. Sam


Add a Suffix
Add any text as a suffix to a list of items.

John
Rob
Sam
+
Jr.

=

John Jr.
Rob Jr.
Sam Jr.


Sort
Sort a list of numbers or words in ascending order.

40
30
60

=

30
40
60


Unique
Get a list of unique items from a list of items.

10
30
10
40

=

10
30
40


Reverse
Reverse the order of items of a list.

10
20
30
40

=

40
30
20
10


Transpose
Given a list of items in a column format, change it to a row format.

10
20
30

=

10,20,30


Shuffle
Just shuffle the items in a list in a random order.

10
20
30

=

20, 30, 10


Count
Get the number of items in a list.

10
20
30

=

3


Sum
Get the sum of numbers in a list.

10
20
30

=

60


Average
Get the mathematical average of the numbers in a list

10
20
30

=

20


Statistics
Get the mathematical statistics about the numbers in a list.

10
20
30

=

Count = 3
Average = 20
Sum = 60


List to Columns
Convert a list into columns. You can specify the number of columns.

10
20
30
40

=

10   20
30   40


Intersect
Get common items of 2 lists.

10
20
30
40
60
20
40
50

=

20
40


Union
Get union of 2 lists.

10
20
30
40
20
40
50

=

10
20
30
40
50


Union All
Get union all of 2 lists.

10
10
30
20
40

=

10
10
20
30
40


List A Minus B
Get items in list A that are not present in list B.

10
20
30
40
20
30
50

=

10
40

List A Minus B
Get items in list A that are not present in list B.

10
20
30
40
20
30
50

=

10
40