I am using Excel for Mac 2016 on macOS Sierra software. Although I have been successfully copying and pasting CSV files into excel for some time now, recently, they have begun to behave in an odd way. When I paste the data, the content of each row seems to split over many columns. Where as before one cell would have been able to contain many words, it seems now as though each cell is only able to contain one word, so it splits the content of what would normally be in one cell, over many cells, making some rows of data spread out over up to 100 columns!
1: Set the Default Application for a Specific File in Mac OS X This provides file-specific control over default applications, meaning you can have a document or two that open in one app, while the overall general file type defaults to open in another application. Importing CSV files into excel- how to change default 'delimiters'? I am using Excel for Mac 2016 on macOS Sierra software. Although I have been successfully copying and pasting CSV files into excel for some time now, recently, they have begun to behave in an odd way. Now that you’ve changed the default program for this file, the button for Change All is active. This button will set your Mac to use the selected application to open files of this type.
I have tried Data tab>> From text>> which takes me through a Text Wizard. There I choose Delimited>> Choose Delimiters: Untick the 'Space' box ('Tab' box is still ticked)>> Column data as 'General'>> Finish. Following this process appears to import the data into its correct columns. Cmpression program for mac. It works. BUT, a lot of work to get there!
Question: Is there any way to change the default settings of Delimiters, so that the 'Space' delimiter does not automatically divide the data?
Mac Os Default Program![]()
Active5 years, 11 months ago
I want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to 'Tab' by default. How can I change the default to 'Comma' instead?
Lars
Default Profraw MacLarsLars
42022 gold badges66 silver badges1010 bronze badges
3 Answers
This is a Windows setting that will be used by all programs that refer to it (Excel in this case).
fergulatorfergulator
(Assuming the Office 2003 interface)
Don't use File > Open.
https://powerupcatalog391.weebly.com/blog/best-personal-accounting-program-for-mac. https://powerupcatalog391.weebly.com/blog/best-program-for-slideshow-on-mac. Instead use Data > Import External Data > Import Data..
This will invoke the Text Import Wizard, which lets you choose the delimiter.
Or, if you're using the newer interface, go to the Data tab > From Text:
This will pull up a File Open dialog, followed by the same Text Import dialog. Best mac program for managing iphone.
njd
Change Default Program For All Usersnjd
9,41322 gold badges3030 silver badges3434 bronze badges
Excel appears to use the last used delimiter in the session. Dave Peterson describes a possible solution here You essentially create a macro that sets the default delimiter and place it in the xlstart folder. If you are doing this for a file on other peoples machines, that is not probably going to work, but this is how you would approach it, programatically on your own system, and you may adapt it to your situation. Running the following code should set the delimiter for you beforehand. This will operate on an existing session. So if you have content that expects specific delimiters setup, run something like this prior to your import, setting whatever parameters you like
datatoodatatoo
protected by Community♦Oct 12 '13 at 19:47
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead? Not the answer you're looking for? Browse other questions tagged microsoft-excelimportcsv or ask your own question.Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |