Excel to CSV: check leading zeros, headers and formulas

Prepare the first worksheet

Open the workbook and put the sheet you want to export first. TechSathi spreadsheet tools process the first worksheet, with up to 10,000 data rows and 50 columns. Include a clear header row so you can recognise columns in the output.

Open Excel to CSV , sign in and select the XLSX file within the displayed upload limit. A CSV holds rows and cell text; it does not retain workbook styling, multiple sheets, charts or interactive spreadsheet features.

Keep identifiers as text at the source

An account reference such as 00123 is an identifier, not a quantity. Store identifiers as explicit text in the original sheet where you can. The export keeps string values as strings, but it cannot restore zeros that were already lost when the source application stored a value as the number 123.

A second issue can appear when opening the exported CSV in another spreadsheet program: that program may infer numbers and remove leading zeros again. Use its text-import controls and set identifier columns to text, then compare a few known values with the original.

Review formulas and safety escaping

Imported spreadsheet formulas are not evaluated by TechSathi. Review formula cells and their exported values; if you need calculated results, calculate and check them in the original spreadsheet application first.

CSV exports escape formula-like prefixes to reduce the risk of a cell being treated as a spreadsheet command. This can affect the literal text a downstream system reads. If you are importing into another application, check its format requirements using a small sample before loading the complete file.

Compare a small sample before full import

Generate the CSV, check the preview and download it. Compare headers, row count, a leading-zero identifier, a value containing a comma, a quoted phrase and a Hindi or other non-ASCII value if your source contains one.

Open the file in a text editor when you need to inspect the stored characters without spreadsheet type inference. Then test a small import into the destination system. Confirm that columns align and that encoding and identifiers are correct before importing every row.

Choose a different format when needed

Use CSV to Excel for a workbook output, or Excel to JSON when your next system expects structured records. Neither workflow can recover information that was absent from the uploaded source.

If repeated rows are a separate issue, Remove duplicate rows can keep one copy of matching rows. Check whether duplicates are actually unwanted before removing them, and keep an unchanged source file.

Save and inspect the final copy

Generated exports expire after 24 hours. Download the version you have checked and keep it with the source workbook. Do not assume a successful download means the destination import will interpret every value correctly.