Recover Missing Data from a CSV File in Excel for Mac
Question details
Determine whether data missing from a CSV file was deleted or is being displayed incorrectly, then check available recovery sources on a Mac.

- Product
- Microsoft Excel for Mac and CSV files
- Device & OS
- macOS
- Scenario
- The user opens a CSV file and needs to restore or view records that appear to be missing.
- Observed behavior
- Some or all expected CSV data does not appear in Excel. CSV files do not include Excel workbook version history.
Duplicate the CSV file in Finder before opening, converting, or saving it. Check the copy in a plain-text editor first, because a CSV may contain the data even when Excel imports or displays it incorrectly.
Check whether the CSV data is still present and import it with the correct settings
Use this first when records appear missing after opening a CSV directly in Excel.
A CSV is a plain-text file. If the missing rows or columns are visible in a text editor, the source data is likely intact and the issue is usually the delimiter, encoding, or column-type settings used during import.
In Finder, select the CSV file, press Command+C, then press Command+V to create a copy. Perform the following checks on the copy rather than the original.
Select the original CSV in Finder and choose File > Get Info. Compare its size with an earlier copy, exported source, or cloud version if available. A very small file may indicate that its contents were overwritten or removed.
Control-click the copied CSV, choose Open With > TextEdit, and inspect the rows near the missing data. If needed, choose Format > Make Plain Text in TextEdit before reviewing the comma-, semicolon-, or tab-separated values.
In Excel, open a blank workbook and select Data > From Text/CSV. Choose the copied file, then select the correct file origin/encoding and delimiter in the import preview before clicking Load.
In the import preview, confirm that identifiers, dates, and long numbers are assigned suitable data types. After loading, use Data > Filter to check whether filters or sorting are hiding the expected records.

Look for an unsaved Excel copy and available Mac or cloud backups
Use this when the data is absent from the CSV text itself or the file was overwritten after editing in Excel.
Re-save an intact CSV using UTF-8 encoding
Use this when the records are present in a text editor but characters, delimiters, or imported columns are corrupted in Excel.
Inspect and Import a CSV File Accurately with WPS Spreadsheets
WPS Spreadsheets lets you open a copied CSV, verify whether its values are present, and import the file with the appropriate delimiter and encoding settings. This helps distinguish display and parsing issues from data that is genuinely absent from the file.
- 1. Make a copy of the CSV file: In Finder, duplicate the CSV file and keep the original unchanged while you test the copied version.
- 2. Open a blank spreadsheet: Launch WPS Spreadsheets and create a new blank workbook from the Home screen.
- 3. Import the CSV file: Select Data > Import Data > From Text/CSV, then choose the copied CSV file from Finder.
- 4. Set the import options: In the import window, select the delimiter and encoding that make the previewed rows and columns display correctly, then click Import or Open.
- 5. Check for hidden records: Select Data > Filter to review filtered rows, or use Data > Sort to locate records that may be outside the expected order.

Frequently Asked Questions
Why does my CSV look empty or incomplete in Excel for Mac?
The data may be separated with a delimiter Excel did not detect, encoded differently, filtered, or imported with unsuitable column types. Open a copy in TextEdit, then use Excel Data > From Text/CSV and select the correct delimiter and encoding.
Can Excel restore an earlier version of a CSV file?
A CSV does not carry Excel workbook version history. You may be able to restore a previous copy from Excel recovery files, Time Machine, or the version history of OneDrive, iCloud Drive, Dropbox, or another cloud service.
Where are Excel AutoRecovery files on a Mac?
In Finder, choose Go > Go to Folder and check ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/. Open relevant files in Excel and save them under a new name.
Should I double-click a CSV file to open it in Excel?
It is safer to open a blank workbook and choose Data > From Text/CSV. The import preview lets you select the delimiter, encoding, and data types before Excel loads the values.
What if the missing data is not visible in TextEdit or any backup?
If the records are absent from the CSV text and no recovery file, cloud version, Time Machine backup, or temporary copy exists, spreadsheet software generally cannot recreate the deleted content.




