Practical file guide

Convert Excel and CSV while preserving identifiers

By SumifyPDF · Updated

CSV describes rows of text fields; XLSX describes a workbook with cell types, formulas and many other features. Moving between them is not a lossless round trip. Choose whether you need a text data transfer, an editable text workbook or the original spreadsheet behavior.

Open Excel and CSV conversion

Export one deliberate spreadsheet range

Select a visible sheet and optionally a range such as B2:H150. Export uses saved displayed values, including hidden rows and columns inside that range. Formulas are not recalculated or copied into CSV. Recalculate and save beforehand, and remove fields the recipient should not receive.

Choose encoding and delimiter

CSV input must be UTF-8. Comma, semicolon and tab are explicit options; regional assumptions are not guessed. Quotes can preserve delimiters and line breaks inside a field. Every accepted row must have the same number of fields. If an accented name looks wrong, correct the source encoding instead of accepting corrupted text.

Understand formula-safe CSV

Spreadsheet applications may interpret fields beginning with an equals sign, plus, minus or at sign as formulas. The exporter prefixes formula-like fields with an apostrophe and reports the count. This can also affect an ordinary negative value. The preview displays the original value, so inspect the downloaded CSV in its receiving application and import columns as text when appropriate.

Import CSV without guessing types

CSV to Excel writes all fields as explicit text cells. Leading zeros, long identifiers and formula-like strings remain text. Empty cells remain empty text rather than invented zeros. Convert actual amount or date columns deliberately in Excel if you want calculations; leave identifiers alone.

Verify the full result

The on-page preview shows at most 30 rows and 10 columns. The download contains the complete accepted range, not just the preview. Compare row counts and a few first, middle and last records. Keep the original workbook when formulas, formatting or other sheets still matter.