Answers.Body: <p>It seems the problem is that you're using CiviReport rather than Advanced Search to perform your export.  If you use search and the Export search action, you'll get abbreviated state names.</p>
  
  <p>Since you're exporting contributions, don't forget to set <em>Display Results As</em> to <strong>Contributions</strong>.  See screenshot:
  <a href="https://i.sstatic.net/FWazW.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/FWazW.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-11T21:20:55.803Z
Answers.Text: That helped. Now I can export with the state abbreviation by doing what you suggested.  However it does not include the contribution amount anymore and that doesn't seem to be an available field in the Select Field options.
Answers.UserDisplayName: fdarn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-11T21:48:04.603Z
Answers.Text: Great, almost there! This last issue is because Advanced Search displays contacts, not contributions, by default.  I updated my answer to show how to display results as contributions - then you can export amounts too!
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-11T21:56:10.903Z
Answers.Text: Thank you.  Now I am getting all the information I need in the format I need it in with those updated instructions.
Answers.UserDisplayName: fdarn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-11T17:07:36.393Z
Answers.LastActivityDate: 2017-12-11T21:48:08.027Z
Answers.LastEditDate: 2017-12-11T21:48:08.027Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>We are using Civi 4.7.27 on Wordpress 4.9
  When doing exports the state is shown as the full name. We really need to be able to export with the 2 letter state abbreviation.  How can we set it to do this?</p>
  
  <p>Thank you. </p>
  
  <p>*****Added Screenshot***</p>
  
  <p><a href="https://i.sstatic.net/C8H7R.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/C8H7R.jpg" alt="enter image description here"></a></p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-12-11T04:58:09.517Z
Comments.Text: The default is to export the state abbreviation.  In fact, I'm not sure how I'd go about doing the opposite.  Can you try replicating your steps on the demo server to see if it's something specific to your site?  I just tried it and got the abbreviations.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-12-11T07:29:27.037Z
Comments.Text: That is interesting.  In Civi  Dashboard I am going to  Reports > Contribution Reports > Contribution Details > I check City, state, zip code > Select "Export to CSV" and the Export shows the State names typed out in full not the 2 letter abbreviation as you can see from the screen shot I added.   What am I doing wrong?  Is there another export method I should use?
Comments.UserDisplayName: fdarn
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-12-11T09:36:49.100Z
Comments.Text: I'm not sure about this but the result you are getting is maybe because of your setting in administer> localization> address settings> address display.
  In the 5th line in display format, it may show contact.state_province_name} instead of {contact.state_province}.  The latter displays only a state abbreviation.
  The help caption below says "Format for displaying addresses in the Contact Summary and Event Information screens.
  Use {contact.state_province} for state/province abbreviation or {contact.state_province_name} for state province name."
  Might be worth a try changing the setting!
Comments.UserDisplayName: peterb
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-12-11T15:17:56.520Z
Comments.Text: I just it does say contact.state_providence like it is supposed to.
Comments.UserDisplayName: fdarn
Tags: <export>
Title: How to export with state abbreviations
ThreadText: # How to export with state abbreviations
  
  (Asked by: username_0 on 2017-12-11)
  
  We are using Civi 4.7.27 on Wordpress 4.9
  When doing exports the state is shown as the full name. We really need to be able to export with the 2 letter state abbreviation. How can we set it to do this?
  
  Thank you.
  
  \*\*\*\*\*Added Screenshot\*\*\*
  
  [![enter image description here](https://i.sstatic.net/C8H7R.jpg)](https://i.sstatic.net/C8H7R.jpg)
  
  **Tags:** export
  
  > **Comments:**
  > **username_1**: The default is to export the state abbreviation.  In fact, I'm not sure how I'd go about doing the opposite.  Can you try replicating your steps on the demo server to see if it's something specific to your site?  I just tried it and got the abbreviations.  
  > **username_0**: That is interesting.  In Civi  Dashboard I am going to  Reports > Contribution Reports > Contribution Details > I check City, state, zip code > Select "Export to CSV" and the Export shows the State names typed out in full not the 2 letter abbreviation as you can see from the screen shot I added.   What am I doing wrong?  Is there another export method I should use?  
  > **username_2**: I'm not sure about this but the result you are getting is maybe because of your setting in administer> localization> address settings> address display. In the 5th line in display format, it may show contact.state_province_name} instead of {contact.state_province}.  The latter displays only a state abbreviation. The help caption below says "Format for displaying addresses in the Contact Summary and Event Information screens. Use {contact.state_province} for state/province abbreviation or {contact.state_province_name} for state province name." Might be worth a try changing the setting!  
  > **username_0**: I just it does say contact.state_providence like it is supposed to.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-12-11. Score: 2 | Accepted answer
  
  It seems the problem is that you're using CiviReport rather than Advanced Search to perform your export. If you use search and the Export search action, you'll get abbreviated state names.
  
  Since you're exporting contributions, don't forget to set *Display Results As* to **Contributions**. See screenshot:
  [![enter image description here](https://i.sstatic.net/FWazW.png)](https://i.sstatic.net/FWazW.png)
  
  > **Comments:**
  > **username_0**: That helped. Now I can export with the state abbreviation by doing what you suggested.  However it does not include the contribution amount anymore and that doesn't seem to be an available field in the Select Field options.  
  > **username_1**: Great, almost there! This last issue is because Advanced Search displays contacts, not contributions, by default.  I updated my answer to show how to display results as contributions - then you can export amounts too!  
  > **username_0**: Thank you.  Now I am getting all the information I need in the format I need it in with those updated instructions.  
  
  ---
  
  