🛣 Spreadsheet.com Roadmap [evergreen]

We continually adjust our roadmap to align with the most commonly requested features and enhancements. Contact us anytime with questions at info@spreadsheet.com or respond to this thread here.

IN PROGRESS

  • Named ranges
    Full support for defining and editing names ranges, as in traditional spreadsheets. Today named ranges can be imported as part of existing spreadsheets, and referenced in formulas, but cannot yet be defined and edited within Spreadsheet.com.

  • Select and Multiselect enhancements: define options from a range or named range
    We’re adding the ability for options in Select and Multiselect data types to be defined from a named range or manually specified range of cells, similar to how dropdowns are created in traditional spreadsheets with data validation. This will also work on import and export of Excel files.

  • Related row rollup (new data type)
    We’re working on a new column-level data type designed for use with related row columns for rolling up data from related rows. This will allow you to choose from a set of aggregation functions to use, as well as formatting options, when defining how rollups work.

  • Zapier integration
    We’re in the process of being added to the Zapier app directory, which will allow you to create zaps that connect Spreadsheet.com worksheets with over 3,000 other apps and sites.

  • New template gallery experience
    We’re building a new template gallery UI leveraging live embedded template previews, a “Featured templates” category, and a set of simple starter templates for getting started quickly from an empty Sheet, Gantt, Kanban, or Form view.

  • Duplicate columns
    Ability to copy columns within and across worksheets and workbooks, including column-level data type settings.

PLANNED (not necessarily in this order)

  • Notifications
    An in-app notifications list updated in real time showing each user all of the row assignments, @mentions, alerts, and reminders meant for them. In addition we will provide more fine-grained notification configuration options in Personal Settings, and provide users more control over which workbooks and individual rows they are following.

  • Trash
    A trash area (i.e. recycle bin) will allow you to recover deleted workbooks and workspaces for up to 30 days after they were deleted.

  • Alerts & Reminders
    Ability to set up a custom alert or reminder on a row based on a date value, change in a select value, user assignment, etc.

  • API
    Ability to programmatically work with workspaces, workbooks, worksheets, views, rows, cells, attachments, relationships, and more, via a REST API.

  • Hierarchy Rollup Settings
    Ability to define how parent rows behave in Sheet view hierarchies. E.g. whether they roll up information from child rows, ancestors, etc., and what they do with that data (e.g. sum, average, max, min, etc.).

  • Array Spillover in Formulas
    Support for array results in formulas spilling over to adjacent cells.

  • Additional Array Functions
    Support for array functions like IMPORTRANGE, FILTER, etc.

  • Cell and Row History
    Ability to view the change history of a cell: i.e. an audit trail of what a cell’s value has changed from and to, who made each change, and when each change was made. Cell history will roll up to a row-level history where you will be able to see the full history of a row in one view.

  • Printing
    Ability to print worksheets and full workbooks from within Spreadsheet.com.

  • Calendar View
    A new worksheet View type showing a calendar view wherein rows are organized by the day and week they are related to based on the value of a Date or Date & time column.

  • Charts
    Ability to create and edit charts based on ranges of worksheet data leveraging Spreadsheet.com’s unique data types. Support for importing charts as part of the spreadsheet import process.

  • Row Movement
    Ability to drag and drop rows to reposition them in a Sheet view, or move them from one group to another.

  • Grouping
    Based on popular request, we plan to add the ability to group rows in Sheet views by unique values in a column.

  • Reports
    Ability to consolidate data from multiple workbooks into a single worksheet that represents a report, which can be shared individually or as part of a workspace.

  • Dashboards
    Create and share documents with text and embedded widgets that leverage data from workbooks and reports to visualize information in a variety of ways.

  • Dashboard Widgets
    A library of widgets that can be used in dashboards to visualize and work with information from worksheets and reports in a variety of ways.

  • Conditional Formatting
    Support for conditional formatting with rule definitions leveraging Spreadsheet.com’s unique data types. Support for importing conditional formatting as part of the spreadsheet import process.

  • Worksheet Zoom Level
    We plan to add the ability to zoom in and out of a worksheet, similar to traditional spreadsheets.

  • Login with Microsoft, Okta, and more
    Allow users to login using Microsoft authentication or via a leading SSO provider such as Okta.

  • Keyboard Shortcut Enhancements
    Broader support for the most popular traditional spreadsheet keyboard shortcuts

  • Mobile App
    V1 of Spreadsheet.com mobile app

  • Desktop App
    V1 of Spreadsheet.com desktop app

  • Tablet App
    V1 of Spreadsheet.com tablet app

  • Pivot Tables
    Ability to create and import pivot tables

  • Workbook Activity
    A workbook activity dashboard with graphical summaries and a historical audit trail of activity in each worksheet.

  • Additional Data Types
    New data types planned: Time, Related row rollup, Button, …

  • Spell check
    Ability to configure automatic spell checking in cells.

