Register and login to use the Lightboxes and Client Area.

There are 0 registered members and 10 guests currently viewing the site.

A password will be e-mailed to you.

Home
Photo Galleries
Themes
Lightboxes
Photo of the Month
- Contents
- Latest
- Archives
  - 2009
    - May
    - June
    - July
    - August
    - September
    - October
    - November
    - December
  - 2010
    - January
    - February
    - March
    - April
    - May
    - June
    - July
    - August
    - September
    - October
    - November
    - December
  - 2011
    - January
    - February
    - March
    - April
    - May
    - June
    - July
    - August
    - September
    - October
    - November
    - December
  - 2012
    - January
    - February
    - March
    - April
    - May
    - June
    - July
    - August
    - September
    - October
    - November
    - December
  - 2013
    - January
    - February
    - March
    - April
Publicity
Articles
Resources
Travelling Tim
Help
- Register
- Log In
- Log Out
- Forgot Pass
- Privacy Policy
- HD Photo Sales
- RF License
- Purchase Prints
- Site FAQs
- Whats New
- Contact
- Search
- Site Map

Photographer's World Database of Countries, States, and Cities: Using CSVed

The Photographer's World Database of Countries, States, and Cities is primarily designed to be uploaded to a server on the web and used to run a sophisticated database-based website. But maybe you are a photographer who needs a comprehensive list of world countries, states and cities to use when sorting or key-wording your photographs. You don't want to use the data in a database - you just want to look at the data, and then copy and paste it into Adobe PhotoShop, LightRoom, Bridge, or other image keywording programs. No problem - nothing could be easier. The data tables are provided in a set of CSV files, and you can look at them in any program that can display this format. At the simplest, you could use any Text Viewer program, such as NotePad, but I would recommend a dedicated CSV viewer, such as CSVed. Its very versatile, and its free. To use it, just follow the notes below...

Once you have installed the CSVed program, start it running, and click 'File > Open' then browse to the .csv file you wish to view. When the file opens, the screen may show something similar to the image on the right (click to see it enlarged). Don't panic!
Do the following, in the correct order: Click 'Set Separator > Pipe' Check 'Use Start Row as Column Captions' Click the little '+' icon to hide the toolbar Click the Refresh icon to reload the page
You can now scroll up and down or side to side through the entire table, and inspect any value that you choose.
To make it easier to Copy and Paste values from the table to a different program, click on any of the data lines in the main window. The Edit Form window will open - it can be re-sized if necessary by dragging one of the corners. Double-Click on any of the form values to select them, then right-click > Copy to copy to the Clipboard. You can also use the standard Windows shortcut: Control-C.