.csv

El contenido principal está en inglés. La interfaz usa el idioma que seleccionaste para facilitar la navegación y la accesibilidad.

Guía

Prepare CSV data so Google Sheets imports stay reliable

Normalize headers, dates, and delimiters so Google Sheets imports your CSV without silent errors. Use a local grid to validate rows before you sync cloud spreadsheets.

Google Sheets is forgiving until it is not: a single rogue quote can shift columns, locale-specific numbers become text, and timestamps import as strings that sort incorrectly. Most failures trace back to the CSV itself, not the Sheets UI.

Reviewing the flat file in a dedicated grid first lets you spot structural problems early, reorder columns for human readers, and export a cleaned variant without round-tripping through multiple cloud uploads.

Headers, delimiters, and quoting

Sheets expects a consistent delimiter and a single header row without blank lines above it. Embedded newlines inside quoted fields are valid CSV, yet many hand-edited files break quoting and create ragged rows that confuse importers.

If your team mixes European decimal commas with comma delimiters, consider switching the export to TSV upstream or enforcing explicit quoting around affected columns. Document the choice so vendors stop sending ambiguous files.

Dates, currencies, and ID columns

Store ISO-8601 dates when possible so Sheets parses chronology without locale guessing. For currency, either keep a dedicated currency code column or store minor units as integers to avoid floating point surprises.

Leading zeros in SKU or ZIP fields disappear when a column is interpreted as numeric. Mark those columns as text in the source system or prepend a safe prefix during export so the grid preserves fidelity.

Use Table before you upload

Load the CSV locally in Table, search for suspicious patterns like double commas or inconsistent row length, and hide columns that are not part of this review. When the subset looks stable, download a fresh CSV and import that into Sheets.

That sequence keeps sensitive operational data off unnecessary services during the messiest cleanup phase, while still landing in Sheets for collaboration once structure is trustworthy.

Preguntas frecuentes

Why does Google Sheets split my CSV into the wrong columns?
Usually a missing quote, wrong delimiter, or inconsistent row width. Inspect the raw file around the first bad line. A grid viewer helps because you can scroll while keeping headers aligned.
Should I use CSV or Excel format for Sheets?
CSV is lighter and pipeline friendly. XLSX preserves types and multiple sheets but can hide formatting complexity. Pick based on whether you need strict text fidelity or richer typing.

Páginas relacionadas

Usado y confiado por equipos líderes

Logotipos en carrusel (cada uno abre la web de la marca en una pestaña nueva): 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.