how to open .dat files in excel comma delimited for mac

Open .Dat Files In Excel Comma Delimited Software Versions Do

Over the last decade, Lowell has personally written more than 1000 articles which have been viewed by over 250 million people.

Prior to starting How-To Geek, Lowell spent 15 years working in IT doing consulting, cybersecurity, database management, and programming work.

Since we launched in 2006, our articles have been read more than 1 billion times.

In amongst the myriad options for saving the data, Excel provides me with these options for saving files into a CSV format: CSV UTF-8 (Comma delimited) (.csv) CSV (Comma delimited) (.csv) CSV (Macintosh) (.csv) CSV (MS-DOS) (.csv) Depending on which of those options I use I am finding either the data becomes altered by the CSV format, or InDesign rejects the format.

I have some cells which have special characters such as the degrees sign, or a plusminus sign (e.g.

There are many such symbols I use, and whilst sometimes I add these via the Character Map function in System Accessories, but most usually via the keyboard (for instance, a key combination such as Alt0188 creates a symbol on a PC).

Please fix the file, select a file that contains records, or select a supported file type.

If I use the CSV or CSV (MS-DOS) format the special characters get changed (e.g.

I havent tried the Macintosh version yet, however Im not that keen to try it just in case Im introducing weird issues with a Mac type file on a PC environment.

Open .Dat Files In Excel Comma Delimited Software Versions Do

I have always had problems exporting with Excel and the software versions do not respond in the same way.

Maybe there are other solutions but for me it works perfectly.

I searched Excel forums and found that if you save the spreadsheet of data as an.xls file, not an.xlsx file, and then export to a.csv (Comma Delimited) file then there was no alteration of the special characters and of course InDesign happily accepted the file.

It works for me here; Im not used to outputting tab delimited files as I have a WordPress site that I have to export out spreadsheet data in CSV format, so I lean that way, but I have the same issue on that side of things.

Now at least I have found a way to export out to a CSV file that doesnt corrupt the information Win - Win Thanks to all who responded.

How To Open .Dat Files In Excel Comma Delimited For Mac