I am creating a csv file via the SearchCursor. This Works great....although I am not getting the field names in there. I went about this 2 ways. I have tried a ton of forums but just cant seem to get the right syntax to create this ONLY once and when I bring it into Excel it has a header for each field. Any thoughts? I add the headers IN the "for row in cursor" This adds them BUT it creates a set of headers for each record imported with arcpy . da . SearchCursor ( fc , [ var_region_1 , var_county_1 , var_ramp_1 ] , where_clause = expression ) as cursor : for row in cursor : zval = str ( '{0},{1},{2}' . format ( row [ 0 ] , row [ 1 ] , row [ 2 ] ) ) headers = [ 'region_1' , 'county_1' , 'ramp_1' ] outFile . write ( '\t' . join ( headers ) + '\n' ) outFile . write ( zval + "%s\n" ) Add headers BEFORE the "for row in cursor" This adds them but when I bring into excel they are all crammed into the first box, not spread out for each field. headers = [ 'region_1' , 'county_1' , 'ramp_1' ] outFile . write ( '\t' . join ( headers ) + '\n' ) with arcpy . da . SearchCursor ( fc , [ var_region_1 , var_county_1 , var_ramp_1 ] , where_clause = expression ) as cursor : for row in cursor : zval = str ( '{0},{1},{2}' . format ( row [ 0 ] , row [ 1 ] , row [ 2 ] ) ) outFile . write ( zval + "%s\n" )

I stripped down a bunch of characters from the Header...it appears to be working now...definitely think I was hitting some sort of Character limit...I thank you very much for you help...spent way to long on this already...seems to be working...just watch how many characters I have from now on....

Excel 2010... Yea something weird is going on...If I copy the created .csv file from my server to my PC, then go File>open (not drag and drop it woks fine). Drag and drop it carries to the next line. But that only works once....then it gets all screwed up again...Very puzzled...going to try and decrease the characters being used in the header to see if that helps.

When I open the CSV, everything looks fine. When I open the CSV directly in Excel, it displays fine. When I open your XLS, I see your issue. What version of Excel are you using? I am looking at the CSV using Excel 2013?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add header to csv file

jaykapalczynski

I am creating a csv file via the SearchCursor. This Works great....although I am not getting the field names in there. I went about this 2 ways. I have tried a ton of forums but just cant seem to get the right syntax to create this ONLY once and when I bring it into Excel it has a header for each field.

Any thoughts?

I add the headers IN the "for row in cursor"

This adds them BUT it creates a set of headers for each record imported

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>var_region_1 <SPAN class="punctuation token">,</SPAN>var_county_1<SPAN class="punctuation token">,</SPAN>var_ramp_1<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="operator token">=</SPAN>expression<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; zval <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; headers <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'region_1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'county_1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ramp_1'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\t'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>headers<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>zval <SPAN class="operator token">+</SPAN> <SPAN class="string token">"%s\n"</SPAN><SPAN class="punctuation token">)</SPAN>

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Add headers BEFORE the "for row in cursor"

This adds them but when I bring into excel they are all crammed into the first box, not spread out for each field.

headers <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'region_1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'county_1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ramp_1'</SPAN><SPAN class="punctuation token">]</SPAN>
outFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\t'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>headers<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>var_region_1 <SPAN class="punctuation token">,</SPAN>var_county_1<SPAN class="punctuation token">,</SPAN>var_ramp_1<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="operator token">=</SPAN>expression<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; zval <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>zval <SPAN class="operator token">+</SPAN> <SPAN class="string token">"%s\n"</SPAN><SPAN class="punctuation token">)</SPAN>

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

bixb0012

What does this produce, using either 3 or 78? (Note, commas outside of strings)

headers = ['region_1', 'county_1', 'ramp_1']
outFile.write(','.join(headers) + '\n')<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jaykapalczynski

I changed to that...but when using the below it writes header values to the 1st and 2nd line.

NOTE: I have 78 fields. The header line below is just showing 3. Might be hitting a limit in Excel from a CSV file?

headers = ["region_1,county_1,ramp_1,date,"]

bixb0012

Although that works, it isn't very Pythonic. Your original code can be modified slightly to make it work with existing header format:

outFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>headers<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

jaykapalczynski

I have one last issue. I have many many fields...when I write the header in it writes to the second line when I bring the csv into excel.

BUT the data that I am writing to the same csv file does not. The individual records are all on the same line.

Why is this? Can I specify to not return to the 2nd line ?

jaykapalczynski

I got it...answered my own question! Just added , inside the quotes.

headers <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'region_1,'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'county_1,'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ramp_1,'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

bixb0012

You are creating a CSV, which is comma delimited, but you are inserting tabs between your headers, so they are all getting treated as a header for a single field/column.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.