Best way to convert addresses off the web to csv

 

Whats the easiest way to convert this list of business addresses to a csv?

Here's the url of the addresses...

http://www.holidaystationstores.com/locations/locations.shtm...

I can copy and paste that into excel but wow does it needs lots of editing.

Any ideas

Notepad

You could paste into notepad....delete the garbage.....add a pipe (|) as a delimiter, save as a CSV file and import into excel.

?

Have you thought about asking the company if they can supply you with a spreadsheet with coordinates? You could even offer to provide them with the POI file for posting on their site. Failing that, have you done a search for "geocoding"? There are multiple sites that can do batch geocoding.

--
Nuvi 660 -- and not upgrading it or maps until Garmin fixes long-standing bugs/problems, and get maps to where they are much more current, AND corrected on a more timely basis when advised of mistakes.

Using ASAP Utility

allisong6 wrote:

Whats the easiest way to convert this list of business addresses to a csv?
.
.
.
I can copy and paste that into excel but wow does it needs lots of editing.

Any ideas

You can find all answers here:

http://www.poi-factory.com/node/2115

Scroll down the page and find the post that describes the whole procedure using ASAP Utility (it is an Excel add-on and you can download it for free, just google for ASAP Utility). For me that is the easiest way and it is fast too.

ASAP not working

hercegovac wrote:
allisong6 wrote:

You can find all answers here:

http://www.poi-factory.com/node/2115

Scroll down the page and find the post that describes the whole procedure using ASAP Utility

Thanks for all the suggestions so far.

I'm running into a problem with using ASAP utilites. Its the way the information is on the holiday website.

It basically lists a town, then all the holiday stores in that town. This doesn't create a problem when there is only 1 station per town as I'm then left with 4 lines of info for that station.

Problem is when a town has multiple stations. The first station has 4 lines of info and the remaining stations in that town only have 3 lines.

I also can't remove the blank lines in between. This shouldn't be a problem as long as I could get conisistent addresses of 3 lines, then 2 blank lines.

I'm sending in email to Holiday to ask them to create a poi file.

Holiday Stationstores

allisong6 wrote:

Whats the easiest way to convert this list of business addresses to a csv?

Here's the url of the addresses...

http://www.holidaystationstores.com/locations/locations.shtm...

I can copy and paste that into excel but wow does it needs lots of editing.

Any ideas

You can go to Google maps at http://maps.google.com/maps and after creating free account use the my map feature.I done a search using Google maps and typed in Holiday Stationstores and a long listing came up.You can do the search without account.If you use my maps method you will need to check it against your list in case of some stores now being closed.Using my maps features once you have located all the locations and saved them all the coordinates will be on the finish product.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

Better Appreciation

Your question is totally valid and asked often. The replies are also totally valid. Depending on the way chain store websites format their locator info, making a POI file out of it can be fairly easy or very difficult.

The first few I tried gave me a much greater appreciation for how much time and work the file authors and maintainers here at the POI Factory have put in to some of these files. One that I am working on now is not a chain, so there is no single website I can go to for an address list. Each location has to be individually Googled, visually identified on Google Earth and/or MapQuest and manually entered into the csv file. I have been working on it (off and on) for weeks and I'm still not done.

I know now why folks like ScottK received a Contributor of the Year (COY) award. Personally, I don't know how he has managed to do what he has done, for so long. My hat is off to all of the POI file authors and maintainers.

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2019.30 CN NA NT maps | Magellan Meridian Gold

You can say that again.I

You can say that again.I like to use Google my maps so you can see the location on the map when you click on the marker.I use two screens at a time .The Google my maps and the other screen for the name and address.That way I can paste the name of the business in my maps and look at other screen to make sure it matches.I found my maps a lot faster then using excel.Using the excel you still have to go back and get the coordinates.Google maps saves all at one time.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

I'm a noob

allisong6 wrote:

Whats the easiest way to convert this list of business addresses to a csv?

Probably look for the one that's already done.

http://www.poi-factory.com/node/19542#comment-111415

CSV files

I'm still a newb and I haven't cranked up to speed (yet) with POI creations or looked at this ASAP, but..

I LOVE using Excel and I made a rough file for these stores in about 5 minutes just now after reading your post. It's not ready for prime time POIism, but for now I'll tell you:

1. MS Excel
2. Find out about "web queries" (in Excel help file)
3. Get familiar with some of the Excel function formulas (click & pick easy)

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.

I would download the asap

I would download the asap utilities the first chance you get.Lots of extras but one of the main ones is searching for duplicates.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Here WeGo - Offline Maps & GPS.

Don't reinvent the wheel?

JD4x4 wrote:

[snip] I made a rough file for these stores in about 5 minutes just now after reading your post.

Doh! Told you I was a newb! The previous metion of using the list that's already created is probably the BEST one!

But.. web queries & Excel function formulas ROCK anyway! mrgreen

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.

Excel Queries are pretty easy

JD4x4 wrote:

1. MS Excel
2. Find out about "web queries" (in Excel help file)
3. Get familiar with some of the Excel function formulas (click & pick easy)

WOW. I just tried it with one quick read through of the excel help files. That was actually pretty easy.

Holiday stationstores

allisong6 wrote:

Whats the easiest way to convert this list of business addresses to a csv?

Here's the url of the addresses...

http://www.holidaystationstores.com/locations/locations.shtm...

I can copy and paste that into excel but wow does it needs lots of editing.

Any ideas

TUPDEGROVE has already posted the CSV with all the locations. It was one of the files that earned him his COW.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

Yes, it is

allisong6 wrote:
JD4x4 wrote:

1. MS Excel
2. Find out about "web queries" (in Excel help file)
3. Get familiar with some of the Excel function formulas (click & pick easy)

WOW. I just tried it with one quick read through of the excel help files. That was actually pretty easy.

Indeed, it is. I already adopted this procedure. smile

Link to POI

Missed this thread. Here is the link. www.poi-factory.com/node/19613

a_user wrote:

TUPDEGROVE has already posted the CSV with all the locations. It was one of the files that earned him his COW.