If you need control over how Excel interprets a CSV file, import it with Data > From Text/CSV instead of simply double-clicking the file. Excel shows a preview so you can check the delimiter and data before loading it into the workbook.
Import a CSV with the Data tab
- Open the Excel workbook where you want the data.
- Select the Data tab.
- Choose From Text/CSV.
- Select the CSV file and choose Import.
- Review the preview and detected delimiter.
- Select Load, or choose Transform Data if the data needs cleanup first.
Why importing can be better than opening the file
Double-clicking a CSV is convenient, but Excel automatically interprets the values. That can be undesirable for identifiers with leading zeros, unusual date formats, or data that needs a different delimiter. The import workflow gives you more control and can send the data through Power Query before it reaches the worksheet.
Remember that CSV is not an Excel workbook
A CSV stores plain delimited values. It does not preserve normal workbook features such as formulas in multiple sheets, cell formatting, charts, or several worksheets. If you make changes that depend on Excel features, save a copy as an Excel workbook rather than overwriting the only CSV copy.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.