PDF download Download Article PDF download Download Article

Whether you want to organize all your docs in alphabetical order or sort a list of data within a document, alphabetizing in Google Docs is pretty simple. In this article, we’ll talk you through the best ways to alphabetize in Google Docs and Google Sheets, using both the web-based versions and the Android or iOS apps.

Easy Ways to Alphabetize Google Docs

To alphabetize your documents, sort them by “Title” or “Name” in the main Google Docs menu. Install an add-on like Doc Tools or Sorted Paragraphs to alphabetize data within a Google Doc, and use the “sort” function in Google Sheets to alphabetize data in a selected column.

Method 1
Method 1 of 4:

Sorting Your Documents by Title

PDF download Download Article
  1. If you’re using a computer, navigate to https://docs.google.com/ in your browser. On your phone or tablet, open the Google Docs app.
  2. In the web version of Google Docs, look for an AZ button on the top right side of the screen, just below the Template Gallery and above the list of Recent documents. In the mobile app, look for a dropdown menu with a down arrow next to it on the top left of the list of documents. Tap this button to see your sorting options.
    • The default sorting option is Last opened by me.
    Advertisement
  3. This will sort your docs by title in alphabetical order. Documents with titles that start with numbers or special characters will be listed first.
  4. Advertisement
Method 2
Method 2 of 4:

Alphabetizing Text within a Doc

PDF download Download Article
  1. Open your document in Google Docs. There’s no built-in way to alphabetize data in Google Docs. However, you can do it easily with an add-on. You’ll need to do this on your computer rather than the app version of Google Docs. Start by opening the doc with the data you want to alphabetize.[1]
    • Some add-ons are available in the Google Docs app for Android.[2] However, it’s a much more limited selection than what’s available for the web version.
  2. Once your doc is open, click the Extensions drop-down menu at the top of the screen.[3]
  3. In the Extensions menu, click or tap Add-ons.[4]
  4. Click the Get add-ons option in the Add-ons submenu. This will open a pop-up window where you can search for and install new add-ons from the Google Workspace Marketplace.[5]
  5. Use the Search apps text box at the top of the pop-up window to find the add-on you want to install. Two add-ons that will allow you to sort data within a Google Doc are Doc Tools and Sorted Paragraphs. To install the add-on of your choice:[6]
    • Click the add-on in the search results.
    • Click the blue Install button.
    • Select Continue to confirm that you want to install the add-on in Google Docs.
    • Choose your Google account in the Sign in window that pops up.
    • Click Allow to allow the add-on to access your account.
    • A confirmation window will pop up once the add-on is successfully installed. Click Done.
  6. In your Google Doc, select whichever text you are planning to sort into alphabetical order. In order for the add-on to sort the text, it will need to be arranged in a vertical list or formatted in paragraphs.[7]
    • For example, if you write a sentence and select it, the add-on will not rearrange the words in alphabetical order. You’d have to put each word on a separate line.
    • You can also sort paragraphs alphabetically by the first word in each paragraph.
  7. With the text selected, open the Extensions menu again. Find your add-on in the drop-down menu and click it or hover your cursor over it to see your sorting options.[8]
  8. Depending on which add-on you are using, you’ll have a few different options for formatting your text. Once you select the option you want, the add-on will reorder your text.[9] For example:
    • If you’re using the Doc Tools add-on, select Sort the selection ascending to put the text in alphabetical order. Choose Sort the selection descending to put it in reverse alphabetical order.
    • In the Sorted Paragraphs add-on, choose Sort A to Z for alphabetical order and Sort Z to A for reverse alphabetical order.
  9. Advertisement
Method 3
Method 3 of 4:

Sorting Data Alphabetically in Google Sheets (Desktop)

