To open a CSV file on iPhone with its columns intact, save it to the Files app and open it in Numbers or Excel rather than the quick preview. If everything still lands in one column, change the delimiter in Numbers' import settings. Then check dates and long numbers, which can change as the file opens.
Why does a CSV file look garbled on iPhone?
A CSV file looks garbled on iPhone when the app showing it does not split the text at the right character. CSV stands for comma-separated values: a plain text file where each line is a row and a separator character marks each column. If the app reads it as plain text, you see raw lines full of commas.
Two causes cover most cases. The first is the viewer: a quick preview from mail or Files may show the file as text instead of a table. The second is the separator itself. Many files from European banks and software use a semicolon instead of a comma, because the comma is the decimal mark there. An app expecting commas then puts each whole line into one cell.
A third, rarer cause is text encoding. A file saved in an older encoding can show accented letters as odd symbols, while the columns themselves look fine.
Files preview, Numbers or Excel for a CSV on iPhone
Numbers and Excel both turn a CSV into a real table on iPhone, while the preview is only for a glance. Use the preview to confirm you have the right file. Open it in Numbers when you need to fix how it splits, and in Excel when the file is going back to someone who uses Excel.
- Files preview is quick and cannot be adjusted. If columns look wrong there, that tells you nothing about the file itself.
- Numbers imports the CSV into a new spreadsheet and lets you change the separator and encoding afterwards.
- Excel opens CSV files too. The phone app has fewer import controls than the desktop version; the post on Excel mobile app limitations lists what is missing.
On an Android phone the choices are different, and the guide to opening a CSV file on Android covers Google Sheets and Excel there.
Fixing the delimiter for a CSV in Numbers on iPhone
Numbers lets you change the delimiter after it imports the file, which fixes a CSV that landed in one column. Apple's guide to importing an Excel or text file in Numbers on iPhone describes the steps, and notes that you cannot adjust them once you edit the table.
Steps
- In Numbers, tap Browse, find the CSV file and tap its thumbnail.
- Tap any cell in the table, then tap the Format button.
- Tap Table, then Adjust Settings.
- Open the Delimited tab and choose the separator, or type a custom one.
- Set Text Encoding if accented letters look wrong.
- Tap Update.
An example before and after
Here is an example line from a made-up semicolon-separated export:
2026-03-14;CORNER GROCERY;-42,15;1.318,60
Opened with comma as the separator, Numbers splits it in the wrong places, at the decimal commas. With semicolon chosen in step 4, the same line becomes four cells: a date, a description, an amount and a balance. You may still need to tell the spreadsheet that the comma is the decimal mark before the amounts sum.
Do CSV dates and long numbers change on iPhone?
CSV dates and long numbers can change on iPhone, because the spreadsheet guesses each column's type as it opens the file. A date such as 03/04/2026 may be read as March 4 or April 3 depending on the phone's region. A long account or reference number may lose leading zeros or switch to scientific notation.
Check three things straight after opening:
- Dates. Find a day above 12, such as the 14th, and confirm the month is right.
- Leading zeros. Compare one reference number with the original file in the Files preview.
- Amounts. Tap a cell and confirm it is a number, not text, before you total the column.
The safest habit is to keep the original CSV untouched. Make your edits in a copy, so you can reopen the raw file if a column was misread.
CSV files from a PDF conversion that still read as gibberish on iPhone
Some CSV files read as gibberish on iPhone even with the right separator, because the text inside was wrong before the file was made. This happens when a PDF was converted without real text in it, for example a PDF whose letters were turned into drawn shapes. The columns split correctly; the words in them do not make sense.
You can spot this when descriptions show random symbols while dates and amounts look normal, or when every cell is blank. Changing the delimiter will not help. The guide to PDFs with outlined text explains why such files have no readable characters and what a converter has to do to read them.
FastBankConvert is built to export a bank statement PDF as Excel, CSV or JSON, so you can pick the format your phone app handles best. It is preparing to open, and Get started is the way to hear first.