Skip to main content
11 events
when toggle format what by license comment
S May 27, 2022 at 13:27 history suggested Glorfindel CC BY-SA 4.0
corrected to intended formatting: </table>
May 26, 2022 at 14:20 review Suggested edits
S May 27, 2022 at 13:27
Jul 29, 2014 at 14:54 comment added Rob Hodges The only problem with this technique is that Excel 2007+ gives you a warning prompt that this file is not in the format that it's saved as. I can't see any way around it without using something like PHPExcel or just exporting as a CSV. What are other people doing re: this message?
Apr 11, 2013 at 13:35 comment added Jason Varga I was having a similar problem and someone suggested using an HTML table and sent me here. I played around with it and found a way for Excel to render it normally. See this answer
Nov 27, 2012 at 21:56 comment added foamcow Hmm, you may need to use the same technique to output a CSV file and use a delimiter around your cell content. You can then import this into Excel telling it what the delimiting string is. It should then display the tags as text within your cell.
Nov 27, 2012 at 21:48 comment added Richard Frank Yes I mean keep the html tags so HTML content is actually preserved. This means the content can be re-imported into another CMS for instance. But more importantly, the body content should all sit in one cell rather than having multiple merged cells which is happening in Excel 2011 for Mac.
Nov 27, 2012 at 21:08 comment added foamcow Yes, bold tags will work too. I'm not guaranteeing that some html or other code within your data won't break it but generally it should be OK. I haven't done this for some time and I seem to recall sometimes having to fiddle with delimiting the cell contents with quotes. I don't think Excel will ever maintain the markup since it's not an HTML rendering tool... or do you mean display the html tags?
Nov 27, 2012 at 20:49 comment added Richard Frank Ok thanks, I'm tentatively marking this as the answer, however <p> tags are being converted into multiple rows. I'd prefer it if Excel would just maintain the markup as is.
Nov 27, 2012 at 20:39 vote accept Richard Frank
Nov 27, 2012 at 20:19 comment added Isaac Raway This is much better than CSV since it will always be opened in Excel and it is not sensitive to line breaks in the content. I believe some other HTML tags also work such as bold, etc.
Nov 27, 2012 at 20:10 history answered foamcow CC BY-SA 3.0