Back to feed
Dev.to
Dev.to
6/29/2026
The original headline is: "How Microsoft Excel Quietly Breaks Your JSON Imports (And How to Fix It)"

The original headline is: "How Microsoft Excel Quietly Breaks Your JSON Imports (And How to Fix It)"

Original: How Microsoft Excel Quietly Breaks Your JSON Imports (And How to Fix It)

Short summary

Microsoft Excel adds a hidden BOM character when exporting CSVs, breaking automated parsers in data pipelines. Python's 'utf-8-sig' encoding strips it automatically. One-line fix for a common import error.

  • •Excel's default CSV export includes a BOM character that breaks automated parsers
  • •Use 'utf-8-sig' encoding in Python to transparently remove the BOM
  • •Simple fix prevents mysterious parse errors in data pipelines

Generated with AI, which can make mistakes.

Read full article at Dev.to

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more

CSV to JSON: A Beginner's Guide
Dev.to
The original headline is "Stop Guessing Why Your Shopify Product CSV Import Failed" - that's 9 words. Let me check the rules.
Dev.to
The original title is: "Four silent XLSX export bugs in a Jira Forge app and how we fixed them"
Dev.to
Hidden Unicode characters silently corrupt code and waste debugging hours
Dev.to