Open CSV in Excel: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{Warning | When you open the CSV file in Excel, Excel will automatically interpret data like '''1-10''' as '''10-Jan'''.
{{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 sharing the export result with others.}}
Therefore check carefully the result in Excel before sharing the export result with others. This page describes a word around for this Excel behaviour.}}


{|
|- valign="top"
|
{| class="wikitable"
|-
| [[Image:Csv Excel correct data type.png|250px|center]]
| [[Image:Csv Excel changed to date.png|250px|center]]
| [[Image:Csv Excel changed to date2.png|250px|center]]
|- align="center"
| ''How it should be''
| ''Excel transforms to Date''
| ''Result if you change the column to Text''
|}
Below we describe a workaround for this '''Excel''' behaviour.
<ol>
<ol>
<li>[[Export Search Result]].</li>
<li>[[Export Search Result]].</li>
Line 51: Line 65:
<li>Change ''Column data format'' to '''Text''' and verify that the format is set to '''Text''' for the columns that Excel otherwise will change to the wrong data type or data format.</li>
<li>Change ''Column data format'' to '''Text''' and verify that the format is set to '''Text''' for the columns that Excel otherwise will change to the wrong data type or data format.</li>
<li>Click '''Finish'''.</li>
<li>Click '''Finish'''.</li>
<li>Save as xlsx.</li>
[[Image:Csv Excel correct data type.png|250px|center]]
<li>Close and open the file in order to verify that the data still has the correct format.</li>
<li>Save the file in xlsx.</li>
<li>Close the Excel file and open the file again before you share it in order to verify that the data still has the correct format.</li>
</ol>
</ol>
{{NavBox Technical Notes}}
{{NavBox Technical Notes}}
[[Category:NAA]]
[[Category:NAA]]

Latest revision as of 12:02, 7 April 2015

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.
}}{{#if:{{#if:Workarounds|
Workarounds
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|
Misc
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|
Languages
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Colombia|{{#if:{{#if:Countries|
Countries
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#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=
How it should be Excel transforms to Date Result if you change the column to Text

Below we describe a workaround 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.
  8. The wizard starts.
  9. The first panel

  10. Click Next.
  11. The second panel

  12. Change Delimiters to Comma.
  13. Click Next.
  14. The third panel

  15. Change Column data format to Text and verify that the format is set to Text for the columns that Excel otherwise will change to the wrong data type or data format.
  16. Click Finish.
  17. Save the file in xlsx.
  18. Close the Excel file and open the file again before you share it 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:Workarounds|
Workarounds
}}
{{#if:Misc|
Misc
}}
{{#if:Languages|
Languages
}}
{{#if:Countries|
Countries
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}

}}{{#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 =
 }}
}}

}}}}}}