Data Lineage for Microsoft Excel
Excel is a program developed by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.
MANTA can connect to Microsoft Excel, process .xlsm and .xlsx files, and look up Excel objects such as graphs and pivot tables. MANTA also recognizes some tables manually created in sheets. All the mapped objects are then connected with their source objects by analyzing queries with MANTA’s database connectors.
MANTA currently scans
- XLSX, XLSM workbooks
- Defined names
- Pivot tables
- Database connections and queries including Power Query