Exporting Location Data

You can export your location data for backup purposes, to make corrections, etc.

Export Instructions:

1. Select Export File Type;

• Excel (XML, multilingual)– Excel xml format is recommended for users with special international language characters in their location data.  XML Support is available in Microsoft Excel 2002 and later.
• Excel (XLS, only latin) –  Standard Excel xls format is recommend for most users.
• CSV– Comma separated values file.

2. Click the Next button and then select one of the export methods;

• Locations File Only Using this method, you will download only the export file in the format chosen (CSV or Excel).
• Locations File & Media Using this method creates a .zip file that will include the export file of the type chosen along with any media files you have installed (image and audio files).

3. Click the Export button, select a location on your computer to save the file and click the Save button.

Working with the Export file:

Excel Format (.xls);

When working with the Excel (.xls) export file to add new location data, be aware that the fields are initially formatted as General fields. Since General fields will drop leading zeros, certain fields such as Number and Zip fields using number should be reformatted to a Text type format prior to entering new location data. To do this, highlight the entire column by clicking on the column letter, then click Format | Cells and select the Text format.

CSV Format (.csv);

Many spreadsheet programs (MS Excel for example) will drop leading zeros in a number field. If you notice this, do not worry.  Our import process will add back the leading zeros where required to ensure that all zip codes have the proper number of digits.

General;

Note for Netscape and Mozilla users: For users of certain versions of Netscape and Mozilla you may find that, upon clicking the Export button, your Browser will add a .exe to the download file. If this occurs, please remove the .exe file extension from the file and insure that the file extension is .csv prior to saving it to your local computer.

Special Note for MAC users: When saving your export file, make sure to use the windows format (not the MAC format). You can choose the correct file type options by using the Save As Type drop-down list at the bottom of the Save As dialog box.

Note on Opening File on your local computer: Usually you can double click the export file to open it in your spreadsheet application, however in some cases, the file will not open in a delimited format. If this occurs, below are instructions for opening the file using MS Excel.

1. Open MS Excel to a blank spreadsheet.
   2. Click on the toolbar at the top.
   3. Drill down to “Get External Data | Import Text File”
   4. In the “Import Text File” window, navigate to the folder where you saved the export file.
   5. If your export file is not visible, select “All Files” in the “File of Type” drop down list.
   6. Click to highlight your export file and then click the “Import” button.
   7. Click the “Delimited” radio button and click “Next”.
   8. Check the “Comma” checkbox and uncheck all other boxes.
   9. Click “Finish” and your export file should now open in the delimited format.