RELEASED

  • Workbook loading speed improvementsreleased October 2, 2021
    We’ve made significant improvements to workbook loading performance, resulting in up to 10x faster load times! Shaving seconds off of the loading process makes a big difference to the user experience and we’re delighted to share this progress.

  • Wrapping behavior for Multiselect, User, and Related row cellsreleased October 2, 2021
    We’re adding support for text wrapping behavior in Multiselect, User, and Related row cells. When text wrap is enabled in these cells and there are more values than fit in the cell, the values will wrap and row height will automatically expand to accomodate. These data types will also respect vertical and horizontal alignment settings even when wrapping is enabled.

  • General signup, sign up from templates, and Sign up with Googlereleased September 26, 2021
    No more waitlist! We’re elated to share that we’ve opened Spreadsheet.com up to public sign up. This includes signing up directly from the Spreadsheet.com home page and signing up by starting from a template in the Template Gallery. New users can choose to register manually or sign up using Google credentials.

  • Related row type-ahead autosuggest and other enhancementsreleased September 26, 2021
    We launched a long-planned improvement to related row cells allow you to start typing a related row value and see suggested matches appear as you type. You can now also select a value simply by using the drown-down arrow in the cell rather than by opening the row selection dialog. This all makes selecting one or more related rows much faster and easier using the keyboard.

  • Column Formula data type enhancementsreleased September 18, 2021
    Added the ability to define an output format and data type specific settings for column formula columns. See the new Formatting tab in the Column formula data type dialog.

  • Sharing by linkreleased September 18, 2021
    We expanded the set of sharing options for folders and workbooks allowing them to be shared using a preconfigured link. Options include sharing to only a specific set of users, any users who belong to a specific set of named domains, or anyone with the link.

  • Duplicate worksheetsreleased September 6, 2021
    As with traditional spreadsheets, you can now copy worksheets using the new Duplicate worksheet capability. All of your styling, formatting, and formulas will be maintained as-is. In addition, all of your data type configuration information and views will also be copied. Attachments and relationships are also maintained. Note that Related row columns, ranges, and cells are converted to “1-way” in the copied worksheet (see recent release notes regarding “1-way” and “2-way” relationship capabilities).

  • Multicolumn insertreleased August 28, 2021
    As with traditional spreadsheets you can now insert multiple columns at once by selecting more than one column, right clicking, and choosing one of the Insert X columns right or left menu options.

  • 1-way and 2-way relationshipsreleased August 28, 2021
    Spreadsheet.com now allows you to specify whether relationships are 1-way or 2-way . Before this update, by default all relationships were 2-way, meaning that whenever a Related row column is created, a corresponding Related row column was automatically created in the target worksheet. Now, you can optionally specify that a Related row column is 1-way, so a column in the target worksheet does not get created. This is useful if you do not want the relationship reflected in, or modified by, the target worksheet.

  • Filter and Sort related row selectors by Viewreleased August 28, 2021
    When selecting a related row value, you can now control which rows are displayed as options to link to with the new Filter and sort selection by View option. This allows you to limit the set of rows users can select when choosing rows to link to.

  • Current date & time in automationsreleased August 28, 2021
    When updating Date and Date & Time values in automations you can now make use of the new Current Date and Current Date & Time tokens to define a relative value, as shown in the animation below. This makes it easy to change dates and times based on when another update or creation action occurs.

  • Hidden worksheetsreleased Aug 21, 2021
    As with traditional spreadsheets, Spreadsheet.com now supports the ability to hide worksheets. Imported workbooks with hidden worksheets now work as expected, with hidden worksheets remaining hidden by default. Only users with Owner and Manager access to a workbook can hide and unhide worksheets.

  • Public sharing and embeddingreleased Aug 7, 2021
    You can now publish workbooks publicly in a read-only state, and embed them in other websites and apps, with the new Public share and embed feature . This same feature is allowing us to embed live template previews in the Spreadsheet.com Template Gallery today.

  • Autofill with auto-incrementreleased Aug 7, 2021
    As with traditional spreadsheets, you can now select two or more cells in Spreadsheet.com and drag vertically or horizontally to automatically fill a range with auto-incremented values. Ranges of numbers, currencies, dates, and strings with a sequence of numbers, are supported. This also includes day and month names and abbreviations, and data types such as Rating, which is number-based.

  • Selection calculatorreleased Aug 7, 2021
    You may also have already noticed the new selection calculator in the bottom right corner of your workbooks when you have 2 more cells selected showing you a calculated value of that range. As with traditional spreadsheets, you can choose different calculation options depending on the type of data you have selected. This is a great way to do a quick calculation without writing an actual formula to do so.

  • Multi-column deletereleased Aug 7, 2021
    One of the most commonly requested enhancements we’ve received since opening up Spreadsheet.com for early access.

  • Automationsreleased June 8, 2021
    Define automations in a visual workflow designer that run based on changes in worksheet data, without complicated scripting. For example, trigger a notification, an email via Gmail, a Slack or MS Teams message, add a contact to Mailchimp, and more. We’ve combined ready to go automation recipes with integration connectors to provide fast and easy starting points for building custom application behavior without writing code.

  • Gantt Timeline Viewreleased June 3, 2021
    A new Gantt view type showing a timeline bar chart to the right of the worksheet that illustrates a project schedule, shows the dependency relationships between activities, and the current schedule status. Most applicable in worksheets where each row represents a task, deliverable, or deadline.

  • Array syntax in formulasreleased May 22, 2021
    Ability to use array syntax such as A1:A10 * B1:B10 and { A1, A2, A3 } in formulas. This is a prerequisite for array function support, the first set of which was added in this release with the addition of ARRAYFORMULA and ARRAY_CONSTRAIN functions.

  • Formsreleased April 10, 2021
    A new Form view type, providing the ability to define a form based on a worksheet’s columns, and share a direct link to it or embed it in any site that supports iframes. Each form submission becomes a row in the worksheet.

  • Version Historyreleased February 27, 2021
    Preview old versions of a workbook showing each change made, when it was made, and who made it. This also includes the ability to restore and create copies of any historical version. See granular changes down to the individual cell level, and restore the whole workbook or copy just the cells you need from a backup to your live version, data types and all (e.g. file attachments, related row links, etc., can be restored via copy & paste). Full version history on all workbooks will be stored for at least 3 years.

  • View Permissions & View Lockingreleased January 30, 2021
    Ability to assign permissions to specific Views within a worksheet, allowing certain views to only be visible to a subset of users or just you. View locking prevents other users from making changes to a view’s filtering, sorting, and other configuration settings until it is unlocked.

  • Worksheet Render and Scroll Performancereleased Jan 18, 2021
    We’ve rebuilt the Spreadsheet.com grid to improve render and scroll performance by up to 10x. Part 1 of this project was released on Nov 13, 2020, affecting scroll performance. Part 2 was released on January 18th with further improvements to rendering and scrolling speed.

  • Worksheet Edit and Selection Performancereleased Jan 18, 2021
    Our new high performance grid was released on January 18th giving Spreadsheet.com faster edit and selection performance.

  • Workbook UX Improvementsreleased Jan 18, 2021
    After learning from hundreds of hands-on onboarding sessions, we rolled out many improvements to the Spreadsheet.com user interface to make certain features and actions easier to discover, learn, and use. For example, enhancements to data type dialogs, Kanban views, share dialogs, and more.

  • Home Page Improvementsreleased Dec 8, 2020
    We redesigned elements of the home page and settings dialogs to make navigation easier and more intuitive. Part 2 of this effort will involve making the Home page update in real time as concurrent users make changes.

  • Cut, Copy, and Paste 2.0released Sept 7, 2020
    We have rewritten cut, copy, and paste operations within Spreadsheet.com to not only work more like a traditional spreadsheet, but also allow pasting data to and from external applications without loss of data, styling, and data types where possible.

  • Export to Excel – beta released Sept 7, 2020
    Ability to export a workbook to an Excel (XLSX) file with all styling, formatting, and formulas intact. Cells using rich data types in Spreadsheet.com that are not supported in Excel will be converted to their closest human-readable text equivalent value.

  • Table Header Row Improvementsreleased Sept 7, 2020
    The table header row is one of the most relied upon features in Spreadsheet.com. We’ve added a context menu to table header row cells to enable faster sorting, filtering, and other column-level actions in a way that is more familiar to traditional spreadsheet users.

