
Closed
Posted
Paid on delivery
I need a single Microsoft Excel workbook that already contains a full, properly scaled map of the United States—every state, every county. Inside that file I want to be able to: • Fill or change the color of any county so I can instantly show where each customer is located as we add new business. • Add, remove, or recolor states automatically when several counties inside them are selected. • Place one clearly visible annotation that identifies our main office; I should be able to move or rename that label myself. My source data will arrive as standard .xls or .xlsx spreadsheets, so the map has to accept county names or FIPS codes from those sheets and update the colors with as little manual work as possible (a macro, Power Query, or any Excel-native method you prefer is fine). Please deliver the finished, unlocked Excel file plus brief instructions that show me how to: 1. import a new customer list, 2. highlight the corresponding counties, and 3. change or move the main-office annotation. If you’ve built similar interactive maps in Excel—especially ones driven by tables or dynamic ranges—let me see a sample screenshot or short video so I can gauge the usability.
Project ID: 40215126
50 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
50 freelancers are bidding on average $134 USD for this job

As a Full stack developer with extensive experience in Excel, I have all skills required to create an interactive and automated map for you. Over the course of 7 years, I've honed my abilities to an exceptional standard, consistently delivering high quality work with 100% accuracy – a level of excellence that has garnered satisfied clients from elite companies such as Metlife GOSC and DXC Technologies. I've often leveraged Excel's capabilities – Macro, Power Query, Visual Basic, etc – to create dynamic worksheets driven by tables and data ranges. Our cooperation won't end with the delivery of the finished product. In line with my client-centric approach, I'll supply you with clear instructions on how to import new data into the map – an essential operation for businesses adding new customers as frequently as yours – as well as how to use them to highlight corresponding counties and change or relocate annotations yourself. If you encounter any issues or face questions related to the map in the next 4 days, worry not! Unlike many other freelancers, I'm dedicated to providing 4 -day long support after completion to ensure your utmost satisfaction.
$180 USD in 3 days
8.6
8.6

With over 15 years of experience, I'm confident that my specialization in data processing, coupled with my skilled use of Excel, makes me the ideal candidate for your editable Excel USA County Map project. From data analysis to advanced spreadsheet design, I've mastered the art of making data readily accessible and user-friendly. In fact, I have created numerous interactive maps similar to what you're requesting- powered by tables or dynamic ranges-using a combination of valuable Excel tools such as Macros and VBA Automation, Dynamic Dashboards, and more. My goal is to make your tasks as seamless as possible using Excel-native methods. With your source data's format in mind, I can design an efficient system that swiftly updates county colors based on names or FIPS codes from your spreadsheets. Additionally, I will equip you with straightforward instructions to import a new customer list, highlight corresponding counties effortlessly, and undertake any necessary changes regarding the main-office annotation. The expertise I've gained in this domain allows me to tailor my solutions right to your unique needs and my collaborative binderştirn approach ensures we work together closely through the completion of the project. Through applying innovative yet practical strategies that optimize your business and elevate efficiency, let's streamline your workflows effectively and uncover new growth opportunities for your business today!
$100 USD in 1 day
6.7
6.7

I can build a fully unlocked Excel workbook containing a complete US map with counties and states, where colors update dynamically based on your customer list and the main-office annotation can be moved or renamed easily.،،،،،،، I’m a Certified Excel VBA Programmer, د with strong hands-on experience in interactive dashboards and mapping.
$50 USD in 1 day
6.5
6.5

Hi, Thank you for considering my proposal. I have carefully reviewed your project requirements for an editable Excel USA County Map. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to deliver a high-quality solution tailored to your needs. I would like to discuss your project further and explore how I can assist you in creating the interactive map you envision. Please feel free to connect with me via chat to delve deeper into the specifics of your project. Regards
$30 USD in 1 day
6.3
6.3

Hello, With over 7 years of experience in Data Processing, Excel, Excel VBA, Data Visualization, Visual Basic, Data Entry, and Data Management, I have carefully reviewed your project requirements for an editable Excel USA County Map. I propose to create a dynamic Excel workbook that includes a fully scalable map of the United States with the ability to fill or change the color of any county to represent customer locations. The workbook will automatically update states based on selected counties and allow for the addition, removal, or recoloring of states. Additionally, I will incorporate a feature to place a customizable annotation for the main office that can be easily moved or renamed by you. To achieve this, I will utilize Excel macros and Power Query to seamlessly integrate your source data in .xls or .xlsx format for efficient updating of county colors. The final deliverable will include the unlocked Excel file along with clear instructions on importing new customer lists, highlighting corresponding counties, and managing the main-office annotation. For further discussion and to explore samples of similar interactive maps I have created, please connect with me in chat. You can visit my profile at https://www.freelancer.com/u/HiraMahmood4072 Thank you.
$100 USD in 2 days
6.4
6.4

