Please login or register to upload a CSV.

---

More info

The CSV (comma seperated value) format is a common format used to save data from spreadsheets, for example from Excel.
Your spreadsheet software should have a function to export your data to CSV, which can be translated directly into places on Place.Guru.

Example CSV

Below you can see how your data should be structured, before uploading it.
These are the "Header column" values in your spreadsheet editor.
Note: All headers are lowercase

Header	Example	Required/Optional
name	Place.Guru HQ	Required
latitude	51.059685	Required, unless address is given
longitude	3.732345	Required, unless address is given
address	Blekerijstraat 75, 9000 Ghent, Belgium	Optional
privacy	public or private	Optional, default: private
description	This is where Place.Guru's headquarters are, it's a humble ....	Optional
email	contact@place.guru	Optional
phone_number	+32 456 789 713	Optional
website	https://place.guru	Optional
facebook	http://www.facebook.com/placeguru	Optional
linkedin	https://linkedin.com/yourName	Optional
twitter	Placeguru	Optional
instagram	Placeguru	Optional
video	https://www.youtube.com/watch?v=K_xTet06SUo	Optional
image	http://john-doe.com/images/photo.jpg	Optional
image_caption	This is where we work.	Optional
image_attribution	Credit: John Doe	Optional
image_attribution_link	http://john-doe.com	Optional

Here's an example of how to format your CSV data:

name;latitude;longitude;address;privacy;description;email;phone_number;website;facebook;linkedin;twitter;instagram;video;image;image_caption;image_attribution;image_attribution_link Place.Guru HQ;51.059685;3.732345;"Blekerijstraat 75; 9000 Ghent; Belgium";public;"This is where Place.Guru's headquarters are; it's a humble ....";contact@place.guru;+32 456 789 713;https://place.guru;http://www.facebook.com/placeguru;https://linkedin.com/yourName;Placeguru;Placeguru;https://www.youtube.com/watch?v=K_xTet06SUo;;;; Place.Guru QA;51.049685;3.532345;"Blekerijstraat 75; 9000 Ghent; Belgium";private;"This is where we QA";qa@place.guru;;;;;PlaceguruQA;Placeguru;;;;;

When uploading CSV files, keep the following in mind:

• Check if all headers are correct (check for spelling, and capitals)
• CSV files must contain the name column, and either the address column or both longitude and latitude columns
• Maximum 500 places per CSV
• The delimiter is automatically detected. When in doubt, use comma ( , ) or semicolon ( ; )