EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools CSV Files into Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

CSV Files into Excel

By Soumyashree DasSoumyashree Das

CSV Files into Excel

CSV Files into Excel (Table of Contents)

  • Introduction to CSV Files into Excel
  • Methods to Open CSV Files in Excel

Introduction to CSV Files into Excel

MS Excel is an interesting tool when it comes to handling data. Excel data can be imported in many software, and even Excel can import data from different sources. Most of the time, we have unstructured data or data in different formats. For that, the solution is Excel. It converts data into a tabular structure. CSV or Comma Separated Values file is a commonly used format to store important data related to statistics, contacts, etc. Importing data makes it easier to read CSV files, but sometimes there are unexpected data changes with change in format and data looks scrambled. CSV files can be imported further to many software like SAS, Tableau, etc., for Data analysis and visualization.

There are different techniques for CSV data to look better and organized in Excel. Below are some examples and methods to import and read data in Comma Separated Values format.

Example

Let us suppose we have a text file that has data separated by commas.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

excel csv file 1

  • This file is saved as CSV file with .csv extension.

Sample 1

  • Now, the CSV file is ready for use. Next, we’ll go to Excel > File > Open > Browse. Then select the saved CSV file as shown below.

excel csv file 2

  • We can see that the CSV file is imported now.

excel csv file 3

  • But the data is not clear. We can apply formatting to the data and see the change as shown below.

excel csv file 4

Finally, the CSV file is converted into an Excel file and is organized now.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,547 ratings)

Explanation

CSV files have data separated by commas. These files can be created in Notepad, Excel, etc. CSV files are used in organizations for transmitting and storing data. There are multiple ways for converting CSV files into Excel, as given below:

  • Directly open CSV files with Excel.
  • Opening CSV files through the windows explorer option.
  • Importing CSV file data into Excel.

CSV files are converted into Excel for supportability as it is hard for Data analysts to draw insights from the data. After conversion, each value separated by commas is placed into each cell separately, which makes the data clear. There are multiple advantages of converting CSV files into Excel, including

  • Better storing of data and calculations as per need.
  • Any other software cannot open improved data security as Excel files.
  • Saving CSV file in tabular manner with .xlsx extension.
  • Data display in a perfect manner with each value in each cell.
  • The formatting of data becomes easier and convenient.
  • Analysis, Graph plotting, and Visualization of numerical data after conversion of CSV file into Excel.
  • Programming and macros using VBA for data development.

Methods to Open CSV Files in Excel

There are various methods of opening CSV files in Excel, as mentioned above. We’ll see in detail how these methods work.

1. Opening CSV file in Excel

  • CSV files can be opened in Excel, and it becomes a new file in Excel later. Suppose we have a CSV file with data separated with commas, as shown below. This file is a text file saved with a .csv extension.

excel into CSV File 2-1

  • Here the first row is the header, and below are the data about employees of the company. A comma separates each value. We’ll import the file in Excel by going to Excel now.

excel into CSV File 2-2

  • We can Go to File at the top left corner and then Open > Browse, as shown below.

excel into CSV File 2-3

  • Then we’ll select the file from the location. If we can’t see the file, then at file type “All Excel files” can be changed to “All files” and then select the CSV file as shown below.

Employee 1

  • Now, our CSV file is ready in Excel.

excel into CSV File 2-4

  • To make the data clear and organized, we can apply some formatting to differentiate the headers from other fields, and finally, the file is ready for further use.

Employee 2

2. Using Windows Explorer if we’re using Windows OS

  • We’ll have to go to the directory where the CSV file is located and right-click on it. Here our file is located on the desktop. Then go to Open with > Excel, and the file will be opened in Excel.

Employee 4

  • After selecting Excel, it becomes the default program from then onwards; when we click on it, it will be opened in Excel by default. Here is the CSV file open in Excel.

excel into CSV File 2-4

After a bit of formatting, the file is ready to use.

Employee 2

3. Importing CSV File by Importing Data Externally

  • This method helps in importing data in the current worksheet but is a bit longer process than the above two processes. First, we need to open MS Excel and select a blank workbook from it. A new workbook is now ready. we’ll place the cursor where we want to import the data.

upload file 3-1

  • Next, we’ll have to go to the “Data” tab then go to “Get External Data”, as shown below.

DATA 1

  • Then we’ll select “From Text” from the option as the CSV file was created in “Notepad”.

From Text

  • We have to browse to the location where the file is stored. As we have imported the file earlier, it is showing as a CSV file. If we are using it for the first time also, the process is the same.

Employee 5

  • Now, we can see a window that has some options, as shown below.

Text Import Wizard

  • Then, we have to click on “My data has headers” and choose the file type as “Delimited”, and click “Next”, as shown below.

Data Header 1

  • A new window comes as shown below.

Text Import Wizard 2

Now, untick the “Tab” and select “Comma”, and click “Next”.

general - text wizard

Then we’ll click on the “Finish” button, and a new window is displayed where we need to select the “Existing worksheet”.

Existing Workbook

  • Finally, the CSV file will be imported, and the data is displayed below.

excel into CSV File 2-4

  • With little formatting, the data can be organized and used further for analysis.

Employee 2

Things to Remember

  • Opening a CSV file is easy, and it doesn’t change the format of the file to .xlsx or any other file.
  • By default, the file is not organized. After importing it, we need to apply formatting to make the data look better.

Recommended Articles

This is a guide to CSV Files into Excel. Here we discuss How to open CSV Files in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Formatting Text in Excel
  2. HLOOKUP Formula in Excel
  3. Excel Export to PDF
  4. Autofit Row Height in Excel
Popular Course in this category
All in One Excel VBA Bundle (120+ Courses)
  120+ Online Courses |  500+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Training (23 Courses, 9+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more