EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Convert Excel to CSV
 

Convert Excel to CSV

Madhuri Thakur
Article byMadhuri Thakur

Convert Excel to CSV

Convert Excel to CSV File

CSV is one of the formats available for saving files in Excel. We save files in different formats like Word, PowerPoint, Excel, Text, Macro enabled books, etc. However, before learning how to convert an Excel file to CSV, first, we will understand the full form of CSV and its importance.

 

 

The full form of CSV is Comma-Separated Value. It is called a Comma separated value because it separates each column in CSV. It stores the data in table format as plain text as it stores data as plain text, various software programs, and applications for import and export. Therefore, it will organize better when working with huge data.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Convert Excel to CSV?

Let’s use examples to understand how to convert Excel to CSV and different kinds of Excel CSV formats.

You can download this Convert Excel to CSV Template here – Convert Excel to CSV Template

Example #1 – Conversion of Excel to CSV

Consider a file with data with Names, Ages,s and Salaries, as shown in the screenshot below.

Excel Data

Once data is inserted, try to save the file with the Save As option. Select the path where you want to save the file and select the Save as type as CSV (Comma delimited), which is highlighted.

Convert Excel to CSV

Give the file name as per your requirement and save it. Here I have given the Name Convert Excel to CSV.

Now we will see how it is saved. Observe the file that is saved in CSV (Microsoft Excel Comma Separated Value File) is our CSV file. We can observe the icon is also different from the Excel file.

CSV file

Now we saved the file in CSV, but if we observe there is “(Comma delimited),” similarly, we have some other formats of CSV files. We will see each of the Excel CSV files and what is the meaning and purpose of different formats.

There are 4 different formats of CSV files. They are Comma delimited, Macintosh, MS-DOS, and UTF–8.

Formats of CSV file

We can observe different CSV formats in Excel. Now we will see an explanation for each of them.

  1. CSV (Comma delimited) – This format converts the data to plain text separated by commas, and another Windows Operating System can use this format files.
  2. CSV (Macintosh) – This format files save the same as comma-separated files but can be used in the Mac operation system.
  3. CSV (MS-DOS) – This format file can use in the MS-DOS operating system.
  4. CSV UTF-8(Comma Delimited) – UTF-8 uses 1 to 4 bytes for each symbol.

When we save a CSV format file, it will only save the currently active tab of Excel. If we want all the sheets in Excel in CSV format, we need to do it individually. Regarding this, we may get the message while saving the file in the form of a warning pop-up.

Do you want to save it? Just click, Yes to proceed further. In addition, we may get another pop-up message stating that our saved file has features that may not be compatible with CSV format.

Windows Warning Message 1

Windows Warning Message 2

I hope you understand how to convert Excel to CSV and the different CSV formats available.

If we want to see the CSV in text format, in case it opens in Excel, select the file and right click then choose the option Open with.

Open With

Choose Notepad and see how the data is stores in the CSV, separated by commas. Observe Comma separate every column.

CSV format in notepad

Open a CSV file in Excel.

We can access our CSV files from our Excel spreadsheets directly. We will see how we can do that.

Open an Excel file and click on the File menu, then the below screen will appear. From that, Choose the Open option from the list of options. It will take to share the drive path, go to the path where our file is saved, and select. CSV file.

Open CSV file

Then the file opens, as shown in the below screenshot.

converted data in Excel

Suppose we observe A’s salary as 1E+11 because as we directly opened CSV in Excel, it converts to exponential format in case any number starts with Zeros. In that case, it will convert to a mathematical format to remove the Zeros. It will display only the other part of the number.

Example #2 – Conversion of Excel to CSV with UTF-8

First, we will understand why we need to use UTF-8. When an Excel spreadsheet has foreign characters and if we follow the same process of “save as” in the CSV format, it may not work because that way is suitable for ASCII characters if the text is apart from the ASCII characters that are in a foreign language it may distract the data.

UTF-8 uses 1 to 4 bytes for each symbol. It is most useful when your file has ASCII characters as it stores in one byte each. Suppose we have a file with Chinese text, as shown in the screenshot below. To convert the file with foreign language characters, follow the below procedure.

text in the Chinese language

To convert to CSV, save the file in the Unicode Text format, as shown in the screenshot below.

save as unicode text

Please open the file; it will look like the below text file.

CSV file in notepad

If we observe the above screenshot, each column is separated by tab space. Each column is separated by the “,” character in the CSV file.

So, we need to replace the space with the “,“. Copy the space between two columns.

copy data

Press Control+H to find and replace the text. In “find what”, give the control v to paste the copied space. In Replace with option input “,” and click on the option Replace All.

Convert Excel to CSV - Replace All

Once we click Replace All, space will be replaced by “,”.

Convert Excel to CSV

Save the file in “.CSV” format and change the encoding option to UTF-8. Change the save as type as All Files.

Convert Excel to CSV

Things to Remember About Convert Excel to CSV

  • The full form of CSV is Comma-Separated Value.
  • To convert an Excel to CSV, use the Option save while saving the file and selecting the CSV format.
  • There are 4 different CSV formats, and they are CSV (Comma delimited), CSV (Macintosh), CSV(MS-DOS), and CSV UTF-8.
  • We can convert all sheets of the Excel workbook at a time, similar to Excel to PDF conversion.
    .

Recommended Articles

This is a guide to Convert Excel to CSV. Here we discuss how to Convert Excel Files to CSV, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel REPLACE Function
  2. CSV Files into Excel
  3. Excel Export to PDF
  4. Convert Numbers to Text in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Convert Excel to CSV Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Convert Excel to CSV Template

EDUCBA

डाउनलोड Convert Excel to CSV Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW