How to Populate a Central Calendar from Excel Review Dates in WPS Spreadsheets
Question details
The user needs to turn spreadsheet-based review dates, project names, and deliverables into a central calendar so quality reviewers can see work due in the next week.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A quality review team maintains review dates in a spreadsheet and needs a central weekly view of upcoming work.
- Observed behavior
- The current data exists as spreadsheet rows, but there is no shared calendar or filtered weekly view for reviewers.
Confirm that the workbook has separate columns for Review Date, Project, Deliverable, and Reviewer, and that all date values use the same date format before you build the calendar view.
Create a Weekly Review Calendar Sheet with Formulas and WPS Cloud Sharing
Use this when you want a no-code, WPS-native calendar view that can be shared with reviewers from the same workbook.
This solution keeps the original review log intact and builds a separate calendar sheet that automatically highlights the next seven days using WPS Spreadsheets formulas and conditional formatting.
In WPS Office, open the workbook that contains the Review Date, Project, Deliverable, and Reviewer columns, and select the source data range.
Click the plus (+) icon next to the sheet tab to add a new sheet, then enter the next seven dates as column headers or row labels using the source Review Date values.
Use formulas such as IF or VLOOKUP to pull Project, Deliverable, and Reviewer into the matching date cell from the source table, or link the key cells directly for a small review list.
Select the date cells, click Home > Conditional Formatting > Highlight Cells Rules > Between, and set the range from today to today+7 to visually distinguish upcoming work.
Click the Share button, save the workbook to WPS Cloud, set edit or view permissions, and send the link to quality reviewers.
Export a CSV from WPS Spreadsheets and Import It into Your Existing Calendar
Use this when reviewers already use Outlook, Google Calendar, or Microsoft 365 and you only need to move the review dates into that calendar.
Build a Shared Weekly Review Calendar in WPS Spreadsheets
Turn your existing Excel review dates into a shared weekly calendar with WPS Spreadsheets. Clean the source table, create a calendar sheet, highlight the next seven days, and share it through WPS Cloud without relying on Power Automate or Outlook.
- 1. Open the Excel file in WPS Spreadsheets: Start WPS Office, click Menu > Open, and select the Excel workbook containing review dates, projects, and deliverables.
- 2. Create the calendar sheet: Click the plus icon at the bottom sheet tab, name it “Weekly Calendar,” and enter the next seven dates from the Review Date column.
- 3. Link review items to dates: Use VLOOKUP or IF formulas to display Project, Deliverable, and Reviewer under each matching date, or use cell references for small logs.
- 4. Highlight the current week: Select the date row or column, click Home > Conditional Formatting > Highlight Cells Rules > Between, and set the range from today to today+7.
- 5. Share with the review team: Click the Share button, save to WPS Cloud, choose permissions, and send the link to reviewers.
Frequently Asked Questions
Which columns must the spreadsheet contain before I build the calendar?
Use at least Review Date, Project, Deliverable, and Reviewer. Consider adding Owner or Status. Place them in the first row and keep one record per row.
Can I automatically show only the next seven days in WPS Spreadsheets?
Yes. Use a formula such as =TODAY() or =TODAY()+7 together with Conditional Formatting under Home > Conditional Formatting > Highlight Cells Rules > Between, or use the Filter command on the Review Date column.
How do I share the WPS calendar with quality reviewers who do not have WPS Office?
Save the workbook to WPS Cloud, click Share, and set view permissions. Reviewers can open the shared link in a browser without installing WPS Office.
Does WPS Spreadsheets preserve my original Excel dates and formulas when I save?
Yes. WPS Spreadsheets opens and saves .xlsx files while preserving date values, formulas, and cell formatting for Excel-compatible workflows.
Can I import the WPS Spreadsheets calendar into Microsoft Outlook or Google Calendar?
Yes. Save the sheet as CSV UTF-8 from File > Save As and use the calendar app’s import feature to map Review Date, Project, Deliverable, and Reviewer to the appropriate event fields.