PDF download Download Article
  1. You can sort data in the web or mobile version of Google Sheets, but doing it online gives you more options. To get started, navigate to https://docs.google.com/spreadsheets and open the document you want to edit.[10]
  2. Click the letter at the top of a column to select the whole column. You can also select a range of cells by clicking the first cell in the range, then adding additional cells by clicking them while holding the Shift key.[11]
    • While you can also select data in rows instead of columns, Google Docs doesn’t allow you to sort alphabetically across rows. The sorting is column-based.
  3. With your data selected, open the Data menu at the top of the document window.[12]
  4. In the Data menu, click on Sort Range or hover your cursor over it to display a sub-menu of sorting options.[13]
  5. For example, if the first column in your selected range is Column A, you’ll see the option to Sort range by column A (A-Z). Click this option to put the first column in your selected range in alphabetical order.
    • Using this option will only sort the data in the first column. The order of the data in the adjacent columns will stay the same.
    • Choose Sort range by column [letter] (Z-A) for reverse alphabetical order.
  6. If you want to alphabetize multiple columns without sorting the whole sheet, you’ll need to use the advanced options tool. With the desired range of columns selected, click on Sort range, then click Advanced range sorting options. From there:[14]
    • Check the box next to Data has header row if your columns have titles. This will prevent the titles from being sorted with the rest of the data.
    • Select the column you want to sort first from the Sort by drop-down menu, then select the sorting order (A-Z or Z-A).
    • Click Add another sort column to add the next column in your range that you’d like to sort, and select the sorting order you want for that column.
    • Click Sort to apply the changes.
  7. The Sort sheet option alphabetizes the selected column while preserving the relative locations of the data in the adjacent columns. For instance, if you have a list of names in column A and associated dates in column B, this option would arrange the names alphabetically and would also reorder the matching dates in the next column so they stay paired with the original names. To do this:[15]
    • Select the column you want to sort alphabetically.
    • Open the Data menu and select Sort sheet.
    • Choose the sorting order you want. For example, for alphabetical order, select Sort sheet by column A (A-Z). You can also sort in reverse alphabetical order.
  8. Advertisement
Method 4
Method 4 of 4:

Sorting Data Alphabetically in Google Sheets (Mobile)

PDF download Download Article
  1. You can use the Google Sheets app to quickly put a column in alphabetical order. To get started, launch Google Sheets on your phone or tablet and open the sheet you want to edit.[16]
    • When you alphabetize a column in the Google Sheets app, the data in the adjacent columns will also be reordered so that your original rows are preserved. For instance, if you alphabetize a list of names in column A, the list of dates in column B will be reordered so they stay with the original names.
  2. Tap the letter at the top of the column you want to alphabetize.[17]
  3. Tap the column letter again to open a context menu. This menu will give you a few options for editing your data.[18]
  4. If you’re using the Android version of the app, tap to open additional menu options.[19] In the iOS app, tap the ► right arrow until you see the Sort options.[20]
  5. Tap Sort A-Z to put the data in the selected column in alphabetical order. You can also select Sort Z-A to put the data in reverse alphabetical order.[21]
  6. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I put things in alphabetical order on Google slides?
    Community Answer
    Community Answer
    You have to copy and paste your document in to Word or Google sheets if you do not have Word.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement

Video

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!

You Might Also Like

Group and Outline Excel Data Group and Outline Excel Data: Easily Collapse Rows of Info
Download Images from a Google DocDownload Images from a Google Doc
Download Google Docs4 Easy Ways to Download and Save Google Docs
Make a Brochure Using Google Docs Make a Brochure Using Google Docs: Quick Guide
Use Google Spreadsheets Use Google Sheets: The Ultimate Guide for Getting Started
Convert a Google Doc to a PDF on iPhone or iPadConvert a Google Doc to a PDF on iPhone or iPad
Upload Videos to Google DocsInserting Videos to Google Docs with Google Slides
Add Caption to Image in Google Docs4 Easy Ways to Add Captions to Images in Google Docs
Make a Card in Google DocsMake a Card in Google Docs
Flip an Image in Google Docs9 Easy Steps to Flip an Image in Google Docs
Check Google Doc History See a Google Doc's Version History
Open Google DocsEasily Open Google Docs in a Browser, the App, or MS Word
Move an Image in Google Docs2 Easy Ways to Move Images in Google Docs in 2 Ways
Share Google DocsShare Google Docs
Advertisement

About This Article

Luigi Oppido
Reviewed by:
Computer & Tech Specialist
This article was reviewed by Luigi Oppido and by wikiHow staff writer, Megaera Lorenz, PhD. Luigi Oppido is the Owner and Operator of Pleasure Point Computers in Santa Cruz, California. Luigi has over 25 years of experience in general computer repair, data recovery, virus removal, and upgrades. He is also the host of the Computer Man Show! broadcasted on KSQD covering central California for over two years. This article has been viewed 731,155 times.
How helpful is this?
Co-authors: 12
Updated: August 23, 2024
Views: 731,155
Article SummaryX

1. Open a document in Google Docs.
2. Click Add-ons, then click Get add-ons....
3. Search for the "Sorted Paragraphs" add-on, then add the add-on to your Google Account.
4. Select the content you want to alphabetize.
5. Click Add-ons, select Sorted Paragraphs, and click Sort A to Z.

Did this summary help you?

Thanks to all authors for creating a page that has been read 731,155 times.

Is this article up to date?

Advertisement