Spreadsheets and Entities

Why Microsoft Excel Complicates Entity Management | Diligent Insights

• Relational database tables and
spreadsheets are not the same
• Relational databases are more
restrictive than Excel tables
• The limits make them more powerful
• Restriction is on the Collection rule
– When entity instances are grouped, they
must all have the same structure (to make
a table)