Convert Location Column to Individual Columns

Platform discussions
1

The location column is not working for me and I want to parse it out into separate columns. Easy enough moving forward, but how would I deal with the information already contained in the spreadsheet? Can I export and import for a bulk update? I understand making the change would affect my automations, but are there any other pitfalls I’m missing? Thanks!

2

Got it! Here’s a breakdown of how to handle this situation in Monday.com:

1. Parsing existing Location column data into separate columns

Since the Location column is not working as you want, you want to split that data into multiple columns (like City, State, Country, etc.).

2. Exporting and importing for bulk update

  • Export: You can export your board data as an Excel or CSV file, which will include all your current information.
  • Edit: In Excel or Google Sheets, you can split the Location column into multiple columns using text functions (like Text to Columns or formulas).
  • Import: Then you can import the updated file back into Monday.com to update the board.

Important: Monday.com does not currently support direct import that updates existing items based on IDs, so you can’t just re-import and have it update existing rows automatically. Instead:

  • You would typically need to create a new board and import the cleaned data.
  • Or, use Monday.com’s API or third-party tools (like Integromat/Make or Zapier) for a more sophisticated bulk update of existing items.

3. Pitfalls to watch out for besides automations:

  • Item IDs change: If you create a new board and import, item IDs will be different, so automations or integrations referencing old item IDs will break.
  • Loss of history: Comments, updates, and activity logs tied to items in the original board do NOT carry over in export/import.
  • Linked columns: If you have columns linked to other boards, the import may not maintain those links.
  • Column types: When importing, some column types (like formulas, status, or location) may not import correctly and might need manual fixing.
  • Permissions and views: Your board settings, views, and permissions will not carry over with an import.

Summary recommendation:

  • For small to medium-sized boards, consider manually splitting the data and updating it directly in Monday.com or using formulas in separate columns, then copying the cleaned data over.
  • For larger boards, consider using the API or automation platforms to programmatically update items.
  • Test everything on a copy of your board first to avoid data loss.

If you want, I can help you with:

  • How to split the data in Excel before import
  • Tips for using the API or automation tools for bulk updates
  • A step-by-step export/import workflow