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!
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
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:
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?
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?