Deleted File Recovery

Recover Missing Data from a CSV File in Excel for Mac

Bushra ParveenBushra Parveen Nov 12, 2026 870 views

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.

Recover Missing Data from a CSV File in Excel for 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a working copy in Finder

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.

2
Compare the file size

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.

3
Open the copy as plain text

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.

4
Import instead of double-clicking the CSV

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.

5
Review column types and the imported range

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.

Check whether the CSV data is still present and import it with the correct settings
CSV limitation: CSV files store text values only and do not retain Excel workbook version history, worksheets, formulas, or AutoSave versions.
Work with CSV files in WPS Spreadsheets

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. 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. 2. Open a blank spreadsheet: Launch WPS Spreadsheets and create a new blank workbook from the Home screen.
  3. 3. Import the CSV file: Select Data > Import Data > From Text/CSV, then choose the copied CSV file from Finder.
  4. 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. 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.
Open and review CSV text data before making changes.Choose the appropriate delimiter and encoding when importing CSV files.Use filters and sorting to find records that may appear hidden.Compatible with Microsoft Excel XLSX, XLS, and CSV formats.
microsoft office alternative - wps office

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.