Hello, I can build a fully unlocked, interactive Excel workbook containing a complete, properly scaled U.S. map down to the county level, designed to update cleanly from your existing spreadsheets. The map will accept county names or FIPS codes via tables or dynamic ranges and automatically color counties and states as customers are added or changed, using reliable Excel-native methods such as Power Query, formulas, and optional macros to keep manual work to a minimum. I’ll include a clearly visible, movable main-office annotation you can rename or reposition yourself, along with concise instructions showing how to import new data, highlight counties, and adjust the label. I’ve created similar table-driven Excel maps before and can share a sample screenshot or short walkthrough to demonstrate usability and clarity before we proceed. Regards, Zafar
$50 USD in 1 day
6.3
6.3

You need a single Excel workbook with a properly scaled US map down to county level, where colors update from your customer list by county name or FIPS, and you can move a main office label yourself. I will deliver an unlocked Excel file that includes the county map, a simple import table, and a one click refresh that recolors counties and optionally rolls up state colors based on selected counties. You will get clear instructions to import a new list, highlight counties, and edit or move the main office annotation without breaking anything. I have built Excel driven territory maps and dashboards where shapes update from tables with consistent results. Will your customer sheet provide county plus state, or only county or FIPS, and do you want multi state rules like at least 3 counties selected to color the whole state?
$30 USD in 1 day
5.8
5.8

Hi, there, As a skilled freelance engineer with expertise in data visualization and Excel, I am excited to bid for the project 'Editable Excel USA County Map.' I possess a strong background in Excel, Visual Basic, and data analysis, making me the perfect fit for this task. ✅ Leveraging my experience, I will create a dynamic Excel workbook featuring a fully scalable map of the United States with the ability to customize county colors for customer locations seamlessly. ✅ Implementing Excel-native methods like macros and Power Query, I will ensure automated updates based on standard .xls or .xlsx data inputs, reducing manual effort. ✅ To enhance usability, I will enable easy import of customer lists, dynamic county highlighting, and customizable main-office annotation. ✅ You can trust my expertise in data processing and management to deliver a user-friendly Excel file with clear instructions for seamless use. ✅ I have successfully developed interactive Excel maps before and can provide a sample screenshot/video for your review. I look forward to working with you. Best Regards. Brayan
$200 USD in 3 days
5.2
5.2

Hello, I can build the full Excel workbook exactly as you described, with a scalable USA map (states + counties) that automatically updates from your Excel data. I’ve completed several Excel dashboard and automation projects like this before, and I hold an MBA which helps me design solutions that are both technically solid and business-ready. What I will deliver: • Interactive Excel file where counties can be colored automatically using county names or FIPS codes • State coloring that updates dynamically when multiple counties are selected • Movable and editable main-office annotation • Automated import workflow (Power Query / Excel automation) for new customer lists • Clear step-by-step instructions so you can update the map easily anytime I can handle this efficiently and professionally and start immediately. Best Regards, Beshoy
$400 USD in 5 days
5.0
5.0

Leveraging my extensive background in Mechanical Engineering and specialization in automation and data processing, I am uniquely positioned to bring your editable Excel USA County Map to life. My proficiency in 3D modeling and drafting using SolidWorks, as well as my skills in CFD & FEA simulations using ANSYS Fluent / Mechanical, showcase my ability to transform complex data into actionable visualizations - a capability that would serve this very project proficiently. Having successfully completed numerous projects involving Excel automation and driven by tables or dynamic ranges, I am well-versed with the comprehensive utilization of Excel's ingenuities. Notably, I have created numerous automating scripts for engineering-related workflows and various data-oriented tasks similar to your needs. My reputation for fast turnaround and precise work is incredibly valuable when dealing with large-scale datasets such as county-specific customer information. Combined with my meticulous and results-driven business approach, I guarantee a map that not only looks great but integrates seamlessly with your data entry processes. You can trust me to deliver a top-notch product that empowers you to effortlessly import new customer lists, highlight corresponding counties, and modify the main office annotation as demanded by your dynamic business landscape. Let's collaborate on this project, and I'll deliver an illustration of the map's usability through sample screenshots or short videos.
$140 USD in 7 days
5.5
5.5

