Forum Discussion
Help with CSV into Excel for Mac
twwareza Perhaps you already figured it out, but just in case you haven't. Your csv-data contains files with line break and fields with "" (i.e. nothing). See pictures below. Excel doesn't handle these properly when you use the text/csv import wizard. Don't ask me why, I'm not an expert in that area.
Open the csv in the TextEdit app on your Mac and do a Find off line feeds (type Alt-Enter in the Find field and type a space in the Replace field. Press Replace All.) Then, also replace all quotation marks with nothing. Save the file (with a different name, to be safe) and now import the new file into Excel. Added a cleaned csv file and the resulting xlsx after import. Can you automate these steps? Probably yes, but I can't help you with that. There are resources on the web that explain how to do this with VBA, though.
Then, you mention that you can't find how to connect to a folder. I'm afraid, that comes with "Get and Transform Data", a.k.a. Power Query which is NOT available for Mac users.
twwareza You're welcome!
Hello Riny_van_Eekelen,
could you give me please some advice regarding export Microsoft List in CSV file on MAC device?
When I do export the fie loses the correct format and looks like on the picture bellow. Is the problem of this "" signes? How can I get a correct format of the file after export?
Thank you in advance for response and help.
Best regards,
Darya
Darya_V_23 Not sure I follow, Sorry! Better to remove your post here and start a new thread as the original post was about importing CSV into Excel. Your question deals with exporting. As a general note, though, when you export an Excel file to CSV (or save as CSV), you loose all formatting and formulas. And if you have more than one tab, only the active tab will be saved as CSV, so you'll loose everything from the other tabs.