Skip to content

<< Back to List

How Can I Separate Address Street, City, State and Zip Into Different Columns?

  1. Select the report in iGo Figure that you wish to use, and click on the Export button.
  2. Name the report and choose XLS format. (xls should be selected by default) and then Save to a location that will be easy to locate.
  3. Click here to access the iGo Figure Excel Address Parser. (The file upload page will appear in a new tab in your web browser)
  4. Click the Browse button and find the file saved in step 2 above.
  5. Click Upload File.
  6. Once the file is done uploading, click on “Click here to download your new spreadsheet”.
  7. You should then be able to open and view the new Excel spreadsheet and will notice the address has been parsed into the last 4 columns listed as Street, City, State and Zip.
  • Print this FAQ
  • Forward this FAQ to a friend
  • Got a question?