Edit a CSV without Excel
Excel drops leading zeros and changes dates on its own. In the browser editor, values stay as written.
Steps
- Drop the CSV on "Edit a CSV in your browser". The encoding is found for you.
- Pick a cell and type to change it; click a column name to sort; filter rows in the box above.
- Replace in bulk with "Replace"; delete checked rows with "Delete chosen rows". Changed cells are marked.
- Save as CSV, in the original encoding or for Excel.
Questions
- Are leading zeros kept?
- Yes. Values are kept as text.
- Made a mistake?
- Ctrl+Z or Undo takes it back.
The CSV is never sent anywhere; everything runs in this browser.