What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there a way to add html to the generated CSV file of my submissions?Asked by sdsign on November 19, 2014 at 04:37 PM
I wanted to know if it's possible to have HTML automatically added to some fields when I export to CSV.
For example, to automatically add <p></p> around someone's name or comments.
Is this possible?
Unfortunately, that's not possible and also wouldn't work correctly since a CSV file doesn't render HTML when it's viewed in Excel for example. A CSV file basically works with text values separated by commas.
If you are looking for a web report for your submissions, may I suggest that you create a visual report instead?
Let us know if you need further assistance.
I wasn't looking for it to render the HTML, just add the text in front and behind the submission.
So user would enter "Joe Smith"
But the CSV cell would contain "<p>Joe Smith</p>"
That way I could just import the CSV without adding markup.
In this case you could modify the file directly in Excel to add these tags in the cell.
I mean, you can change the cell format using a custom format like this: <p>@<\/p>
And then copy this format to all the cells in which you need to add these tags automatically and re-save the file as CSV so you can import it.
Let us know if this helps.
Close to working but Excel says "...cannot use the number format you typed." when I try and save the custom format.
Can you post a screenshot of the error message and also another screenshot showing us how are you configuring the custom format? Please check this guide on how to do this: https://www.jotform.com/answers/277033-How-to-add-screenshots-images-to-questions-in-support-forum
This will make easier for us to see why are you're receiving this message.