Duplicate CSV Headers in the B... Note

Duplicate CSV Headers in the Browser: Three Naming Rules and Where They Disagree

This report details OnePassApps Data Studio's CSV column naming behavior as of November 4, 2026. The author measured three distinct scenarios: duplicate headers, added columns, and manual renames. Each scenario exhibits different rules for handling column names, leading to inconsistencies. The duplicate path intelligently suffixes repeated headers and newly added columns, ensuring unique output keys. However, it is case-sensitive and provides warnings in the Viewer tab, not the To JSON tab.The added-column path assigns a fixed base name ("Extra 1") to new columns, incrementing with an underscore and number if necessary. This path is also case-sensitive, but its base name can unintentionally conflict with user-defined columns. In contrast, the rename path is case-insensitive and prevents renaming a column to any existing name, including those generated by the app. This strictness highlights the discrepancies in how the three paths compare and reserve names.A critical finding is that while two paths are case-sensitive, the rename path is not, creating a single namespace with conflicting comparison rules. This allows for columns to exist that differ only by case, such as "extra 1" and "Extra 1," which the app's duplicate-header warnings fail to flag. All warnings related to naming issues are confined to the Viewer tab, leaving the To JSON tab devoid of such crucial information upon file download.The author suggests unifying the naming comparison rule across all paths to the rename path's stricter, case-insensitive behavior. This would ensure consistent name resolution and prevent unexpected column conflicts. Additionally, the fixed "Extra 1" base name for added columns should be reconsidered to avoid accidental namespace collisions with user data. The report emphasizes that these findings are based on a specific build and limited test cases.