ms workplace – Numbers.app or Excel: Find out how to embody cell bg colour data as a part of a CSV export?


I’ve a posh Numbers.app spreadsheet which accommodates a desk with cells which are coloured with totally different background colours. The totally different colours characterize important data.

Once I export the desk to a CSV file in numbers (File > Export to… > CSV…) the colour data will not be included within the exported CSV in any manner. That could be a downside for me, since it’s important data.

Is there anyway to incorporate the cell background colour data in a CSV export? In fact I need to retain and export the entire different common data within the CSV export as properly. Any workaround which may export this colour data in any type of structured format could be acceptable/fascinating to know.


Notice: I did discover that this cell background colour data is preserved when exporting to Excel format (File > Export to… > XLS…). If there isn’t a extra direct manner, I’d like to additionally hear about an choice to first export to Excel, after which export from Excel to a CSV format which by some means consists of the structured colour data.


Additionally Notice: Sure, after all I’m conscious that CSV is a text-only file format. However out-of-band data might theoretically be included in an export in some type of format like hex_color_value:text_value for every cell (comma-separated worth). One thing like that might actually be superb…

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *