1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Get Data From Picture (File/Clipboard)

Our take

Are you facing challenges extracting data from screenshots in Tableau? You're not alone. A user recently shared their experience with the "Get Data" feature in Excel, which consistently stalls at 20% when attempting to pull information from images. This process can be frustrating, but there may be effective strategies to overcome this hurdle. If you're interested in enhancing your data skills further, consider checking out our article "Best SQL Courses in 2026 (Ranked and Compared)" for valuable insights. Let’s explore solutions together!

In today’s data-driven landscape, the ability to efficiently extract and manipulate data is more crucial than ever. A recent inquiry from a user looking to compare column lists in Tableau highlights the challenges many face when transitioning between different data sources. The user’s method of taking screenshots and attempting to use Excel's "Get Data" feature to extract text underscores a common scenario: the limitations of current tools when dealing with non-standard data formats. This situation resonates with many users who have experienced similar hurdles, prompting the community to seek innovative solutions. Such exploration is essential, as it not only reflects the need for improved functionality in existing tools but also highlights the importance of user-centric design in software development.

The issue of Excel getting stuck at 20% when attempting to extract data from screenshots is symptomatic of the broader friction that can occur when integrating disparate data sources. This is not an isolated case. As seen in related discussions, such as those found in articles like COUNTIF in named column without knowing the row number, users are continuously seeking ways to overcome the limitations of legacy systems. The challenge is further compounded by the growing expectation for tools to handle complex data operations with ease. When users encounter such obstacles, it can hinder their productivity and discourage experimentation with advanced features, ultimately stifling innovation.

The relationship between user experience and data management tools is critical. As noted in the inquiry, the user is turning to community forums for tried and tested hacks, indicating a gap in the current capabilities of software like Excel to accommodate unconventional data inputs. This scenario invites us to reflect on the future of data extraction technologies. As we move toward more AI-driven solutions, there is a pressing need for tools that not only simplify data handling but also empower users to work creatively without getting bogged down by technical limitations. For instance, advancements in AI could enable more intuitive data extraction methods that require less manual intervention, allowing users to focus on analysis rather than data gathering.

Looking ahead, the key question for developers and users alike is: how can we bridge the gap between traditional data management practices and the evolving needs of modern data utilization? The challenge lies in creating solutions that are both innovative and accessible, ensuring that users are not left behind by the rapid pace of technological advancement. This inquiry about extracting data from screenshots serves as a reminder that, while we have made significant strides in data management, there is still much work to be done to create a seamless experience that empowers users.

As the conversation around data management evolves, we should remain vigilant about the tools we use and the ways we can collaborate to enhance their capabilities. It is crucial to advocate for solutions that prioritize user experience and foster an environment where creativity and efficiency can thrive. The journey toward a more integrated and user-friendly data landscape is ongoing, and with continued dialogue and innovation, we can aspire to create a future where data management is not just functional but transformative.

Hi!

My objective is to compare the list of columns in two different data sources/tables in Tableau to swap the source.

My plan: Get screenshots of the fields in the two tables and use Excel (Get Data -> From File/Clipboard) to extract the columns from the screenshots and compare them.

However, "Get Data" is getting stuck at 20% always when I am trying. The same happens for From File as well as From Clipboard.

I'm wondering whether the champs in this group have any tried and tested hacks to Get Data from a picture?

Cheers!

submitted by /u/Cautious_Cost6781
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#Get Data#picture#Excel#File#Clipboard