Tag: MicrosoftExcel

"I know Excel"

How to copy-paste a table from Excel to WordPress without using plug-ins?

So, I tried to paste a table from Excel into WordPress, and I failed. Annoying – but not a big problem. I can just paste it into an existing table and it’ll “sort itself out”, right? Well, no. Exporting the Excel sheet as a html page and copy-pasting the table from there didn’t work either. Actually, copy-pasting a table just didn’t work at all. So… WordPress is unable to understand HTML tables. Is that really it? Well, no, again, it’s not. It just refuses to…Continue reading How to copy-paste a table from Excel to WordPress without using plug-ins?

"I know Excel"

How to change Excel CSV delimiter?

This article will explain how you can change the Excel list delimiter for your CSV (or other) file exports. Recently, I needed to find a way to import data from an old Excel file to a custom-coded system that could import CSV files. However, the data was fairly non-sanitized – containing commas, semicolons, and other weird characters. I could define the delimiter used in the imported data – however, that would be useless if I wasn’t also able to define it in the export. With…Continue reading How to change Excel CSV delimiter?