Keep leading zeros and long IDs when moving CSV to Excel

Display difference or changed value?

If the source is already rounded, do not guess a replacement.

Keep only these columns as text

Keep customer_id and sku as text. Select amount as a number only after checking it. Quoting alone does not always force Excel to keep a type.

customer_id,sku,amount
00123,9007199254740993,1200
00007,000045,980

The expected result is 2 rows, 3 columns, text IDs, and a total of 2180.

Create the handoff with Web-Tool

1. Save the fixture and keep the source CSV unchanged.
2. Open Table to Excel, load the file, and inspect the imported table and types.
3. Keep identifier columns as text and choose only checked numeric columns.
4. Save the .xlsx and verify cell types, values, row count, and column count with an independent reader.

This guide's files and your input stay in the browser. Customer IDs and source files are not sent to a URL, analytics, or an external server.

The Excel-only alternative

1. Use Data → From Text/CSV to load the original.
2. In the transform step, set customer_id and sku to text.
3. If automatic conversion changed a value, restart from the original rather than correcting the display afterward.
4. Verify the saved cells for the Excel version and recipient system you actually use.