If you copy & paste from Microsoft applications code is transferred that overrides the style rules of your site. There are icons for pasting from Microsoft applications but even those don’t strip out all the code. You could use search & replace in a good editing program to replace all of the commas with </td><td> and all of the line breaks to </td></tr><tr><td> then you would have to add the first <tr><td> and the last </td></tr> and then you could copy & paste all of that into your site with the editor in HTML mode.
There are also plugins that make it easier to work with tables in WordPress.
Wait, so if I am in Excel, and a CSV file, and I cut and paste that info and just paste it into the Editor, it can override the style rules of my site?
Yes.
Sorry I forgot to mention that you would also have to add the <table> and </table> tags before pasting it in.
Is there a certain thing I have to do in Excel? When I literally just cut and paste, no table shows up and there is nothing formatted.
If you save it as a CSV file and then open it in an plain-text editor that has a good search & replace, you can do what I said above and then paste it in as HTML.