5 Likes

I think this is a great roadmap. I’m not sure I’d change the order of anything prior to Forms (except for my comment about workbook sharing below).

Workbook Sharing Enhancements: I don’t think embedding a workbook in an external or third party application is nearly as important as many of the other things. I think the ability to print to a PDF is far more important than the ability to embed, and is one of the primary ways that you share work when you want to only share a portion of a spreadsheet (for security or privacy reasons). Invoicing and purchase orders are examples of sheets that would be printed to PDF and sent via email. I would swap Embedding with Printing … that’s how important I think printing is and how less important embedding is.

Integration and API: I’m not big on Integration and API so I wouldn’t be doing anything with that, but maybe this is strategically important. I’m glad to see that the gantt chart calendar views are listed before these, but I’d move Charts and Reports ahead of these.

Charts: I’d recommend implementing in-cell charts via a function like SPARKLINE prior to working on charts, as the development for the in-cell sparklines ought to be far less work but would enable some useful dashboarding features. Development of the chart functionality seems like a massive undertaking if done from scratch.

Conditional Formatting: I’d recommend implementing conditional formatting and in-cell sparklines prior to dashboards and dashboard widgets because with CF and Sparklines and basic charts you can create dashboards without the need for a special library of widgets.

Keyboard Shortcuts: If possible, I’d recommend implementing keyboard shortcuts as you go rather than leaving it to the end. I would listen especially to your active users and what they are requesting and also make the implementation of shortcuts an integral part of every operation. If a shortcut is commonly used in other spreadsheets, don’t use it for something different. A good bad example is how Quicken does something completely different for CTRL+C instead of Copy (this is perhaps the worst example I can think of … it just doesn’t make sense to use CTRL+C for anything but Copy).

