If a product name, price and quantity appear together in one cell, check the column delimiter before editing individual values. A file may use semicolons while the importing application expects commas. The data may still be present, but its boundaries are being read incorrectly.
Match the symptom to the check
| Symptom | Check first |
|---|---|
| A whole row in one cell, with separators visible | Import delimiter |
| Columns separate but Thai letters are unreadable | Text encoding |
| Only some rows have extra columns | Quoting and separators inside values |
For example, the invented header Product;Price;Quantity needs a semicolon delimiter to become three cells. A CSV extension alone does not identify the right separator. A genuinely single-column file may need no correction.
Convert, then inspect the workbook
FileMyLove's document converter guesses between comma, semicolon, tab and pipe before writing XLSX. Conversion runs in your browser without uploading the file. Detection is a heuristic, not a guarantee, and there is currently no manual delimiter selector.
- Keep the original CSV.
- Choose the file and XLSX output.
- Download and open the workbook.
- Compare headers, column counts and several rows against the source, especially addresses and notes.
Our recommendation is to inspect the beginning, middle and end, rather than relying only on the header row.
If detection is wrong
Microsoft documents a From Text/CSV import flow with a Delimiter selector and an immediate preview. In Excel versions offering that flow, choose the separator that produces the expected columns before loading the data.
Avoid replacing punctuation across the entire file: a separator character may also belong inside a value. See commas and line breaks inside CSV cells when only particular rows are affected.
Before sharing
Open the actual XLSX you intend to send and check that names, prices and quantities sit beneath the correct headers. When sending CSV instead, tell the recipient which delimiter it uses. Correct column boundaries are only one part of checking the data.