Hello, I understand that you are looking for an Excel-based solution that delivers a fully editable, properly scaled USA map with every state and county, designed to visually track customer locations with minimal manual effort. My approach will focus on building a single unlocked workbook that combines a clean vector-based county map with Excel-native automation for fast updates and long-term usability. I will implement a data-driven structure where counties can be colored automatically based on county names or FIPS codes imported from .xls or .xlsx files. Using VBA, dynamic tables, and conditional logic, the map will update instantly when new customer data is added. State-level coloring will respond automatically when multiple counties are selected, and a clearly visible, movable main-office annotation will be included with simple rename and reposition controls. The solution will remain fully editable without external tools. I have strong experience creating interactive Excel maps driven by tables and dynamic ranges, including county-level visualizations for sales coverage, logistics, and customer analysis. Along with the finished file, I will provide concise instructions covering data import, county highlighting, and annotation control so the workbook can be maintained confidently without technical dependency. Thanks, Asif
$250 USD in 2 days
4.6
4.6

Being a highly proficient user of Excel with a strong background in financial data analysis and visualization, I am confident that I can deliver the exact solution you need for your project. Over my 15+ years as a finance professional, I have extensively used Excel for a wide range of data-driven tasks including building complex dynamic spreadsheets and visualizing data in creative ways. In fact, I have previously built several interactive maps in Excel mainly driven by tables and dynamic ranges simple enough for non-technical users to understand. Although I don't yet have a sample specific to US county maps, I would be happy to share some of my similar projects with you so that you can assess firsthand the usability and quality of my work. By engaging me for your project, you will not only benefit from my expertise in spreadsheet manipulation but also from my financial acumen which means I will ensure 100% accuracy in reflecting your business data onto the map. I will also not only provide you with an unlocked finished Excel file but also offer detailed yet concise instructions on how to import new customer lists, highlight corresponding counties, and alter the main-office annotation yourself for effortless future updates. Don't simply take my word for it; let me prove to you why countless businesses trust me with their financial information!
$150 USD in 7 days
4.3
4.3

As a passionate and experienced GIS Specialist, Web Developer, and Excel VBA expert, I strongly believe I'm the perfect fit for your project. I've spent a majority of my 9+ years in the industry spearheading projects that mirror this very undertaking. My proficiency in ArcGIS and QGIS ensures the coding is full-proofed while my vast knowledge on Excel VBA guarantees optimal and dynamic data utilization within Excel. Regarding your project's vital requirements, I have mastered the art of merging data from multiple sources into interactive, data-driven maps. This means your .xls and .xlsx spreadsheets will work perfectly with the map I'll create for you, minimizing manual intervention—a huge time-saver! Furthermore, my ability to develop geolocation tools using GIS comes into play as you need to highlight corresponding counties when new customers are added. This is paramount in avoiding any oversights and ensuring efficient business monitoring. In addition to the above skillset, my background in Web Development sets me apart from other contenders. The delivery of an unlocked Excel file coupled with a step-by-step guide on how to import new customer lists and change/move label annotations aligns perfectly with my prior experience creating Geospatial Web Apps – real-time interactive maps that simplify tedious tasks
$80 USD in 7 days
4.5
4.5

As a versatile Data Scientist and Excel expert, I have extensive experience in handling complex data analysis and visualization tasks, projects that involve clean manipulation, and organizing large datasets for accurate insights. Excel VBA is one of my specialties and I'm more than capable of creating a highly-functioning, extremely user-friendly map that you're looking for. Moreover, my proficiency in using libraries such as Pandas, NumPy, Matplotlib, Seaborn, and Plotly to analyze large datasets and create insightful visualizations is a great asset to this project. The dynamic nature of your project requires the use of tables and dynamic ranges which I have successfully worked on several times before. I am fully confident in creating an automated process for importing new customer lists, tracking corresponding counties and modifying main-office annotations; minimizing manual work yet ensuring a seamless usability.
$30 USD in 1 day
4.3
4.3

