Excel to CSV (and Back) Without Losing Data
August 25, 2026 · Updated October 23, 2026 · RividTech Experts Team
Excel workbooks (.xlsx) and CSV files are both “spreadsheet data,” but they are not equivalent. Excel can store multiple sheets, cell types, formulas, and formatting. CSV is a plain-text table: one grid, text fields, no formulas. Converting either way is routine - and routinely lossy if you ignore what each format can actually hold.
This guide covers Excel → CSV and CSV → Excel with the pitfalls that cause silent damage, plus private browser tools so workbook contents never upload to a third-party server.
What you gain and lose with CSV
CSV is ideal for exchange: databases, scripts, git-friendly snapshots, and systems that only accept delimited text. You gain simplicity and portability. You lose:
-
Multiple sheets - CSV is one table. Extra sheets need separate files or a different format.
-
Formulas - only computed values survive, not the formula text (unless you specially export it).
-
Formatting - colors, column widths, and number formats are not part of CSV.
-
Strict types - everything is text until a consumer parses it again.
If you need nested structures or API payloads instead of a flat table, consider Excel to JSON rather than CSV.
How to convert XLSX to CSV online
-
Prepare the sheet. Remove title blocks, merged cells, and side notes so the first row of the used area contains headers and every following row is data. Convert date columns to text if the destination needs readable dates.
-
Open the workbook. Drop an
.xlsxfile into the XLSX to CSV converter. It reads the workbook in your browser without uploading it. Older.xlsfiles need to be saved as.xlsxfirst. -
Choose one sheet. Select the tab that holds the table you want. Each CSV export covers one sheet, so download other sheets separately and give the files distinct names.
-
Check and download. Review the CSV output and any limit warnings, then copy it or download the CSV under the workbook’s name. Formula cells use their saved results; recalculate and save the workbook in Excel first if those results may be stale.
-
Verify the exported text. Open the result in the CSV & TSV preview before you ship it to a database. Check header alignment, IDs, dates, and the number of rows. The preview displays up to 500 rows; use its total row count when comparing with the source.
The converter accepts workbooks up to 25 MB, reads up to 50 sheets, and caps each sheet at 100,000 rows and 500 columns. A warning identifies data left out when a limit is reached. Larger exports need a workflow that can process the full workbook.
Dates, leading zeros, and other classic traps
-
Dates. Excel stores dates as serial numbers (days since 1900) with a display format on top. Depending on export path, you may see
2026-08-25,08/25/2026, or the raw serial. Tools that read the stored value, including our Excel to CSV converter, output the serial:46037for 2026-01-15. To keep readable dates, add a helper column such as=TEXT(A2,"yyyy-mm-dd")before converting, and agree on ISO format (YYYY-MM-DD) with whoever imports the file. -
Leading zeros. ZIP codes, employee IDs, and phone fragments often need to stay text. If Excel already coerced them to numbers, the zeros may already be gone - fix in the workbook (format as text) before converting.
-
Large numbers. Long IDs can lose precision in floating point. Keep them as text fields when identity matters.
-
Encoding. Prefer UTF-8 CSV when non-English characters matter. Mismatched encoding shows up as mojibake in the next tool.
-
Delimiter locale. Some regions expect semicolon-separated “CSV.” Confirm what the destination system wants and select that separator when exporting.
CSV to Excel: when you need a workbook again
Going back to Excel is useful for sharing with colleagues who live in spreadsheets, adding filters, or attaching a familiar .xlsx to an email. CSV to Excel builds a workbook from your table in the browser.
-
Clean the CSV first if it is messy - Remove Duplicates , Column Tools , Find & Replace .
-
Remember that Excel may re-interpret types when opened (dates, scientific notation). Spot-check critical ID columns after open.
-
One CSV becomes one sheet. Multiple tables mean multiple conversions or a merge strategy you control.
Multi-sheet workbooks
CSV cannot represent a whole multi-sheet workbook in one file. Practical options:
-
Export each sheet to its own CSV (naming files clearly).
-
Convert the sheet you need to JSON with Excel to JSON if structure matters more than spreadsheet UI.
-
Keep the
.xlsxas the source of truth when formulas and multiple tabs are load-bearing.
Getting started
Convert with Excel to CSV or CSV to Excel , then verify with CSV Preview . If JSON is the real destination, skip straight to Excel to JSON . Your file stays on your device either way.