One thing which would have been useful years ago was knowing I could copy data directly from Excel into the load script for an Inline Load if I changed the delimiter setting in the load script.

So what this means is you can copy a data set from Excel:

Paste into Qlik and add ‘(Delimiter is \t)’ at the end of the Inline Load statement.

* \t is for tab, my Excel default delimiter. You can change this to whatever you want. See the documentation for more info.

Reload and there you have it: