How do I convert Excel to CSV in Windows?

Asked By: Kenya Bellvis | Last Updated: 8th January, 2020
Category: technology and computing shareware and freeware
4.7/5 (270 Views . 43 Votes)
How to convert Excel file to CSV
  1. In your Excel workbook, switch to the File tab, and then click Save As.
  2. In the Save as type box, choose to save your Excel file as CSV (Comma delimited).
  3. Choose the destination folder where you want to save your Excel file in the CSV format, and then click Save.

Click to see full answer


Keeping this in consideration, how do you convert Excel to CSV in Windows 10?

Steps to Convert Excel (.XLS) file to .CSV format in Windows 10

  1. Open .Excel file which you want to convert.
  2. Now do whatever editing you want.
  3. Here you will see left top corner FILE Tab, click on that.
  4. Now it will give lot's of options to new, open, save, save as.

Also Know, how do I convert an Excel file to a Mac in Windows? How to import Microsoft Excel spreadsheets into Apple Numbers

  1. Launch Numbers (it's in the Applications folder of your Mac).
  2. In the window that automatically opens when you launch the app, navigate to the location of your Excel file.
  3. Once you've located your file, select it and click Open.

People also ask, how do you convert Excel to CSV without changing format?

  1. Select the column with such data.
  2. Open Data >> Text to Columns.
  3. Select Delimited >> Next >> Deselect all delimiters >> Next >> Select Text as Column Data Format and Finish.
  4. Save as csv.

What does a csv file look like?

A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a . csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.

26 Related Question Answers Found

How do I convert CSV to Xlsx?

How to convert csv to xlsx?
  1. Upload csv-file.
  2. Select «to xlsx» Select xlsx or any other format, which you want to convert (more 200 supported formats)
  3. Download your xlsx file. Wait till your file will be converted and click download xlsx -file.

How do I convert Excel to CSV file?

How to open a CSV file in Excel?
  1. Open a new Excel document and navigate to the Data tab.
  2. Click “From Text”.
  3. Navigate to the CSV file you wish to open and click “Import”.
  4. From the newly-opened window, choose “Delimited”. Then click “Next”.
  5. Check the box next to the type of delimiter – in most cases this is either a semicolon or a comma.
  6. Click “Finish”.

How do I convert Excel csv to semicolon?

If we want to convert excel to csv with semicolon delimited, the easy way is the changing list separator in control panel.
  1. Control Panel.
  2. Region, Region and Language Option.
  3. In Tab Format, click customize this format.
  4. List separator, change from comma (,) to semicolon (;)
  5. Ok, -Finish-

How do I save an Excel file as a CSV file as comma delimited?

To save an Excel file as a comma-delimited file:
  1. From the menu bar, File → Save As.
  2. Next to “Format:”, click the drop-down menu and select “Comma Separated Values (CSV)”
  3. Click “Save”
  4. Excel will say something like, “This workbook contains features that will not work…”. Ignore that and click “Continue”.
  5. Quit Excel.

How do I make Excel data comma delimited?


Text to Columns
  1. Highlight the column that contains your list.
  2. Go to Data > Text to Columns.
  3. Choose Delimited. Click Next.
  4. Choose Comma. Click Next.
  5. Choose General or Text, whichever you prefer.
  6. Leave Destination as is, or choose another column. Click Finish.

Do CSV files retain formatting?

CSV (Comma delimited)
This file format (. csv) saves only the text and values as they are displayed in cells of the active worksheet. If cells display formulas instead of formula values, the formulas are converted as text. All formatting, graphics, objects, and other worksheet contents are lost.

How do I save a 0 in a csv file?

You can keep the leading zeros in CSV files by using Excel's Text Import Wizard.
  1. Launch Excel Spreadsheet.
  2. Click the "From Text" icon.
  3. Select the CSV file with the mouse.
  4. Click the "Delimited" radio button in the Text Import Wizard.
  5. Check the box next to "Comma." Click "Next."

Why is Excel not saving my formatting?

If you are saving it in the older Excel 97-2003 format, then it is possible that the losses you are seeing are due to the formatting not being supported in the older format. This is particularly true with colors and conditional formatting. The other possible cause is that the workbook file is corrupted in some manner.

What is the difference between CSV comma delimited and CSV MS DOS?

Essentially, CSV comma delimited is used by Windows and CSV MS-DOS is used by older DOS-based operating systems and you would rarely encounter issues except in the circumstances outlined above. ExcelTips is your source for cost-effective Microsoft Excel training.

How do I convert a PDF to a CSV file?


Use Adobe Acrobat
If you prefer a CSV, Excel or most other spreadsheet programs can open the file and save it as a CSV. To convert a file, open it in Acrobat and click "Export PDF." Choose spreadsheet and "Microsoft Excel Workbook" as the output format. Click "Export" and choose where to save the file.

How do I create a comma delimited text file?

Click the "File" tab at the top of the screen and choose "Save As." When the Save As window loads, type the name of your file into the "File Name" field. Click the drop-down arrow next to "Save as type." Select "CSV (Comma delimited) (*. csv)" from the list of potential file types.

Is Excel compatible with numbers?

Numbers is compatible with Microsoft Excel.

Is Excel for Mac compatible with Windows?

If you work with any version of Excel 2000 through Excel 2003 for Windows and Excel for Mac 2011, you can download the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats from the Microsoft Download Center area on the Microsoft Web site (http://www.microsoft.com/download).

Is numbers as good as Excel?

Numbers only have around 200 functions. If you need pretty graphics, Numbers can do it better than Excel. However, if you need advanced plotting and charting features, Excel is the better choice. In terms of operating systems, Excel can run on both Windows and Mac while Numbers is only exclusive for Mac.

What is the Mac version of Excel?


The equivalent of Excel on a Mac is Excel! You can simply subscribe to Microsoft's Office Suite to get full access to Excel on your Mac. They also offer a 30 day free trial if you'd like to try before you buy, and student discounts.

How do I save an Excel spreadsheet to my desktop on a Mac?

If you're using a Mac, press the "Command" key and then the “S” key. Type the name of your file into the box beside the words “Save As” at the top of the Save File window. Navigate to the Desktop folder in the Save File window.