.csv

Search services

Search tools and open pages quickly

מדריך למוצר · 6 דק׳ קריאה

UTF-8, BOM, and Excel: making CSVs open correctly on every desktop

When to use UTF-8 with or without a byte-order mark, how Excel on Windows interprets encodings, and how to validate handoffs to pipelines and Mac teammates.

פורסם ב-21 במרץ 2025 · Table

UTF-8 is the default interchange encoding for modern stacks, but Excel on Windows historically preferred legacy code pages unless it detects a BOM (byte order mark) at the start of the file. A BOM helps Excel guess UTF-8; some Unix tools and strict parsers treat the BOM as an extra character in the first column header, so the "right" choice depends on your downstream consumer.

Practical rules

  • For analytics and warehouses, prefer plain UTF-8 without BOM unless your Windows stakeholders insist otherwise.
  • After export, open in our viewer and spot-check headers and first rows for stray characters or mojibake.
  • Document your team's standard in a short internal note so contractors do not flip encoding per project.

When in doubt, validate the same file in two tools (browser viewer + target database loader) before promoting a file to production.

← כל המאמרים

בשימוש צוותים מובילים

לוגואים בגלילה (כל קישור פותח את אתר המותג בלשונית חדשה): Google, Apple, Meta, GitHub, Stripe, Shopify, Databricks, Snowflake, Notion, Vercel, Intel, NVIDIA, Netflix, Spotify, Airbnb, Yale, Harvard University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley, Princeton University, California Institute of Technology, Columbia University, University of Chicago, Cornell University, Duke University, Carnegie Mellon University, Georgia Institute of Technology, Johns Hopkins University, Northwestern University, University of Toronto, McGill University, University of Oxford, University of Cambridge, Imperial College London, University College London, ETH Zurich, EPFL, Technical University of Munich, Sorbonne University, KU Leuven, National University of Singapore, Nanyang Technological University, Tsinghua University, Peking University, The University of Tokyo, KAIST, Seoul National University, University of Melbourne, Australian National University, University of Sydney, The University of Hong Kong.