Open CSV in Excel

From IMSMA Wiki
Revision as of 13:31, 5 April 2015 by Alnaucler (talk | contribs)
Jump to navigation Jump to search
When you open the CSV file in Excel, Excel will automatically interpret data like 1-10 as 10-Jan.

Therefore check carefully the result in Excel before sharing the export result with others. This page describes a word around for this Excel behaviour.

  1. Export Search Result.
  2. Open a new Excel file.
  3. Open the CSV file with a text editor e.g. Notepad++.
  4. Copy all text

  5. Copy all rows with Ctrl+A.
  6. Switch back to Excel and click in cell A1.
  7. Open the Text import wizard by one of following methods:

    Paste method

    Paste method
    1. Click on lower part of the Paste button.
    2. Select Use Text Import Wizard in the drop-down menu.
    Text to Columns method
    1. Paste into Excel with Ctrl+V.
    2. Select column A.
    3. Text to Columns method

    4. Use function Text to columns on Data ribbon.

    Same steps

  8. The wizard starts
    File:.png

    Country

  9. Click Next
  10. Change Delimiters to Comma
    File:.png

    Country

  11. Click Next
  12. Change Column data format to Text and verify that the format is set
    File:.png

    Country

  13. Click Finish
  14. Save as xlsx
  15. Close and open the file in order to verify that the data still has the correct format

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:{{#if:Known issues|
Known issues
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|{{#if:Technical Notes Portal|}}{{#if:|
{{{imageleft}}}
}}{{#if:Technical Notes|Technical Notes<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}{{#if:{{#if:Known issues|
Known issues
}}|{{#if:Known issues|
Known issues
}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}

{{#if:|

{{{image}}}

}}}}{{#if:|{{#if:Technical Notes Portal{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:{{#if:Known issues|

Known issues

}}|{{#if:Known issues|

Known issues

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Duplicate Enumvalue · Negative Coordinates

}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}{{#if:|{{{group2}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list2}}}
}}{{#if:|{{#if:Technical Notes Portal{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=

}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:{{#if:Known issues|

Known issues

}}|{{#if:Known issues|

Known issues

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Duplicate Enumvalue · Negative Coordinates

}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}{{#if:|{{{group3}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list3}}}
}}{{#if:|{{#if:|{{{group4}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list4}}}
}}{{#if:|{{#if:|{{{group5}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list5}}}
}}{{#if:|{{#if:|{{{group6}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list6}}}
}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list7}}}
}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list8}}}
}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list9}}}
}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list10}}}
}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list11}}}
}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list12}}}
}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list13}}}
}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list14}}}
}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list15}}}
}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list16}}}
}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list17}}}
}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list18}}}
}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list19}}}
}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list20}}}
}}{{#if:|{{#if:Technical Notes Portal{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=

}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:{{#if:Known issues|

Known issues

}}|{{#if:Known issues|

Known issues

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Duplicate Enumvalue · Negative Coordinates

}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}
{{{below}}}
}}{{#switch:|subgroup|child=
|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:open csv in excel
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}