A CSV is a plain-text table. It does not store a cell's display format, data type, font, or leading-zero rule. When a spreadsheet opens 00184 and displays 184, the spreadsheet has interpreted the text as a number. Saving at that point can make the loss permanent. Date values face a similar problem because different programs and locales interpret the same short text differently.
The safest workflow distinguishes identifiers from quantities, uses unambiguous dates, and checks the raw exported result before import. These habits matter for customer IDs, invoice references, postal codes, account codes, employee numbers, tracking numbers, and any field where the characters themselves carry meaning.
Decide whether a value is an identifier or a number
A number represents a quantity that can be added, averaged, or compared mathematically. An identifier labels a record. You would add invoice amounts, but you would not add invoice numbers. That distinction determines whether leading zeros are expendable.
Values such as 000431, 02108, and 00-194-A should usually be treated as text. Even an all-digit account code may be text if the destination expects an exact width. Write this decision down for each source field instead of relying on what a spreadsheet guesses.
Preserve leading zeros before opening a CSV
If you still have the Excel workbook, drop the spreadsheet in MapMyCSV instead of using Save As CSV. That export step is what strips leading zeros. If you must open a CSV in a spreadsheet, import it through the data-import flow rather than double-clicking the file. Set identifier columns to text during import. Different spreadsheet products use different labels for this option, so confirm the preview shows the full original characters before loading the sheet.
Once zeros have been removed and the file has been saved, the CSV usually contains no information about how many zeros existed. Padding every value to a guessed width can create new errors. Restore zeros only from an authoritative rule, such as a documented six-character customer code, or by returning to the untouched source export.
Make dates unambiguous
The value 04/05/2026 is ambiguous. In one locale it means April 5; in another it means May 4. Month names can be readable, but language and abbreviation support vary. Two-digit years add another avoidable decision.
A year-first date such as 2026-05-04 is easy for a person to audit and sorts correctly as text. It is a good normalization target when the destination supports it. Always verify the destination documentation or sample file first. Some systems require a local format or include time and timezone requirements that a date-only conversion cannot satisfy.
Do not normalize an ambiguous value by guessing. If rows contain both 13/04/2026 and 04/05/2026, the first row suggests day-first input, but a mixed-source file may still contain inconsistent conventions. Confirm the source system setting or ask the file owner.
Check timestamps separately
A timestamp is not just a longer date. It may include a clock time, offset, or timezone. Converting 2026-05-04 23:30 without knowing the timezone can move the calendar date. If the destination asks only for a date, establish which business timezone determines that date before discarding time information.
MapMyCSV recognizes and normalizes supported date-like values for its mapped output, but it is not a timezone conversion service. Review date results in the preview and retain the original file for comparison. Unsupported or unclear business rules require manual confirmation.
Inspect the raw CSV, not only the grid
A spreadsheet grid shows its interpretation. A plain-text view shows what will be imported. Inspect a copy of the output with a text editor or a CSV-aware tool. Search for a known leading-zero ID and a known date. Confirm quotes around comma-containing names are balanced and verify the header row has the expected number of columns.
- Keep an untouched copy of the source export.
- Classify IDs, postal codes, and references as text.
- Confirm ambiguous source dates with the file owner or system settings.
- Use the exact date form required by the destination template.
- Inspect raw output values after any spreadsheet save.
- Test a small import and compare created records to the source.
Map without changing unrelated values
Column mapping should be a narrow transformation. Rename and reorder fields to match the target, trim accidental surrounding whitespace, and apply only the date rules the destination needs. Do not strip punctuation, remove zeros, or convert blank cells to numeric zero without a documented requirement.
The CSV column mapping guide explains how to verify source-to-target matches. If the target is a supported QuickBooks workflow, begin with the current sample file and use the QuickBooks CSV import preparation guide.
What MapMyCSV does and does not do
MapMyCSV reads a CSV or Excel spreadsheet in the browser, maps source headers to the target headers you provide, preserves leading-zero identifiers as text, and presents a ten-row preview with validation flags. You can correct suggested pairings before export. A one-time $29 payment unlocks the full mapped CSV download, with no subscription or account.
It cannot recover characters already lost from a saved source, determine the meaning of an ambiguous date without context, choose accounting treatment, or guarantee that a third-party system will accept a file. The destination's current rules and your review remain authoritative.
FAQ
Why do leading zeros disappear from a CSV?
A CSV stores plain text, not spreadsheet formatting. When Excel or another sheet opens 00184 as a number and you save, the zeros are gone from the file. Postal codes, customer IDs, account codes, and padded references are common casualties.
Can MapMyCSV recover zeros already stripped from a saved file?
No. Once zeros are removed and the CSV is saved, the file usually has no record of how many zeros existed. Padding every value to a guessed width can create new errors. Restore zeros only from a documented rule or by returning to an untouched source export.
Should I open a CSV by double-clicking it in Excel?
Prefer not to. Double-click lets the spreadsheet guess types and can strip leading zeros or reinterpret dates. If you still have the workbook, drop the spreadsheet in MapMyCSV instead of Save As CSV. If you must open a CSV, use the data-import flow and set identifier columns to text before loading.
What CSV date format should I use for imports?
Use the form the destination documents. Short values like 04/05/2026 are ambiguous across locales. A year-first date such as 2026-05-04 is easier to audit and sorts as text, but only use it when the target accepts it. Do not normalize by guessing when source conventions may be mixed.
Is MapMyCSV a timezone converter?
No. MapMyCSV recognizes and normalizes supported date-like values for its mapped output, but it is not a timezone conversion service. Converting a timestamp without knowing the offset can move the calendar date. Review date results in the preview and keep the original file for comparison.
How do I keep postal codes and account codes as text?
Treat them as identifiers, not quantities. Import identifier columns as text, confirm the preview shows the full original characters, and inspect the raw CSV before the real import. Even an all-digit account code may need an exact width the destination expects.
Should I use a leading apostrophe to force text?
Not blindly. Some spreadsheets use a leading apostrophe for text display. Some exports omit it; others write it into the CSV. Inspect the actual output so you do not import an unwanted apostrophe as part of the ID.
Do my CSV or Excel files leave the browser in MapMyCSV?
No. Mapping and preview run in the browser. That matters when exports contain client IDs, account codes, or payroll-style references. MapMyCSV does not upload your rows to a remapping server.
What does the $29 unlock include?
The free preview shows the first ten mapped rows with validation flags. A one-time $29 payment unlocks the full mapped CSV download. There is no subscription or account. MapMyCSV cannot recover characters already lost from a saved source or guarantee a third-party system will accept the file.