Importing data to location column

Hello all,

I am new to the data management system and I am in need of assistance. I am building a board to keep track of the information of over 500 volunteers in my organization. I have successfully imported the data from an Excel sheet into the system, but I am having trouble changing some of the column types to what I need them to be.

For example, I have a column that contains the addresses of all the volunteers, but I am unable to change the column type to a “Location” type. Instead, the only option I have is to leave it as a “Text” column. This is also the case for the “Country” column and a few others.

I would like to know if there is a way to change the column type to a more specific type, such as “Location” or “Country”? If not, is there a way to copy all the column values and paste them into a new column that I can then designate as the desired type? I am trying to avoid the tedious task of manually copying and pasting 500 cells.

Any help on this matter would be greatly appreciated. Thank you in advance!

2 Likes

Hi @tomerS - as you have seen there are a number of limitations to the monday import. We tend to lean towards make.com to handle importing to these types of columns.

Make has a free tier depending on usage so this might be a good workaround.
Mark

Is there a guide to how i can do that via make.com?

Hi @tomerS - while I dont believe there is a specific guide, it wouldnt be too much work to put together.

Basically, you would create a simple scenario that includes Excel (or Sheets) and monday

There needs to be a matching column in the sheet to a column in the monday board. From there you can select which columns you want to update. In the case of a Location column, you need to supply the Lat/Long as well as a name:

For Country columns you need the Code and Name:

image

Not sure if you have all this information handy in order to update?

Thanks
Mark

thank you very much for the detailed reply.
i have address in simple address format (street, house number, city, state, postal code, country)
how can i convert it to (lat,long) coordinates format easily?

There are various websites that can do this for you: Convert Address to Coordinates

1 Like

Yes I see, still can’t find a free way to do it for a list.
Thank you

Hi Mark - what do you mean “create a simple scenario” using Sheets and Monday? (sorry if this is a newbee question). I have my data in address form and lat/lon, but i cant seem to get to the screen that you have shown in your screen shot below?

Hi @mattnelsen - just to confirm, this is within make.com to complete, not monday. Do you have a make.com scenario setup to manage this?

No I do not have make.com. But I guess I should look into that now. Thanks!