Open CSV in Excel

From IMSMA Wiki
Revision as of 13:06, 5 April 2015 by Alnaucler (talk | contribs) (Created page with "{{Warning | 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.

Export Open a new Excel file Open the .CSV file with a text editor e.g. Notepad++ Copy Select cell A1

Method 1 Click on Paste button Select Use Text Import Wizard"

Method 2 Paste into Excel Select column A Use function Text to columns on Data ribbon.

Same steps

The wizard starts Click Next Change Delimiters to Comma Click Next Change Column data format to Text and verify that the format is set Click Finish Save as xlsx 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 = 
 }}
}}

}}}}}}