HomeWikiMacExcel for Mac ignores column formats

32.1. Excel for Mac ignores column formats


How can I get my ResRequest documents to import with the correct column layout in Excel for Mac?


When files are exported from ResRequest, the standard csv (comma separate value) export format is used. Some versions of Excel for Mac do not recognise csv file formats when they are opened using the File > Open function. When a csv file is opened using this method Excel for Mac shows data columns separated with comma and quotes as separators (instead of separated as columns).

If you are an Excel for Mac user and you experience these symptoms when opening ResRequest export files, please notify our call centre (support@resrequest.com) by sending the following information to them: the report you generated from ResRequest and the Excel version you are running on your Mac. 

In the meantime, you are able to import these files into Excel by following the steps detailed below.

Knowledge Tags


This page was: Helpful | Not Helpful