"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…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. Because it isn’t always a comma. And setting the delimiter won’t escape or strip the same characters in the values, so it’ll mess up your data quite easily. Recently, I needed to find a way to import data from an old Excel file to a custom-coded system that could import CSV…Continue reading How to change Excel CSV delimiter?