Problem: saving data in CSV format includes HTML

I have an action with an attachment template that exports my data to a CSV file. The CSV file does get generated, but it includes a whole bunch of HTML format tags in the header, which of course totally breaks the subsequent import into Excel.

If I open the CSV file in a text editor and get rid of the HTML the import works fine.

I have turned off formatting in the template, and selected Normal Text, but the stupid HTML garbage is still there.

Here is the template:

Daily Run Report for <<USERSETTINGS(“Filter data by this date:”)>>,Generated on demand on <<NOW()>>
Date,Day,Run,Type,Crew,Cars,Passengers,Walkons,
<<Start:FILTER(New run, TRUE)>>
<<[Date]>>,<<[Day]>>,<<[Run]>>,<<[Type]>>,<<[Crew Name]>>,<<SUM(SELECT(HMC Log Data[car count],[Run]=[This run]))>>,<<SUM(SELECT(HMC Log Data[passenger count],[Run]=[This run]))>>,<<SUM(SELECT(HMC Log Data[walkon count],[Run]=[This run]))>>,
<>

And here is the output with all the unnecessary HTML garbage:

ol{margin:0;padding:0}table td,table th{padding:0}.c4{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Courier New";font-style:normal}.c1{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Arial";font-style:normal}.c0{padding-top:0pt;padding-bottom:0pt;line-height:1.0;text-align:left}.c2{background-color:#ffffff;max-width:468pt;padding:72pt 72pt 72pt 72pt}.c3{height:11pt}.title{padding-top:24pt;color:#000000;font-weight:700;font-size:36pt;padding-bottom:6pt;font-family:"Arial";line-height:1.0;page-break-after:avoid;text-align:left}.subtitle{padding-top:18pt;color:#666666;font-size:24pt;padding-bottom:4pt;font-family:"Georgia";line-height:1.0;page-break-after:avoid;font-style:italic;text-align:left}li{color:#000000;font-size:11pt;font-family:"Arial"}p{margin:0;color:#000000;font-size:11pt;font-family:"Arial"}h1{padding-top:32pt;color:#000000;font-weight:700;font-size:20pt;padding-bottom:18pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h2{padding-top:29.2pt;color:#000000;font-weight:700;font-size:16pt;padding-bottom:17.2pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h3{padding-top:28pt;color:#434343;font-weight:700;font-size:14pt;padding-bottom:16pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h4{padding-top:26.8pt;color:#666666;font-weight:700;font-size:12pt;padding-bottom:16.8pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h5{padding-top:24.8pt;color:#666666;font-weight:700;font-size:11pt;padding-bottom:16.8pt;font-family:"Arial";line-height:1.149999976158142;text-align:left}h6{padding-top:30pt;color:#666666;font-weight:700;font-size:11pt;padding-bottom:22pt;font-family:"Arial";line-height:1.149999976158142;font-style:italic;text-align:left}

Daily Run Report for 6/18/2018,Generated on demand on 4/2/2020 8:34:23 PM

Date,Day,Run,Type,Crew,Cars,Passengers,Walkons,

6/18/2018,Mon,0700 (7am),Scheduled,Dan Morgan,3,2,1,

6/18/2018,Mon,0800 (8am),Scheduled,Dan Morgan,5,2,2,

6/18/2018,Mon,0900 (9am),Scheduled,Dan Morgan,9,3,0,

6/18/2018,Mon,1000 (10am),Scheduled,Dan Morgan,5,2,1,

6/18/2018,Mon,1230 (12:30pm),Scheduled,Dan Morgan,10,2,2,

6/18/2018,Mon,1230 (12:30pm),Shuttle from island,Dan Morgan,3,4,0,

6/18/2018,Mon,Other,Scheduled,Dan Morgan,1,0,0,

6/18/2018,Mon,1800 (6pm),Scheduled,Dan Morgan,11,3,3,

6/18/2018,Mon,1800 (6pm),Shuttle from mainland,Dan Morgan,7,1,0,

6/18/2018,Mon,1900 (7pm),Scheduled,Dan Morgan,5,4,0,

What am I missing?

Did you follow the process described here to create your template?

Thanks Steve. I didn’t - I just edited it in the editor provided inside Google Docs when I clicked on View. I’ll download the template and edit it locally, then upload as per the instructions, I bet that will fix it.

Thanks!

1 Like

Worked - thanks Steve!

1 Like