I thought that I could only use sprintf when displaying/exporting the data

No, that must be printf you're thinking of. printf actually prints the resulting data (except that it ignores $\), while sprintf just returns the value, ready to store into a variable, for example.