Frequently Asked Questions
How is AnyDB different from Excel?
Excel is a spreadsheet application built for calculations, analysis, reporting, planning, and flexible data work. AnyDB is an operational systems platform built around connected business records, relationships, files, assignments, reminders, workflows, permissions, portals, history, and document generation.
Is AnyDB intended to replace every Excel workbook?
No. Excel remains an excellent tool for financial models, forecasting, analysis, reporting, calculations, and ad hoc data work. AnyDB is intended for spreadsheets that have become business-critical trackers or operational systems used to coordinate ongoing work.
Can AnyDB replace an existing Excel-based process?
Yes. You can begin with one workbook, worksheet, or workflow, import the related data, and rebuild the process around connected business records. Additional spreadsheets and processes can be added over time.
Can I import data from Excel?
Yes. Excel data can be imported into AnyDB. The AnyDB team can also help map worksheets, columns, lookup relationships, files, formulas, and business rules into an operational structure.
Can users still work in a spreadsheet-style layout?
Yes. AnyDB supports familiar rows, columns, fields, formulas, tables, and two-dimensional layouts. The difference is that each row can represent a complete business record with connected child records, files, workflows, history, and permissions.
Does AnyDB support formulas?
Yes. AnyDB supports formulas for operational calculations. Excel remains better suited to advanced financial modeling, highly flexible analytical calculations, and specialized spreadsheet analysis.
Can AnyDB generate Excel files?
Yes. AnyDB can generate and export Excel files from live operational records. It can also generate Word documents and PDFs using the same current record data.
Does AnyDB support workflows, approvals, and reminders?
Yes. AnyDB includes assignments, due dates, reminders, approvals, status changes, notifications, action buttons, webhooks, workflows, automation, and scripting.
Can customers, vendors, and contractors access the system?
Yes. AnyDB includes secure portals for external users. You can control which records, fields, files, forms, and actions each external user can access without sharing the internal system or an entire workbook.
Can Excel and AnyDB be used together?
Yes. AnyDB can serve as the controlled operational system of record while Excel remains available for analysis, calculations, reporting, imports, exports, and other spreadsheet-based work.
Can AnyDB help us redesign and migrate our workbook?
Yes. Share the current workbook and process with the AnyDB team. We can help identify the business objects, child records, relationships, permissions, workflows, portals, files, documents, and reports needed for the first working system.