Why did percentages become decimal numbers after reading Excel?

FAQs
1

Sparkflows normalizes percentages during ingestion:

  • % is a display format, not a data type

  • Percentages are converted to numeric equivalents

Example:

  • 9.4% → 0.094

  • 100% → 1.0

Why this is correct

This ensures:

  • Accurate calculations

  • Consistent numeric behavior

  • Compatibility with aggregations and ML models

Recommendation

If you need percentage-style display:

  • Format during Excel export

  • Keep numeric values correct in Sparkflows