1 Like

This is such a fantastic list @matt, thank you for the transparency and clarity. The performance improvements will be fantastic, and I can’t wait to try Grouping when it’s ready. View-level permissions will be especially useful for our company database. I can see us having an employee database with some data points not available to everyone.

1 Like

Thank you @Vertex42!

Regarding Keyboard Shortcuts and broader support for Formula Functions, we agree – these are ongoing efforts that are already underway so we’ve edited the roadmap above to better reflect this.

We’ve heard a lot of demand for Printing from early users that echo your comments, so it’s likely we will move this forward, at least a first version of it.

Meanwhile, we’ll be sending out product announcement emails and updating this roadmap post as things progress. Thanks for all of your feedback and suggestions to date, fantastic to have you as part of the Spreadsheet.com community.

Matt

Thanks for this feedback @daniel!

We use Spreadsheet.com all day internally, so we share your enthusiasm for the improvements coming soon. We’ve been investing a lot in Sheet performance and plan to continue to. Grouping and View-level permissions are both things we’re hearing a lot of demand for from other early users as well – we’ll be excited to announce those once we get there.

Fantastic to have you as part of the Spreadsheet.com community.
Matt

@matt great stuff… A suggestion for Cell and Row History – make sure that history is also available in a sheet so that it can be used for other purposes. For example, this could act as a “cheap trigger”, so that reporting could be done on how long it takes for status to change in a process.

1 Like

Thanks @Craig_Winkler, and agree. A full history log will be part of the “Workbook Activity” feature we have planned (was missing in the public roadmap above, now added), which will let you create a worksheet (or exported file) consisting of a change log from which you should be able analyze this data (e.g. average time to change a particular column value). Also cell history should eventually be queryable as part of our workbook API.

Great stuff! Is there any approximate date for pivots or reporting coming soon? Thaaank you!

1 Like

Given the amount we have scheduled for the next 6 months we are unlikely to get to these features before Q2 of next year. We’ll keep you posted. Both of these capabilities are in demand from early users and are critical components of our roadmap.

3 Likes

Pivot and conditional formatting are the most essential. We work with lots of data and inability to summarize in pivot table is a deal-breaker for our team. Hope to see Pivot table coming soon. Thanks a bunch for the great product!

3 Likes

Agree on the importance of both of these. As the roadmap stands today, Conditional formatting is more nearer term ( within next 6 months ) than Pivot tables - which is further out.

1 Like

Hello -
I am brand new to spreadsheet.com and so far, I’m pretty impressed.
What is the time line for items on the RoadMap ? I see items date back to September / October of 2020 -
what is the expected delivery date?
I’m particularly interested in Conditional Formatting - but it looks like there’s a ton of great stuff in the works!

Thanks,

1 Like

Welcome @David_Slater, great to have you in as an early user!

We hope to get to conditional formatting and charts this year. These are scheduled to come after a number of things in progress such as Forms, Gantt views, Automations and an initial set of integrations.

Hope this helps. As much as we’d like to we can’t put reliable dates on things that we know will be more than a few months away.

Regards,
Matt

Do you know roughly when the Zapier integration will be live? Days, weeks, months etc.

Welcome @Stephen_Chauvette. We’re aiming to have Automations and Zapier integration released in beta form in June.

1 Like

Conditional Formatting and Grouping please…

Also a “Quick/Real-Time” Filter (filters visible rows as you type in a text box - like a Find/Search that filters the visible Rows as you type)

2 Likes

So excited for some of these, especially performance improvements.

Conditional formatting, as many have mentioned, would be so huge for me. Highlighting or hiding (by making text white) individual cells is a key part of my traditional spreadsheets; my imported sheets got mildly “sterilized” haha.

1 Like

Welcome @Kayden and thanks for the +1 on conditional formatting. No question this is one of the most highly requested feature additions and because of this we have decided to increase its priority in our roadmap. We’ll keep you posted.

1 Like

Dear @matt ,

Awesome updates you have here. Look forward to named range and API.

Btw regarding integration, will it support importing/sync data from external sources such as QuickBooks and other sources?

Thanks.

1 Like