- How do I create a .csv file on my mac? - Apple Community.
- Video of the Day!
- Import a csv file into Microsoft Excel, Google Sheets or Apple Numbers.
- Save as CSV excel mac - Microsoft Community.
- How to Export Microsoft Excel (2008) to CSV in Mac OS?
Click the selector bar next to File Format. Select Comma Separated Values. Click Save. This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.
How to save in comma-separated values instead of semicolon csv in excel WITH MAC?
Microsoft Excel. Learn more. The wikiHow Tech Team also followed the article's instructions and validated that they work. Learn more Article Summary X 1. Did this summary help you? Yes No. Open an Excel spreadsheet file.
Import data from a CSV, HTML, or text file
Find the Excel file you want to edit on your computer, and open it. Click the File tab.
This button is in the upper-left corner of your screen. It will open a menu of all your file options. Click Save As on the File menu.
csv - How can you change Mac excel to separate using commas, not semicolons? - Super User
This option will allow you to save this spreadsheet in a different file format. Clicking will open a new pop-up window.
Alternatively, you can use a keyboard shortcut here. It's located at the bottom of the Save As window. Clicking will open a list of all the available file formats on a drop-down menu.
Ask Question. The System preferences for my keyboard input is Italian What is the matter? Cris Cole Cris Cole 1 1 7. Excel for Mac currently has no setting to change the separator from the app itself. Here are the rules Excel uses to determine how it saves CSV files: If your region uses commas , for decimal, then Excel will save using semi-colons ; If it uses a decimal point. You need to change your general region for it to work. For example, if your region is Germany which uses , for decimal separation , Excel will always use ; for CSVs, even when changing the decimal point under Advanced.
You need to relaunch Excel for it to notice. Quit the app, change the region, then start it again. Tetsujin Tetsujin Thank you but it doesn't work.
I've tried both of your solutions I tried again, it doesn't work I add to change the whole "region" from "France" to "United States". I tried to clarify your post — I noticed that the actual decimal point settings don't matter to Excel. It's the region that needs to change.