Create Data Dictionary from Excel Files Automatically
Test safely on small Excel files (up to 2MB).
Use advanced processing to avoid errors in large Excel files.
🚀 AI-Powered Analysis
🔒 Secure Processing
📈 Smart Insights
💼 Professional Docs
🔍 Data Quality
0
Columns
0MB
File Size
0
Sheets
0
Rows
Drag & Drop your dataset file here
Supports XLSX, XLS, CSV, XLSB formats • Max 2MB
Processing your file...
📊
Processing
Processing your file...
0
0%
0
0
Columns
0
Rows
0s
Time
Advanced Data Dictionary
Generated on: ${new Date().toLocaleString()}
Total Columns: ${dataDictionary.length}
Analysis Type: AI-Powered Advanced Analysis
| Column Name | Data Type | Semantic Type | AI Description | Sample Values | Unique Values | Missing Values | Data Quality | Improvement Suggestions |
|---|---|---|---|---|---|---|---|---|
| ${col.columnName}
${col.piiRisk && col.piiRisk !== 'Low' ?
` PII Risk: ${col.piiRisk}` : ''} |
${col.dataType}
${col.semanticType !== 'Generic' ?
` ${col.semanticType}` : ''} |
${col.semanticType} | ${col.description} | ${col.sampleValues || 'No samples'} | ${col.uniqueValues} | ${col.missingValues} (${col.completeness}) | ${col.dataQuality} (${col.qualityScore}%) | ${col.suggestions} |
Generated by Premium Data Dictionary Creator with AI-Powered Analysis
`; content = new Blob([htmlContent], { type: 'text/html' }); filename = `advanced_data_dictionary_${new Date().getTime()}.html`; } else if (format === 'json') { // Prepare JSON content const jsonContent = { metadata: { generatedOn: new Date().toLocaleString(), totalColumns: dataDictionary.length, analysisType: "AI-Powered Advanced Analysis", tool: "Premium Data Dictionary Creator" }, dataDictionary: dataDictionary }; content = new Blob([JSON.stringify(jsonContent, null, 2)], { type: 'application/json' }); filename = `advanced_data_dictionary_${new Date().getTime()}.json`; } saveAs(content, filename); } catch (error) { console.error('Download error:', error); showError('❌ Error downloading data dictionary. Please try again.'); } } function createConfetti() { for (let i = 0; i < 50; i++) { setTimeout(() => { const confetti = document.createElement('div'); confetti.className = 'confetti'; confetti.style.left = Math.random() * 100 + 'vw'; confetti.style.background = getRandomColor(); confetti.style.opacity = '1'; confetti.style.transform = 'scale(1)'; document.body.appendChild(confetti); const animation = confetti.animate([ { transform: 'translateY(0) rotate(0deg)', opacity: 1 }, { transform: `translateY(${window.innerHeight}px) rotate(${360 + Math.random() * 360}deg)`, opacity: 0 } ], { duration: 1000 + Math.random() * 2000, easing: 'cubic-bezier(0.1, 0.8, 0.2, 1)' }); animation.onfinish = () => confetti.remove(); }, i * 100); } } function getRandomColor() { const colors = ['#217346', '#28a745', '#20c997', '#ff6b6b', '#4ecdc4', '#45b7d1', '#96ceb4', '#feca57']; return colors[Math.floor(Math.random() * colors.length)]; } console.log('🚀 Premium Data Dictionary Creator by ibusinessmotivation.com');