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: