Create a Sortable Book List with a Table in WPS Spreadsheet
Question details
Create a book database that can be sorted by title, author, date added, and reader rating, while allowing new books and color-coded records to be added easily.
- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- The user wants to organize a growing personal book list in a worksheet and sort or filter it by different book details.
- Observed behavior
- The goal is an expandable table with column sorting and filters, plus conditional color coding for ratings or other criteria.
Decide on consistent column headings before creating the table, such as Title, Author, Date Added, and Rating. Enter dates as real date values and ratings in a consistent format, such as whole numbers from 1 to 5, so sorting and rules work correctly.
Create an expandable table for the book database
Use this method to create a sortable and filterable book list that expands as you add new records.
A table adds filter arrows to each heading and keeps the book list organized. You can sort one column at a time, such as Title or Rating, and add new book entries directly below the existing rows.
In a blank WPS Spreadsheet worksheet, enter headings in the first row, such as Title in A1, Author in B1, Date Added in C1, and Rating in D1. Add optional headings such as Genre, Status, or Notes if needed.
Select the headings and the book entries, then go to Insert > Table. Confirm that the selected range is correct and enable the option indicating that the table has headers.
Select the filter arrow in a table heading, such as Title, Author, Date Added, or Rating. Choose Sort Ascending, Sort Descending, or select specific values to filter the displayed books.
Enter a new book in the row immediately below the table. The table formatting and filter range should extend to include the new row; if needed, drag the table resize handle to include additional entries.
Apply conditional formatting to color-code reader ratings
Use conditional formatting when you want ratings, reading status, or another value to stand out automatically.
Build and Maintain a Sortable Book Database in WPS Spreadsheet
WPS Spreadsheet lets you turn a simple book list into an organized table with sortable headers, filters, expandable rows, and conditional formatting for reader ratings. Its familiar spreadsheet tools make it easy to manage an ongoing reading log and exchange the file with Excel users.
- 1. Open a spreadsheet: Launch WPS Office and select Spreadsheet > Blank to create a new book-list worksheet.
- 2. Enter book fields: Type column headings such as Title, Author, Date Added, and Rating in row 1, then enter each book on its own row.
- 3. Insert a table: Select the data range and choose Insert > Table to add filter and sorting controls to the headings.
- 4. Add visual rating colors: Select the Rating column, then choose Home > Conditional Formatting to create color rules for your preferred rating levels.
Frequently Asked Questions
What columns should I include in a sortable book list?
Start with Title, Author, Date Added, and Rating. You can also add Genre, Series, Publication Year, Reading Status, Format, or Notes as separate table columns.
Can I sort a book table by author and then by title?
Yes. Use the filter arrow in any table heading and select a custom or multi-level sort option when available. Set Author as the first sort level and Title as the next level.
Why are my dates not sorting in chronological order?
The Date Added entries may be stored as text instead of dates. Select the cells and apply a date format from Home > Number Format, then re-enter any values that remain text.
How do I show only books with a high reader rating?
Select the filter arrow in the Rating table heading and clear unwanted values, leaving only ratings such as 4 and 5. You can also use Number Filters to display ratings greater than or equal to a chosen number.
Will a new book row be included in my filters automatically?
When you add an entry immediately below a properly created table, the table normally expands to include it. Verify that the new row has the same table formatting and that its filter controls remain part of the table.