As an expert in data entry, processing and Excel, I have the necessary skills to create an interactive map for your business needs. I understand that time is of the essence in your business, and I assure you that I value it as much as you do. My proficiency in Excel and VBA will help us develop a map that is efficient, effective and tailored specifically to meet your requirements.
$30 USD in 1 day
4.0
4.0

Hello, I’ve read your brief and can deliver a single, unlocked Excel workbook containing a fully scaled US map with every county, editable colors, and a movable main-office annotation. I’ve built Excel maps driven by tables, Power Query and VBA; I will map incoming .xls/.xlsx county names or FIPS to shapes, use VBA or PQ to color counties, auto-aggregate state fills when multiple counties are selected, and add a movable/renamable office label. I will deliver the finished file plus concise import/use instructions (import customer list, highlight counties, move/rename annotation) and a short screenshot or video demo on request. Next step: I’ll prepare a sample workbook and start once you confirm preferred matching method and provide a small sample file. Best regards,
$120 USD in 1 day
4.0
4.0

Good Day We can build an interactive Excel workbook with a fully scaled US map showing every state and county. With our experience in Excel automation we will use macros or Power Query to color counties by name or FIPS with minimal manual work. We will enable dynamic state coloring annotation control and deliver an unlocked file with clear instructions for updates. Do you prefer macros or a formula based approach for updates Best regards Future Station
$100 USD in 1 day
3.6
3.6

Hey! I have just read your project description that you are in search of a professional who can generate leads for you. I have a LinkedIn sales navigator account and different paid tools to generate the accurate data. I have a lot of experience in this field with over more than 8 years. I can provide you these details as per the budget decided: Contact Name / Contact Email / Designation / Company / General Email / Phone Number / Street Address / City / Country / Fax Number / Company LinkedIn Profile / Personal LinkedIn Profile / Number of Employees (Company Size) / Industry More details can be discussed over chat. Regards.
$80 USD in 3 days
3.7
3.7

Hi there, I understand you need a fully interactive US map in Excel showing every state and county, allowing dynamic customer visualization and a movable main-office annotation. My approach will begin by integrating a full US map using Excel shapes or a reliable shapefile import, linking each county to a structured table with FIPS codes or county names. I will implement dynamic coloring with VBA macros or Power Query so that adding new customer data automatically highlights the relevant counties, while states update based on their constituent counties. The main-office annotation will be built as a dynamic text box that can be moved or renamed without affecting the map. I will ensure all formulas, ranges, and macros are documented and user-friendly, so future updates are effortless. Deliverables: An unlocked, ready-to-use Excel workbook with interactive county/state colouring, movable main-office annotation, and step-by-step instructions for importing new data, triggering updates, and managing annotations. QUESTION: Should county colours update automatically as new data is added, or via a manual refresh button for control? I’m ready to start immediately and deliver a robust, scalable map solution that simplifies customer location analysis. Regards, Shehwani.
$80 USD in 1 day
3.7
3.7

Hi, Employer, I have 7+ years of experience in creating dynamic Excel solutions, specializing in data visualization and Excel VBA. I have mastered the required skills to deliver an interactive and editable USA county map in Excel that meets your needs. My background includes developing similar projects where I transformed static data into intuitive visual tools. ✅ I'll begin by integrating a detailed map of the US into Excel, ensuring each state and county is accurately represented. ✅ Next, I'll implement an automated system to change county colors based on your customer data using macros or Power Query, facilitating seamless updates. ✅ A dynamic feature will be added to allow easy state recoloring when multiple counties are selected, enhancing visual clarity. ✅ I'll incorporate a movable and editable label for your main office, ensuring your key location is prominently displayed. ✅ Finally, I’ll provide a user-friendly guide to help you import new data, highlight counties, and manage the main-office annotation effortlessly. I look forward to working with you. Best Regards, Rosita Iniesta.
$100 USD in 5 days
2.6
2.6

Indianapolis, United States
Member since Feb 8, 2026
$3000-5000 USD
$750-1500 USD
₹600-800 INR
$30-250 AUD
$15-25 USD / hour
$2-8 USD / hour
₹12500-37500 INR
$15-25 USD / hour
$30-250 USD
₹12500-37500 INR
$15-25 USD / hour
₹600-1500 INR
£20-250 GBP
$250-750 USD
₹100-400 INR / hour
$250-750 USD
$250-750 USD
$10-30 USD
€30-250 EUR
₹12500-37500 INR