{"id":2729,"date":"2007-12-15T15:14:24","date_gmt":"2007-12-15T09:44:24","guid":{"rendered":"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/"},"modified":"2026-10-13T21:40:11","modified_gmt":"2026-10-13T16:10:11","slug":"alphabetizer-sorts-lists-in-alphabetical-order","status":"publish","type":"post","link":"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/","title":{"rendered":"Alphabetizer: How to Sort a List in Alphabetical Order (Free Tools + Word, Excel)"},"content":{"rendered":"<p>Need to sort a list into alphabetical order fast? Whether it&#8217;s a guest list, a bibliography, keywords or a list of names, you don&#8217;t have to do it by hand. The free online <strong>Alphabetizer<\/strong> tool we found in 2007 still sorts any list alphabetically in one click, and you can also alphabetize lists in Google Docs, Word, Excel and Google Sheets. Here are the quickest ways to put a list in alphabetical order in 2026.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-45008\" src=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/alphabet-sort.jpg\" alt=\"Alphabetizer sorts lists in alphabetical order\" width=\"370\" height=\"339\" srcset=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/alphabet-sort.jpg 370w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/alphabet-sort-300x275.jpg 300w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/alphabet-sort-150x137.jpg 150w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/p>\n<p><strong>Quick answer:<\/strong> Paste your list into <a href=\"https:\/\/alphabetizer.flap.tv\/\" target=\"_blank\" rel=\"noopener\">Alphabetizer.flap.tv<\/a>, one item per line, and click <strong>Alphabetize<\/strong>. In Excel or Google Sheets, select the column and use <strong>Sort A to Z<\/strong>. In Word, use <strong>Home \u2192 Sort<\/strong>.<\/p>\n<p>Want more control? Our free <a href=\"https:\/\/www.quickonlinetips.com\/archives\/tools\/alphabetical-order\/\">alphabetical order tool<\/a> sorts A to Z or Z to A, by length or at random, removes duplicates and can ignore &#8220;The&#8221; at the start of titles, all in your browser.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6aff347c60233\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #1a202c;color:#1a202c\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #1a202c;color:#1a202c\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6aff347c60233\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#Alphabetizer_free_online_list_sorting_tool\" >Alphabetizer: free online list sorting tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#How_to_alphabetize_a_list_in_Microsoft_Word\" >How to alphabetize a list in Microsoft Word<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#How_to_alphabetize_in_Google_Docs\" >How to alphabetize in Google Docs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#How_to_sort_alphabetically_in_Excel_and_Google_Sheets\" >How to sort alphabetically in Excel and Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#Other_quick_ways_to_alphabetize_a_list\" >Other quick ways to alphabetize a list<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#Tips_for_sorting_lists_correctly\" >Tips for sorting lists correctly<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#Frequently_asked_questions\" >Frequently asked questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#What_is_the_best_free_alphabetizer\" >What is the best free alphabetizer?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#How_do_I_alphabetize_by_last_name\" >How do I alphabetize by last name?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2007\/12\/alphabetizer-sorts-lists-in-alphabetical-order\/#Can_I_alphabetize_a_list_on_my_phone\" >Can I alphabetize a list on my phone?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Alphabetizer_free_online_list_sorting_tool\"><\/span>Alphabetizer: free online list sorting tool<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/alphabetizer.flap.tv\/\" target=\"_blank\" rel=\"noopener\">The Alphabetizer<\/a> is a free web tool that puts any list in ABC order and tidies it up at the same time. It works on phones and computers with no sign-up. Its options include:<\/p>\n<ul>\n<li><strong>Alphabetize<\/strong> a list A to Z, or <strong>reverse<\/strong> it Z to A<\/li>\n<li><strong>Alphabetize by last name<\/strong>, useful for names and bibliographies<\/li>\n<li><strong>Sort titles<\/strong> while ignoring &#8220;The&#8221;, &#8220;A&#8221; and &#8220;An&#8221;<\/li>\n<li><strong>Remove duplicates<\/strong> and <strong>strip HTML<\/strong><\/li>\n<li><strong>Change case<\/strong>: lowercase or capitalised titles<\/li>\n<li><strong>Randomize<\/strong> a list (handy for draws and quizzes)<\/li>\n<li><strong>Add numbers, letters or Roman numerals<\/strong>, or your own text, to each line<\/li>\n<li><strong>Separate items<\/strong> by new lines, commas, tabs or custom characters<\/li>\n<\/ul>\n<p>When we first tried it, we used it to sort long lists of links and keywords for the blog, and the remove-duplicates and ignore-case options saved a lot of time.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_alphabetize_a_list_in_Microsoft_Word\"><\/span>How to alphabetize a list in Microsoft Word<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>Select the list (one item per line or paragraph).<\/li>\n<li>Go to <strong>Home<\/strong> and click the <strong>Sort<\/strong> button (A\u2192Z with an arrow).<\/li>\n<li>Choose <strong>Sort by Paragraphs<\/strong>, <strong>Type: Text<\/strong>, and <strong>Ascending<\/strong>, then click OK.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"How_to_alphabetize_in_Google_Docs\"><\/span>How to alphabetize in Google Docs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google Docs doesn&#8217;t have a built-in sort button. Either paste the list into Google Sheets and sort it there, or install the free <strong>Sorted Paragraphs<\/strong> add-on from <strong>Extensions \u2192 Add-ons<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_sort_alphabetically_in_Excel_and_Google_Sheets\"><\/span>How to sort alphabetically in Excel and Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Excel:<\/strong> select the column, then <strong>Data \u2192 Sort A to Z<\/strong>. To keep rows together, select the whole table first and choose the column to sort by.<\/li>\n<li><strong>Google Sheets:<\/strong> click the column letter, then <strong>Data \u2192 Sort sheet<\/strong> or <strong>Sort range \u2192 A to Z<\/strong>.<\/li>\n<li><strong>Formula:<\/strong> in both Excel 365 and Google Sheets, <code>=SORT(A2:A100)<\/code> returns a sorted copy, and <code>=SORT(UNIQUE(A2:A100))<\/code> also removes duplicates.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Other_quick_ways_to_alphabetize_a_list\"><\/span>Other quick ways to alphabetize a list<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Notepad++ or VS Code:<\/strong> use the built-in &#8220;Sort lines&#8221; commands for plain text lists.<\/li>\n<li><strong>Mac and iPhone Notes:<\/strong> paste the list into Numbers, sort the column, and copy it back.<\/li>\n<li><strong>AI chatbots:<\/strong> ask ChatGPT or Gemini to &#8220;sort this list alphabetically and remove duplicates&#8221;. Double-check long lists, as AI can occasionally drop or change items.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tips_for_sorting_lists_correctly\"><\/span>Tips for sorting lists correctly<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Numbers sort as text<\/strong> in many tools, so &#8220;10&#8221; may come before &#8220;2&#8221;. Add leading zeros (02, 10) or use a spreadsheet&#8217;s number sort.<\/li>\n<li><strong>Remove extra spaces<\/strong> at the start of lines, or they&#8217;ll jump to the top of the list.<\/li>\n<li><strong>Decide how to treat &#8220;The&#8221;<\/strong> in titles, and use the &#8220;ignore articles&#8221; option if you want &#8220;The Beatles&#8221; under B.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_asked_questions\"><\/span>Frequently asked questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"What_is_the_best_free_alphabetizer\"><\/span>What is the best free alphabetizer?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Alphabetizer.flap.tv is one of the easiest free tools, with options like sort by last name and remove duplicates. For data with several columns, use Excel or Google Sheets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_do_I_alphabetize_by_last_name\"><\/span>How do I alphabetize by last name?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Use Alphabetizer&#8217;s &#8220;by last name&#8221; option, or split first and last names into separate columns in a spreadsheet and sort by the last-name column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_alphabetize_a_list_on_my_phone\"><\/span>Can I alphabetize a list on my phone?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes. Online alphabetizer tools work in any mobile browser, and the Google Sheets and Excel apps can sort columns too.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Need to sort a list into alphabetical order fast? Whether it&#8217;s a guest list, a bibliography, keywords or a list&#8230;<\/p>\n","protected":false},"author":4,"featured_media":45008,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"default","_kad_post_title":"default","_kad_post_layout":"default","_kad_post_sidebar_id":"","_kad_post_content_style":"default","_kad_post_vertical_padding":"default","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[23],"tags":[],"class_list":["post-2729","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computers"],"_links":{"self":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/2729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/comments?post=2729"}],"version-history":[{"count":2,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/2729\/revisions"}],"predecessor-version":[{"id":65646,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/2729\/revisions\/65646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media\/45008"}],"wp:attachment":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media?parent=2729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/categories?post=2729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/tags?post=2729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}