Upload a CSV (FTP)
If you have a large volume of data to upload to us, using FTP is mre efficient than sending it by email. You can upload a CSV to our FTP submissions system in the same format as the email method. You will need to download the template CSV, fill it in with your information, and then use an FTP program such as Filezilla to upload it to us.
Step 1: Download the template
First of all, download and open this file to see our sample data. This will give you a good ideas of how to add your own rows.
 |
Download the template spreadsheet It'll take about 4 seconds, and you can open it in Excel. Or Notepad. |
Open the spreadsheet by double clicking on the file on your computer. It may open in Microsoft Excel, or another spreadsheet application if you have one installed on your computer. You should see something like this:
Step 2: Complete the spreadsheet
Row 1 of the template is the column headings, which tells you what to type in the column. You can replace row 2 if you like - we've just put that in as an example. You now need to fill in the rows with details of your property. Remember that your submission will be read by a computer system, not a 'real person', so you must stick to the rules if you are to avoid your spreadsheet being rejected. Each column must contain the right information, as shown in the following table:
| Column | Column heading | What to provide | Max length | Example |
|---|---|---|---|---|
| A | Your reference | [Critical] A number or code which identifies the property. If you send us the same property in several spreadsheets, please make sure it has the same reference, otherwise we'll think you're talking about a new property. | 50 characters | 12345 |
| B | Title | [Required] The headline of the property particulars. We'd prefer this to be a road name or property/building name. | 30 characters | "Bristol Avenue", "Argrove Mansions", "Lakefield House" |
| C | Num beds | [Required] The number of bedrooms in the property. If it's a studio, enter 0, but it has to be a number. | Number | 2 |
| D | Address | A more general description of the area in which the property is located. Does not have to be a full address. Please do not repeat the information entered in 'Title'. | 50 characters | "Twickenham, Middlesex" |
| E | Postcode | [Critical] Enter the full postcode of the property. This is essential to enable us to plot it correctly on the map. | 8 characters | TW1 0AA |
| F | Property type | [Required] We only recognise two different types of property, so please set this to 'house' or 'flat', depending only on whether there are several properties occupying the same freehold. | "house" or "flat" only | "house" |
| G | Price | [Required] Enter the price of the property as a number, in pounds sterling. If this is a lettings submission, enter the rent in pounds per calendar month (even if the rent is normally charged weekly). | Number | 267950 |
| H | Contact name | Enter the name of the person or agency branch that should be contacted for more details about the property. | 50 characters | "My Agency Twickenham Branch" |
| I | Phone | Enter the phone number of the person or office named in the previous column. Use only numbers and spaces, and pay attention to the correct spacing of phone numbers in your area - for example London is 020 XXXX XXXX, not 020X XXX XXXX. | 25 characters | "020 0000 0000" |
| J | Link URL | [Required] Enter a full URL (internet address) of the specific page on which a person can view the particulars of this property. | 255 characters | "http://www.example.com/prop12345.html" |
| K | Image URL | Enter a full URL (internet address) of an image showing the property. The image should be approx 100x70 pixels if possible (it will be resized to those dimensions if it isn't 100x70 already). | 255 characters | "http://www.example.com/images/12345.jpg" |
| L | Decription | Optional full description of the property. Not currently used but we will allow people to search this in the near future. | 30,000 characters | "Spacious modern family home...." |
| M | Source ID |
Only fill this field in if you have an OnOneMap sourceid. You should get one of these if you are planning to submit large numbers of properties to us on a regular basis, as it allows your properties to be credited to you by name. If you do not provide a sourceid, the submission will be considered anonymous. Software vendors or any organisation submitting on behalf of lots of agents can use several different source IDs within the same spreadsheet. See below for details of how to obtain a source ID. |
numeric | 1234 |
| N | Category |
[Required] Set to 'Sales' or 'Rentals' to indicate the category in which the property belongs. This also affects the way in which the price should be expressed - sale price in the case of sales, rent per month for rentals. |
'Sales' or 'Rentals' only | "Sales" |
Step 3: Upload the spreadsheet
Save your spreadsheet as a CSV file (in Excel there is an option in the Save dialog box to save as 'Comma Separated Values'). Using FTP, connect to ftpsubmissions.ononemap.com, as an anonymous user. Upload your file. When you end your session, the files you have uploaded will be processed immediately.
If our computer understands your spreadsheet, the valid entries will be added to our load queue straight away. The property will appear on the site within 24 hours. Thanks for submitting your property information to OnOneMap!
If your submission file is particularly large, you can compress it using Gzip or 7zip.
Troubleshooting
If you find that your properties do not appear on the site within 24 hours, or you want a receipt for every submission, you can request an email confirmation from our FTP submissions system. Just name your file youremailaddress.csv, and we'll send a receipt to that address when we finish processing the file. For example:
ononemap.csv
If you name your file as shown above, you will not receive a receipt or any feedback from our system. However, if you name you file as shown below, an email will be sent to joe@example.com as soon as the file has been processed:
joe@example.com.csv