30 September 2019

Google brings its Jacquard wearables tech to Levi’s Trucker Jacket


Back in 2015, Google’s ATAP team demoed a new kind of wearable tech at Google I/O that used functional fabrics and conductive yarns to allow you to interact with your clothing and, by extension, the phone in your pocket. The company then released a jacket with Levi’s in 2017, but that was expensive, at $350, and never really quite caught on. Now, however, Jacquard is back. A few weeks ago, Saint Laurent launched a backpack with Jacquard support, but at $1,000, that was very much a luxury product. Today, however, Google and Levi’s are announcing their latest collaboration: Jacquard-enabled versions of Levi’s Trucker Jacket.

These jackets, which will come in different styles, including the Classic Trucker and the Sherpa Trucker, and in men’s and women’s versions, will retail for $198 for the Classic Trucker and $248 for the Sherpa Trucker. In addition to the U.S., it’ll be available in Australia, France, Germany, Italy, Japan and the U.K.

The idea here is simple and hasn’t changed since the original launch: a dongle in your jacket’s cuff connects to conductive yarns in your jacket. You can then swipe over your cuff, tap it or hold your hand over it to issue commands to your phone. You use the Jacquard phone app for iOS or Android to set up what each gesture does, with commands ranging from saving your location to bringing up the Google Assistant in your headphones, from skipping to the next song to controlling your camera for selfies or simply counting things during the day, like the coffees you drink on the go. If you have Bose noise-canceling headphones, the app also lets you set a gesture to turn your noise cancellation on or off. In total, there are currently 19 abilities available, and the dongle also includes a vibration motor for notifications.

2019 09 30 0946 1

What’s maybe most important, though, is that this (re-)launch sets up Jacquard as a more modular technology that Google and its partners hope will take it from a bit of a gimmick to something you’ll see in more places over the next few months and years.

“Since we launched the first product with Levi’s at the end of 2017, we were focused on trying to understand and working really hard on how we can take the technology from a single product […] to create a real technology platform that can be used by multiple brands and by multiple collaborators,” Ivan Poupyrev, the head of Jacquard by Google told me. He noted that the idea behind projects like Jacquard is to take things we use every day, like backpacks, jackets and shoes, and make them better with technology. He argued that, for the most part, technology hasn’t really been added to these things that we use every day. He wants to work with companies like Levi’s to “give people the opportunity to create new digital touchpoints to their digital life through things they already have and own and use every day.”

What’s also important about Jacquard 2.0 is that you can take the dongle from garment to garment. For the original jacket, the dongle only worked with this one specific type of jacket; now, you’ll be able to take it with you and use it in other wearables as well. The dongle, too, is significantly smaller and more powerful. It also now has more memory to support multiple products. Yet, in my own testing, its battery still lasts for a few days of occasional use, with plenty of standby time.

jacquard dongle

Poupyrev also noted that the team focused on reducing cost, “in order to bring the technology into a price range where it’s more attractive to consumers.” The team also made lots of changes to the software that runs on the device and, more importantly, in the cloud to allow it to configure itself for every product it’s being used in and to make it easier for the team to add new functionality over time (when was the last time your jacket got a software upgrade?).

He actually hopes that over time, people will forget that Google was involved in this. He wants the technology to fade into the background. Levi’s, on the other hand, obviously hopes that this technology will enable it to reach a new market. The 2017 version only included the Levi’s Commuter Trucker Jacket. Now, the company is going broader with different styles.

“We had gone out with a really sharp focus on trying to adapt the technology to meet the needs of our commuter customer, which a collection of Levi’s focused on urban cyclists,” Paul Dillinger, the VP of Global Product Innovation at Levi’s, told me when I asked him about the company’s original efforts around Jacquard. But there was a lot of interest beyond that community, he said, yet the built-in features were very much meant to serve the needs of this specific audience and not necessarily relevant to the lifestyles of other users. The jackets, of course, were also pretty expensive. “There was an appetite for the technology to do more and be more accessible,” he said — and the results of that work are these new jackets.

IMG 20190930 102524

Dillinger also noted that this changes the relationship his company has with the consumer, because Levi’s can now upgrade the technology in your jacket after you bought it. “This is a really new experience,” he said. “And it’s a completely different approach to fashion. The normal fashion promise from other companies really is that we promise that in six months, we’re going to try to sell you something else. Levi’s prides itself on creating enduring, lasting value in style and we are able to actually improve the value of the garment that was already in the consumer’s closet.”

I spent about a week with the Sherpa jacket before today’s launch. It does exactly what it promises to do. Pairing my phone and jacket took less than a minute and the connection between the two has been perfectly stable. The gesture recognition worked very well — maybe better than I expected. What it can do, it does well, and I appreciate that the team kept the functionality pretty narrow.

Whether Jacquard is for you may depend on your lifestyle, though. I think the ideal user is somebody who is out and about a lot, wearing headphones, given that music controls are one of the main features here. But you don’t have to be wearing headphones to get value out of Jacquard. I almost never wear headphones in public, but I used it to quickly tag where I parked my car, for example, and when I used it with headphones, I found using my jacket’s cuffs easier to forward to the next song than doing the same on my headphones. Your mileage may vary, of course, and while I like the idea of using this kind of tech so you need to take out your phone less often, I wonder if that ship hasn’t sailed at this point — and whether the controls on your headphones can’t do most of the things Jacquard can. Google surely wants Jacquard to be more than a gimmick, but at this stage, it kind of still is.

IMG 20190930 104137IMG 20190930 104137


Read Full Article

Fresh Pears


Fresh Pears

Large-Scale Multilingual Speech Recognition with a Streaming End-to-End Model




Google's mission is not just to organize the world's information but to make it universally accessible, which means ensuring that our products work in as many of the world's languages as possible. When it comes to understanding human speech, which is a core capability of the Google Assistant, extending to more languages poses a challenge: high-quality automated speech recognition (ASR) systems require large amounts of audio and text data — even more so as data-hungry neural models continue to revolutionize the field. Yet many languages have little data available.

We wondered how we could keep the quality of speech recognition high for speakers of data-scarce languages. A key insight from the research community was that much of the "knowledge" a neural network learns from audio data of a data-rich language is re-usable by data-scarce languages; we don't need to learn everything from scratch. This led us to study multilingual speech recognition, in which a single model learns to transcribe multiple languages.

In “Large-Scale Multilingual Speech Recognition with a Streaming End-to-End Model”, published at Interspeech 2019, we present an end-to-end (E2E) system trained as a single model, which allows for real-time multilingual speech recognition. Using nine Indian languages, we demonstrated a dramatic improvement in the ASR quality on several data-scarce languages, while still improving performance for the data-rich languages.

India: A Land of Languages
For this study, we focused on India, an inherently multilingual society where there are more than thirty languages with at least a million native speakers. Many of these languages overlap in acoustic and lexical content due to the geographic proximity of the native speakers and shared cultural history. Additionally, many Indians are bilingual or trilingual, making the use of multiple languages within a conversation a common phenomenon, and a natural case for training a single multilingual model. In this work, we combined nine primary Indian languages, namely Hindi, Marathi, Urdu, Bengali, Tamil, Telugu, Kannada, Malayalam and Gujarati.

A Low-latency All-neural Multilingual Model
Traditional ASR systems contain separate components for acoustic, pronunciation, and language models. While there have been attempts to make some or all of the traditional ASR components multilingual [1,2,3,4], this approach can be complex and difficult to scale. E2E ASR models combine all three components into a single neural network and promise scalability and ease of parameter sharing. Recent works have extended E2E models to be multilingual [1,2], but they did not address the need for real-time speech recognition, a key requirement for applications such as the Assistant, Voice Search and GBoard dictation. For this, we turned to recent research at Google that used a Recurrent Neural Network Transducer (RNN-T) model to achieve streaming E2E ASR. The RNN-T system outputs words one character at a time, just as if someone was typing in real time, however this was not multilingual. We built upon this architecture to develop a low-latency model for multilingual speech recognition.
[Left] A traditional monolingual speech recognizer comprising of Acoustic, Pronunciation and Language Models for each language. [Middle] A traditional multilingual speech recognizer where the Acoustic and Pronunciation model is multilingual, while the Language model is language-specific. [Right] An E2E multilingual speech recognizer where the Acoustic, Pronunciation and Language Model is combined into a single multilingual model.
Large-Scale Data Challenges
Using large-scale, real-world data for training a multilingual model is complicated by data imbalance. Given the steep skew in the distribution of speakers across the languages and speech product maturity, it is not surprising to have varying amounts of transcribed data available per language. As a result, a multilingual model can tend to be more influenced by languages that are over-represented in the training set. This bias is more prominent in an E2E model, which unlike a traditional ASR system, does not have access to additional in-language text data and learns lexical characteristics of the languages solely from the audio training data.
Histogram of training data for the nine languages showing the steep skew in the data available.
We addressed this issue with a few architectural modifications. First, we provided an extra language identifier input, which is an external signal derived from the language locale of the training data; i.e. the language preference set in an individual’s phone. This signal is combined with the audio input as a one-hot feature vector. We hypothesize that the model is able to use the language vector not only to disambiguate the language but also to learn separate features for separate languages, as needed, which helped with data imbalance.

Building on the idea of language-specific representations within the global model, we further augmented the network architecture by allocating extra parameters per language in the form of residual adapter modules. Adapters helped fine-tune a global model on each language while maintaining parameter efficiency of a single global model, and in turn, improved performance.
[Left] Multilingual RNN-T architecture with a language identifier. [Middle] Residual adapters inside the encoder. For a Tamil utterance, only the Tamil adapters are applied to each activation. [Right] Architecture details of the Residual Adapter modules. For more details please see our paper.
Putting all of these elements together, our multilingual model outperforms all the single-language recognizers, with especially large improvements in data-scarce languages like Kannada and Urdu. Moreover, since it is a streaming E2E model, it simplifies training and serving, and is also usable in low-latency applications like the Assistant. Building on this result, we hope to continue our research on multilingual ASRs for other language groups, to better assist our growing body of diverse users.

Acknowledgements
We would like to thank the following for their contribution to this research: Tara N. Sainath, Eugene Weinstein, Bo Li, Shubham Toshniwal, Ron Weiss, Bhuvana Ramabhadran, Yonghui Wu, Ankur Bapna, Zhifeng Chen, Seungji Lee, Meysam Bastani, Mikaela Grace, Pedro Moreno, Yanzhang (Ryan) He, Khe Chai Sim.

Instagram launches a ‘creators’ account to encourage more… creation


Instagram deployed a new tool today that should help it continue to build a more viable alternative to YouTube for individual creators looking to try a different platform. It’s a dedicated account called @creators, which will deliver tips and tricks for people hoping to become more active on the platform.

Based on the pinned FAQ story that Instagram has posted to the account, and a brief explainer with some testimonials from actual creators using the platform. Some of the questions that Instagram answers include how to get Verified, which must be asked so incredibly frequently by this particular set of folks.

The grid posts of @creators include some helpful tips like pointing out that 60% of people listen to stories on the platform with the sound on. Clearly, the account is geared towards pushing video creation tips and tools, which makes sense given that’s an area of growth for the company, and a way for it to win over disaffected YouTubers and younger creators who are looking for their new home on the web.

This could be a huge potential opportunity for Instagram, in fact, and this account, while a small part of an overall approach to wooing creators, is a good one.


Read Full Article

SmartNews’ head of product on how the news discovery app wants to free readers from filter bubbles


Since launching in the United States five years ago, SmartNews, the news aggregation app that recently hit unicorn status, has quietly built a reputation for presenting reliable information from a wide range of publishers. The company straddles two very different markets: the U.S. and its home country of Japan, where it is one of the leading news apps.

SmartNews wants readers to see it as a way to break out of their filter bubbles, says Jeannie Yang, its senior vice president of product, especially as the American presidential election heats up. For example, it recently launched a feature, called “News From All Sides,” that lets people see how media outlets from across the political spectrum are covering a specific topic.

The app is driven by machine-learning algorithms, but it also has an editorial team led by Rich Jaroslovsky, the first managing editor of WSJ.com and founder of the Online News Association. One of SmartNews’ goal is to surface news that its users might not seek out on their own, but it must balance that with audience retention in a market that is crowded with many ways to consume content online, including competing news aggregation apps, Facebook and Google Search.

In a wide-ranging interview with Extra Crunch, Yang talked about SmartNews’ place in the media ecosystem, creating recommendation algorithms that don’t reinforce biases, the difference between its Japanese and American users and the challenges of presenting political news in a highly polarized environment.

Catherine Shu: One of the reasons why SmartNews is interesting is because there are a lot of news aggregation apps in America, but there hasn’t been one huge breakout app like SmartNews is in Japan or Toutiao in China. But at the same time, there are obviously a lot of issues in the publishing and news industry in the United States that a good dominant news app might be able to help, ranging from monetization to fake news.

Jeannie Yang: I think that’s definitely a challenge for everybody in the U.S. With SmartNews, we really want to see how we can help create a healthier media ecosystem and actually have publishers thrive as well. SmartNews has such respect for the publishers and the industry and we want to be good partners, but also really understand the challenges of the business model, as well as the challenges for users and thinking of how we can create a healthier ecosystem.


Read Full Article

Africa’s top mobile phone seller Transsion lists in Chinese IPO


Chinese mobile phone and device maker Transsion has listed in an IPO on Shanghai’s STAR Market, a Transsion spokesperson confirmed to TechCrunch. 

Headquartered in Shenzhen, Transsion is a top seller of smartphones in Africa under its Tecno brand. The company has also started to support venture funding of African startups.

Transsion issued 80 million A shares at an opening price of 35.15 yuan (≈ $5.00) to raise 2.8 billion yuan (or ≈ $394 million).

A shares are the common shares issued by mainland Chinese companies and are normally available for purchases only by mainland citizens. 

Transsion’s IPO prospectus is downloadable (in Chinese) and its STAR Market listing application is available on the Shanghai Stock Exchange’s website.

STAR is the Shanghai Stock Exchange’s new Nasdaq-style board for tech stocks that went live in July with some 25 companies going public.

Transsion plans to spend 1.6 billion yuan (or $227 million) of its STAR Market raise on building more phone assembly hubs, and around 430 million yuan ($62 million) on research and development, including a mobile phone R&D center in Shanghai, a company spokesperson said.

To support its African sales network, Transsion maintains a manufacturing facility in Ethiopia. The company recently announced plans to build an industrial park and R&D facility in India for manufacture of phones to Africa.

The IPO comes after Transsion announced its intent to go public and filed its first docs with the Shanghai Stock Exchange in April.

Listing on STAR Market puts Transsion on China’s new exchange — seen as an extension of Beijing’s ambition to become a hub for tech startups to raise public capital. Chinese regulators lowered profitability requirements for the STAR Market, which means pre-profit ventures can list.

China Star Market Opening July 2019 1

Transsion’s IPO comes when the company is actually in the black. The firm generated 22.6 billion yuan ($3.29 billion) in revenue in 2018, up from 20 billion yuan a year earlier. Net profit for the year slid to 654 million yuan, down from 677 million yuan in 2017, according to the firm’s prospectus.

Transsion sold 124 million phones globally in 2018, per company data. In Africa, Transsion holds 54% of the feature phone market — through its brands Tecno, Infinix and Itel — and in smartphone sales is second to Samsung and before Huawei, according to International Data Corporation stats.

Transsion has R&D centers in Nigeria and Kenya and its sales network in Africa includes retail shops in Nigeria, Kenya, Tanzania, Ethiopia and Egypt. The company also attracted attention for being one of the first known device makers to optimize its camera phones for African complexions.

On a 2019 research trip to Addis Ababa, TechCrunch learned the top entry-level Tecno smartphone was the W3, which lists for 3,600 Ethiopian Birr, or roughly $125.

In Africa, Transsion’s ability to build market share and find a sweet spot with consumers on price and features gives it prominence in the continent’s booming tech scene.

Africa already has strong mobile-phone penetration, but continues to undergo a conversion from basic USSD phones, to feature phones, to smartphones.

Smartphone adoption on the continent is low, at 34%, but expected to grow to 67% by 2025, according to GSMA.

This, added to an improving internet profile, is key to Africa’s tech scene. In top markets for VC and startup origination — such as Nigeria, Kenya and South Africa — thousands of ventures are building business models around mobile-based products and digital applications.

If Transsion’s IPO enables higher smartphone conversion on the continent, that could enable more startups and startup opportunities — from fintech to VOD apps.

Another interesting facet to Transsion’s IPO is its potential to create greater influence from China in African tech, in particular as the Shenzhen company moves more definitely toward venture investing.

In August, Transsion-funded Future Hub teamed up with Kenya’s Wapi Capital to source and fund early-stage African fintech startups.

China’s engagement with African startups has been light compared to China’s deal-making on infrastructure and commodities — further boosted in recent years as Beijing pushes its Belt and Road plan.

Transsion’s IPO is the second event this year — after Chinese owned Opera’s venture spending in Nigeria — to reflect greater Chinese influence and investment in the continent’s digital scene.

So in coming years, China could be less known for building roads and bridges in Africa and more for selling smartphones and providing VC for African startups.


Read Full Article

Art that explores time and memory | Sarah Sze

Art that explores time and memory | Sarah Sze

Artist Sarah Sze takes us on a kaleidoscopic journey through her work: immersive installations as tall as buildings, splashed across walls, orbiting through galleries -- blurring the lines between time, memory and space. Explore how we give meaning to objects in this beautiful tour of Sze's experiential, multimedia art.

Click the above link to download the TED talk.

Spotify now lets you add podcasts to playlists


Spotify this morning announced a new feature that will allow users to add their podcasts to playlists. With the addition, users can create their own custom playlists of their favorite podcasts, or even those that combine music and audio — similar to Spotify’s own newly-launched “Your Daily Drive.”

With “Your Daily Drive,” Spotify put its personalization engine to work to combine both music and news from select sources. But with the ability to now build your own podcast-filled playlists, you won’t have to rely on Spotify’s curation as much.

Instead, you can build your own podcast playlists by tapping the three-dot menu to the right of the podcast episode and then “Add to playlist.” You can either choose to add it a playlist you’ve already created, or you can build a new one from scratch. You can continue to add more content to this playlist, including music, if you prefer.

The company says this functionality is something users have regularly requested since the integration of podcasts to its streaming music service. However, it’s not necessarily the easiest way to tune into the latest episodes of your favorite programs as it involves manual curation.

Many podcasts release new episodes every week or so — and don’t want to get stuck constantly building playlists for those. Instead, the feature makes more sense for curating a set of podcasts around a theme, or preparing yourself to binge your way through a few programs on a long commute or road trip, for example.

Spotify says today there are over 3 billion user-generated music playlists on its service, so it believes that its users will embrace this new curation ability, as well.

Once a podcast playlist has been created, it can be shared with friends or the public, just like music playlists can be. This could make for an interesting marketing tool for podcasters, who could put together playlists of their best episodes or those with high-profile guest stars, for example, as a way to introduce newcomers to their shows. But it could also serve as a way for friends to recommend their favorite shows to others, by putting together a list of their all-time favorite episodes.

For those interested in tracking news and entertainment, they could build playlists of podcast episodes from different sources all focused on the same topic. For instance, a playlist offering everyone’s reviews of the new iPhone.

Over the past year or so, Spotify has heavily invested in the podcast market, including through acquisitions like GimletParcast, and Anchor — as well as in its programming, like the deal with Barack and Michelle Obama’s production company, Higher Ground, for instance, and a quickly-growing number of exclusives, windowed-exclusives, and originals. It also hired former Condé Nast president of entertainment Dawn Ostroff to lead its content efforts.

Today, Spotify says it has “hundreds of thousands” of podcasts available to stream on its platform.

The new podcast playlist-building feature is mobile-only for now. On desktop, you can only stream the playlists you made, but can’t build them yet, Spotify says.


Read Full Article

Kickstarter darling EcoFlow Delta battery generator is not what it seems


The Delta EcoFlow is a new battery generator available on Kickstarter with incredible claimed features. Most are true, some are not.

Device like the Delta offer incredible battery storage capacity. Designed for more than just recharging phones and tablets, these can run refrigerators, pumps, power tools and medical equipment. They’re great for emergencies, camping and general use where power is not available. Similar devices have been on the market for some years so I was eager to verify EcoFlow’s claims.

The EcoFlow Delta can recharge from a wall outlet to 80% in an hour. It’s amazing. The GoalZero Yeti battery of a similar size takes 25 hours. This capability means the Delta can be used and then reused more than competitors.

The device is currently on Kickstarter where it quickly acquired over $2 million from over 2,000 backers. The device’s features listed on the Kickstarter page are clear, but after testing a pre-production unit, I found several of these advertised capabilities and features misleading or false.

The Delta is the latest product from EcoFlow. The company’s founder, Eli Harris, says it’s “The world’s strongest battery generator.” I found the Delta to be a competent battery generator with similar capabilities to competitors but it’s hampered by loud fans.

In short, if you need a battery generator that can recharge much faster than others, the Delta is a great option. Otherwise, the GoalZero Yeti makes more sense for most people.

Battery generators are a safe and more portable option than their gas counterparts. There are no harmful fumes or fuel allowing them to be used indoors, nearer the appliances or tools. Most often (though not with the Delta) they’re silent, too, making them perfect for a camping or hunting companion.

In real-world operation, this quick recharge time could come in handy. Say, on a construction site or in an emergency incident where power is still available, but out of reach of an extension cord — situations where loud gas generators are generally used. While the Delta is louder than other battery generators, it is not as loud as a gas generator.

The Delta battery comes packaged with a warning that the battery must be fully charged before use. I generally ignore warnings, but I followed this one and immediately plugged it in. Instantly, fans whirled to life and the screen popped on displaying the current charge levels and how long it would take to get to 100%. The Delta was at 30% and would take 45 minutes to fully recharge. It worked as advertised and 45 minutes later the battery was at 100%.

Recharging the Delta battery was a noisy affair. The fans are loud and continue to run after the battery is fully charged. Compared to a GoalZero Yeti, this was a shock. The Yeti is silent where the Delta is not. I keep a Yeti 1400 in my basement, plugged in and ready to use. But with the Delta, even when the battery is fully charged, loud fans still run presumably to keep the unit cool. EcoFlow says the shelf life on the Delta is over a year where the GoalZero Yeti is six months. To me, I would rather have the battery constantly plugged into power so I know it’s ready to go when needed.

The Delta recharges without an AC power inverter (a power brick); it uses the same sort of cable as a desktop PC. The company says by passing through the inverter directly, the Delta can increase charging speed to more than 10 times the traditional AC to DC adapter cable. This also means it’s easier to replace a lost charging cable.

The Delta is much lighter than competing products and its design makes it easier to move. EcoFlow says it’s rugged, and it feels the part. Even my pre-production sample feels tough and ready to go to work. Large rubber pads keep the battery in place and the tough plastic feels more durable than competing products.

There are a handful of plugs and outlets around the device, including USB, USB-C and six AC outlets. It’s a lot and similar in capacity to large gas generators. Most battery generators have much fewer AC outlets, though I’ve often supplemented the capability with small power strips.

IMG 0544
Kickstarter Beware

The Delta is currently on Kickstarter for pre-order and exceeded its goal. I fear a good amount of backers will be upset to learn several notable advertised features are false or misleading.

The Delta is not silent. Under operation, either recharging a cell phone or running a power tool, loud fans run on both sides of the battery. These fans run when recharging the battery, too — even when the battery is fully charged. The Kickstarter page and video lists throughout that the Delta produces no noise.

ecoflow delta

These fans detract from the appeal of the Delta battery. They’re loud. You have to raise your voice to speak over them. Because of these fans, I wouldn’t take the Delta camping or use it in the backyard for a quiet get-together. During power outage situations, I wouldn’t want to sleep near it. But I would use it for power tools — like EcoFlow does in one of its demo videos.

Only one of the four videos on the Kickstarter page allows potential owners to hear the Delta battery. The third video on the page shows the battery powering a hammer drill. Six seconds into the video, the drill stops running, and the battery’s fans are audible.

There are a handful of competing batteries that operate without noisy fans. I’ve taken GoalZero’s Yeti batteries camping and they’re great despite their heft. They’re truly silent and can still recharge from solar panels and car batteries. I’ve used battery generators from Jackery, too, and those are also silent.

I spoke with Ecoflow CEO and Founder Eli Harris during the run-up of this review. He was clear that Ecoflow’s main competitor is not other large batteries, but rather small gas generators available from Honda and others. And that makes a lot of sense. Those are the best selling generators available and widely used for emergency and convenience. These small generators are loud, and the Ecoflow Delta is quieter than those options while still offering most of the power capabilities.

When asked why the Kickstarter page is misleading, he said “that fallacy has never been called out” and he would check with his team about the use of “superlatives and blanket statements.” Three days later, the Kickstarter page still lists the false claims.

EcoFlow claims the Delta battery can run a variety of power tools, including drills, circular saws, power washers and welders. I found this capability hit or miss. Despite some tools being under the claimed amperage and wattage of the Delta battery, the battery wouldn’t power my small or large circular saw or power washer. EcoFlow also claims the battery can recharge a Tesla; it doesn’t recharge my Chevy Volt.

Many tools require extra power when starting up, and I found most of these surge requirements to exceed the capabilities of the Delta battery. This is the same with other batteries like the GoalZero Yeti. In fact, I couldn’t find one tool in my workshop that the Delta powered and the Yeti did not; they worked the same for me, and I have a lot of tools.

Don’t mistake what I’m saying. The EcoFlow Delta has impressive capabilities mainly around its recharge capabilities. This makes it an attractive option for the right use. It’s compact and solid. It has a lot of outlets and is easy to move. This could be a lifesaver in emergency situations where a person still has access to power.

The Delta has some downsides just like other battery generators. It doesn’t offer a dramatic increase in electrical output over competitors so don’t expect this battery to power larger devices. Don’t expect a silent operation, either. This massive battery is loud though, I admit, that’s a relative term. It’s louder than other battery generators but less loud than a gas generator.

I would rather have a silent battery generator that recharges slowly versus a noisy, fast-recharging battery. I use my battery generators camping and around the house when the power goes out. The Delta makes sense on a construction site or on the scene of a natural disaster. I just can’t get over the loud fans.


Read Full Article

29 September 2019

Why is Dropbox reinventing itself?


According to Dropbox CEO Drew Houston, 80% of the product’s users rely on it, at least partially, for work.

It makes sense, then, that the company is refocusing to try and cement its spot in the workplace; to shed its image as “just” a file storage company (in a time when just about every big company has its own cloud storage offering) and evolve into something more immutably core to daily operations.

Earlier this week, Dropbox announced that the “new Dropbox” would be rolling out to all users. It takes the simple, shared folders that Dropbox is known for and turns them into what the company calls “Spaces” — little mini collaboration hubs for your team, complete with comment streams, AI for highlighting files you might need mid-meeting, and integrations into things like Slack, Trello and G Suite. With an overhauled interface that brings much of Dropbox’s functionality out of the OS and into its own dedicated app, it’s by far the biggest user-facing change the product has seen since launching 12 years ago.

Shortly after the announcement, I sat down with Dropbox VP of Product Adam Nash and CTO Quentin Clark. We chatted about why the company is changing things up, why they’re building this on top of the existing Dropbox product, and the things they know they just can’t change.

You can find these interviews below, edited for brevity and clarity.

Greg Kumparak: Can you explain the new focus a bit?

Adam Nash: Sure! I think you know this already, but I run products and growth, so I’m gonna have a bit of a product bias to this whole thing. But Dropbox… one of its differentiating characteristics is really that when we built this utility, this “magic folder”, it kind of went everywhere.


Read Full Article

WeWork proves that (venture) capitalism works


What’s the lesson of WeWork?

Here’s a startup that has been a darling of Silicon Valley investors for years, whose offices and CEO have been stunningly painted across the covers of major trade magazines and strategically deployed across major tech conference stages, including our very own. At its peak, the company commanded a valuation of tens of billions of dollars and was supposed to be on course for the stratosphere, joining companies like Google and Facebook.

And then it all came crashing down, in literally a handful of days.

It’s easy to point to WeWork’s potentially 75%+ valuation drop, its looming layoffs, the firing of its CEO, and the seeming compression of a whole heck of a lot of investors and employee equity as a sordid disaster tale of capitalism, and venture capitalism in particular. VCs — none more so than Masayoshi Son at SoftBank — constantly overbought, oversold, and overcommitted to a company that had pretty much no business fundamentals whatsoever.

So what’s the lesson of WeWork for venture capital? In a word, nothing.

Venture capitalism is about investing in bold bets with huge, outsized returns. It’s meant to be risk-adjusted, both at the valuation scale but also at a portfolio scale. VCs should be buying equity at the right price to take into account every individual startup’s risk profile while also constructing a portfolio that selects each of those risks for the best overall return.

For WeWork, much of those dollars were driven by SoftBank’s Vision Fund, which seemed to double down again and again on the company, even at loggerheads with its own limited partners. The Vision Fund made a bet, seemingly with reasonable access to internal information, and that bet turned out to be wrong.

But a bet it was.

Many bets in venture turn out to be duds. Sometimes you lose some of your money. Sometimes you lose all of it.

And then sometimes you make it in spades. SoftBank’s Son once invested $20 million into a fledging Chinese ecommerce company called Alibaba. That stake is worth around $100 billion today, excluding an $11 billion stock sale a few years ago that was recognized on SoftBank’s financials earlier this year.

This is the math that Son sees in venture: 111,000,000,000 / 20,000,000 = 5,550x. There is no other asset class on the planet that will turn a dollar into thousands of dollars like venture capital.

WeWork’s woes don’t change this base formula. Nor does the continual drop of Wag, which received $300 million from the Vision Fund and looks to be going through tough challenges.

In any portfolio, there are going to be losses. The infamous J-curve in venture, where losses materialize far faster than gains in the early years of a fund, is alive and well — even at the growth stage.

And WeWork isn’t even dead yet — it still has cash, and it will rebuild. Will it be the largest startup turnaround in history? Possibly. Could it go straight to bankruptcy? Sure. Will the Vision Fund make money? Well, it really depends on that preference stack and a thousand other variables to be determined in the coming weeks, months, and years.

It’s all so early. My guess is that we still have about five years to go before we really start to get sufficient information to evaluate the Vision Fund’s ambitions.

Along this line thoughI don’t think I just need to defend venture capitalism though, but capitalism itself.

Matt Stoller, who has made it his mission to target big companies including Big Tech, summarizes the WeWork situation as emblematic of “counterfeit capitalism,” a system of founding story myths and fake growth charts underwritten by venture capitalists trying to build long-term, sustainable monopolistic companies using predatory pricing to kill off competitors.

Yet, that narrative totally misses the point of what capital does, and what investment means. Very, very few companies (venture-backed or not) are profitable from day one. Opening a restaurant requires buying equipment and signing a lease well before any customer walks in through the front door. Ditto for software startups, which need to actually build software before a user will pay for it. Capital investment is the bridge between plans to execution and launch.

The question is how long should a company be unprofitable to goad sales and drive revenues? A decade or two ago, it used to be that companies needed to be profitable to IPO. But why? Why precisely then should a company slow down its investment and clean up its cash flows? Why not earlier? Why not later?

In fact, something great has happened in the last few years in the credit markets: at least some investors are increasingly positioning their portfolios for growth rather than cash flows. They are willing to wait for profits, sometimes for years.

Or, in other words, more and more investors are thinking long-term about the ultimate potential worth of a business.

WeWork could be profitable today. It could shutter its most recently opened locations, condense down to a handful of locations in major cities, and roll around in its positive cash flow. Of course the Vision Fund understands this. But why lock in small gains today when there is so much more potential lurking out there?

We should be cheering this behavior, and not castigating it, even if WeWork itself might turn out to be a dud. The lesson of this whole saga isn’t that capitalism isn’t performing. In fact, it’s precisely the opposite: (venture) capitalism is performing better than ever to invest in future, long-range growth.


Read Full Article

28 September 2019

This Week in Apps: AltStore, acquisitions and Google Play Pass


The app industry shows no signs of slowing down, with 194 billion downloads in 2018 and over $100 billion in consumer spending. People spend 90% of their mobile time in apps and more time using their mobile devices than watching TV. In other words, apps aren’t just a way to spend idle hours — they’re a big business. And one that often seems to change overnight. In this new Extra Crunch series, we’ll help you keep up with the latest news from the world of apps — including everything from the OS’s to the apps that run upon them, as well as the money that flows through it all.

This week, alternatives to the traditional app store is a big theme. Not only has a new, jailbreak-free iOS marketplace called AltStore just popped up, we’ve also got both Apple and Google ramping up their own subscription-based collections of premium apps and games.

Meanwhile, the way brands and publishers want to track their apps’ success is changing, too. And App Annie — the company that was the first to start selling pickaxes for the App Store gold rush — is responding with an acquisition that will help app publishers better understand the return on investment for their app businesses.

Headlines

AltStore is an alternative App Store that doesn’t need a jailbreak

An interesting alternative app marketplace has appeared on the scene, allowing a way for developers to distribute iOS apps outside the official App Store, reports Engadget — without jailbreaking, which can be difficult and has various security implications. Instead, the new store works by tricking your device into thinking you’re a developer sideloading apps. And it uses a companion app on your Mac or PC to re-sign the apps every 7 days via iTunes WiFi syncing protocol. Already, it’s offering a Nintendo emulator and other games, says The Verge. And Apple is probably already working on a way to shut this down. For now, it’s live at Altstore.io.

For the third time in a month, Google mass-deleted Android apps from a big Chinese developer.

Does Google Play have a malicious app problem? That appears to be the case as Google has booted some 46 apps from major Chinese mobile developer iHandy out of its app store, BuzzFeed reported. And it isn’t saying why. The move follows Google’s ban of two other major Chinese app developers, DO Global and CooTek, who had 1 billion total downloads.

Google Firebase gets new tools


Read Full Article

5 YouTube Cheats to Break Restrictions and Make YouTube Fun Again


youtube-cheats

It’s time to beat YouTube at its own game. Some third-party developers have the perfect combination of cheats and tricks to make for a better YouTube than the official experience. No more restrictions, and no more time wastage!

For a long time now, developers have been making sites and extensions to tweak YouTube so that you can fix some of its common annoyances. Some others focus on making YouTube more fun and light-hearted like it once was years ago.

Here are a few apps that use smart ideas for that better YouTube experience.

Use captions to quickly browse through a video, intelligently take out sponsored segments, and even check out the best videos from a decade ago.

1. YTCutter (Web): Download a Specific Portion as Video, GIF, or Audio

Clip a portion of a youtube video and download it as a video, GIF, or audio file

YTCutter is a single tool with multiple purposes. It recognizes that you don’t always want to download a full YouTube video, and only need a small clip. So you can select the portion and download just that.

The web app stands out for how user-friendly and smooth it is. Copy-paste a YouTube URL and it will immediately start playing. Click Start when you want the clip to begin, and End to finish trimming. You can adjust the timestamps if you want. You’ll see how many seconds the clip is, and a handy Preview button lets you check it before you download.

The trimmed clip can be downloaded as a video file (MP4), a GIF file, or an audio file (MP3). The MP4 file will download at the resolution you watch the video at, so select high-def beforehand if that’s what you want.

All in all, YTCutter is among the smoothest and slickest third-party YouTube apps we have seen. We hope it sticks around for a long time, but YouTube is notorious for striking down such tools, so enjoy it while it lasts.

2. YouTube Caption (Web): Get Full Text of Closed Captions

YouTube Caption extracts closed captions from YouTube videos

Several YouTube videos have closed captions, whether made by the uploader or auto-generated by YouTube. YouTube Caption extracts these as readable text, complete with built-in timestamps.

It only works with videos that have captions. Copy-paste the video link into the box and press the search icon. After a few seconds, you’ll get the video’s preview with full captions listed below.

It’s a brilliant way to scrub through a long video, such as a TED Talk or a presentation. Not only that, if you are learning something through a YouTube lecture, this tool gives you the full text of whatever the teacher said. It’s the easiest way to make notes.

While you’re reading, if at any point it seems like the video was aiding the text, click that line to jump directly to that point in the video. If you are a fast reader, you can get through a video much quicker by using YouTube Caption instead of sitting through the whole clip.

3. YouTube Rabbit Hole (Chrome): Disable Distractions for a Productive YouTube

Disable YouTube distractions with YouTube Rabbit Hole

Someone sends you a link to a YouTube video. You click and watch it. And the automated suggestion for the next video starts. The sidebar recommends similar things you might enjoy. A commenter says something nasty and riles you up. YouTube is designed to be a time sink. This extension wants to put an end to that.

YouTube Rabbit Hole attacks several distractions on the video streaming site. It blanks out suggested content, hides comments and livestream chats, and disables the “You might also like” suggestion wall at the end of a video. Instead, all you see are cute bunnies.

The extension also ensures you can visit the homepage without distractions. The trending and subscription pages are gone. It simplifies the navigation drawer so you only end up watching what you want to watch. And it also removes banner-style ads.

In the end, it’s just you, the video, and the search box. You can check channels that you are subscribed to, but forget about anything else. It’s time to trim the fat off YouTube.

Download: YouTube Rabbit Hole for Chrome (Free)

4. SponsorBlock (Chrome, Firefox): Skip Sponsored Segments Automatically

There are YouTube ad-blockers to try and skip the annoying wait periods in videos, or you could use YouTube Premium. But that still doesn’t let you skip the parts of videos where the maker sneaks in an ad from the sponsor. Until now…

SponsorBlock is a crowd-sourced extension that automatically skips those “this video is sponsored by…” parts. Try it out, it’s shocking how well this works on popular channels.

Most of these sponsorships are part of bundles for a large set of channels, so once the basic idea is reported a few times, it works across other videos too. It’s as useful as the “Skip Intro” feature of Netflix and Amazon Prime.

The developer notes that the add-on is completely open source. It uses a combination of algorithms and an upvote/downvote system. As a user, you don’t need to worry about that though.

When you’re watching a video, you’ll get an alert if the extension skips a sponsorship. You can choose to “unskip” it and watch the ad, report it, or do nothing to register the skip as an upvote. If you come across a sponsored segment that wasn’t skipped, tap the extension icon and mark it to help other users.

Download: SponsorBlock for Chrome | Firefox (Free)

5. YouTube Decade (Web): Biggest Video of the Day, 10 Years Ago

YouTube Decade shows you the best videos of the day from 10 years ago

Here’s a fun little experiment that is a much cooler way to browse YouTube than the default overloaded homepage. Developer Bennett Feely created a website that showcases the most popular videos among those uploaded ten years ago on this very day.

Every day, YouTube Decade updates with eight new videos. Categories include music, comedy, film and animation, entertainment, news and politics, sports, pets and animals, and gaming.

That’s it, eight videos, no information overload! If you’re checking on September 27, 2019, then the videos will be chosen from those uploaded on September 27, 2009.

You can browse through the site by going back one day at a time. It’s groovy because there will be times when the videos are from regional YouTube picks, so you might not even know the language. But given their popularity, they’re usually worth a watch.

YouTube Decade might be a fun homepage to set for your browser, giving you a little time capsule when you start your day.

Make YouTube Awesome!

The best part about YouTube isn’t the number of videos it has. It’s the number of third-party developers who make tools and apps to make it even better. From creating a mixtape to identifying any song in a video, check out this massive list of amazing tools to make YouTube better.

Read the full article: 5 YouTube Cheats to Break Restrictions and Make YouTube Fun Again


Read Full Article

As vape lung death toll mounts, CDC investigators warn against ‘informal’ THC sources


At least a dozen people have died of an acute lung condition related to vaping, and while officials aren’t ready to pin it on any one chemical or brand, they are warning that many of the patients reported buying THC cartridges from “informal sources” — which is to say off the street or online.

“The vast majority of patients received their products on the streets from friends or dealers,” said Dr. Jennifer Layden, chief epidemiologist for the Illinois Department of Health, in a press call today.

Unfortunately this also resulted in a huge variety of brand names and types of cartridges and devices. “Among all 86 patients in our study, 234 unique e-cigarette or vaping products across 87 different brands were reported,” Layden said. THC products were reported by more than three quarters of those surveyed, with only 16 percent of patients saying they used only nicotine cartridges.

The most common brand name, which two thirds of the patients surveyed reported using, was “Dank Vapes.” While testing of products with this brand name has not yet been carried out, it’s probably safest to avoid them for now. Studies have shown that even popular brands like Juul don’t know exactly what chemicals are produced when these substances are vaporized. And an NBC News-commissioned study showed that many off-brand cartridges contained pesticides that could form hydrogen cyanide when heated.

“We do not know yet what exactly is making people sick,” emphasized Dr. Anne Schuchat, principal deputy director of the CDC. “For example, whether solvents or adulterants are leading to lung injury or whether cases stem from a single supplier or multiple ones. Because of the variety of chemicals that are present in e-cigarettes or vaping liquids and may be added to e-cigarettes or vaping liquid as well as the diversity of products in circulation, laboratory analysis may be complex, but these are ongoing.”

The CDC, FDA, and individual states and cities have taken a variety of actions, banning vaping outright, restricting sales, and so on. But in many places these sales were already illegal, or were conducted online in such a way that it is difficult to detect. And of course a great deal of the consumption of these products takes place at home or otherwise in private.

The worry, of course, is that by banning the use of vaping products, there is a risk of pushing smokers using them to quit back to cigarettes, which are obviously known to be extremely harmful. It’s certainly not ideal, but if certain vaping materials are causing immediate and serious harm to people, they shouldn’t be used at all, let alone as a smoking cessation product. In the meantime proven (though perhaps less convenient) methods of quitting like nicotine gum and patches are still available.

The various medical authorities looking into this outbreak, which now affects more than 800 people, are being very cautious in identifying the cause, but are updating press regularly with new figures and any relevant information as the investigation proceeds.


Read Full Article

How to Convert Delimited Text Files to Excel Spreadsheets


import-spreadsheets-excel

There will come a time when you must deal with all sorts of information stored in other kinds of files and bring it into Microsoft Excel. You cannot run away from an ever-present text file. I bet you find some of them every day.

Unlock the "Essential Excel Formulas" cheat sheet now!

This will sign you up to our newsletter

Enter your Email

Here are a few everyday examples:

  • An Excel analysis of sales or product information stored in a text file.
  • Exchange of data between two different software (maybe, from a database to a spreadsheet).
  • Names, addresses, and email ID stored in an email program (e.g. export from Microsoft Outlook to Excel).

Microsoft Excel gives you all the tools to connect to external sources of data. Let’s talk about delimited text files.

This Is a Delimited Text File

A Delimited Text File

As you can see, the first and last names, the companies they work for and other details are separated by commas. This comma delimited text file is easy to create in any text editor.

Right now, it isn’t useful. Bring this into a spreadsheet and you can make a more professional document.

For instance, you can easily look for duplicate data and remove them. Then, you can use the spreadsheet to create labels and mail merge if addresses are also part of the data.

The basic idea here is to import the information from a text file and split up your various pieces of information into separate columns and name each column with an appropriate header.

Let’s look at a delimited text file in more detail…

The 3 Different Kinds of Delimited Text Files

There are three common kinds of delimited files depending on the way you separate (delimit) each value. Any character can be used to separate the individual entries in a file.

For instance: the pipe (|) or a simple space. You will find these three to be the most common kinds of delimited separators between each text entry.

  1. Comma separated values.
  2. Tab separated values.
  3. Colon separated values.

The Text Delimiter keeps each value separate from the next. Any value that follows the delimiter and precedes the next occurrence of the delimiter is imported as one value. Do remember that the value between the assigned delimiter can have another delimiter character, but it needs a quotation mark (“) or an apostrophe (‘).

Confusing? Not so much. Let’s see how with an example:

In a text file with city and state names, there may be some values like “Albany, NY”.

Microsoft Excel can read the comma (,) in between the two words as a delimiter. To treat the city and country names as one value and import them into one Excel cell we have to use double quotes or an apostrophe as a text qualifier. If no character is specified as the text qualifier, “Albany, NY” is imported into two adjacent cells as Albany and NY.

In brief, to retain any value in a column exactly as it is, you can enclose the value in quotation marks or an apostrophe.

As we will see below, Microsoft Excel gives you complete control over the import process and a Preview pane to see the format of the data before it fills the cells.

Convert From a Delimited Text File to a Spreadsheet

There are many online converters that can take a raw CSV text file and spit out an XLS spreadsheet. Zamzar and Convertio are two excellent tools.

But you don’t need to hunt for an online converter because Microsoft Excel has a native feature that does the job much better.

Let’s take a sample CSV file and walk through the steps to convert delimited text files to spreadsheets. The screenshot above of a jumble of comma-separated values in a Notepad file is a good example.

Microsoft Excel can help turn this confused jumble into neat rows and columns. You can then go to work on it and turn it into a beautifully formatted report or prepare it for printing.

Imported Text

There are three ways to bring data into an Excel spreadsheet from a CSV file. Start with the easy one first.

Method 1: The Automatic Import

1. Click the File tab, then click Open.

2. Select the CSV file you want to open. Microsoft Excel opens the text file automatically and displays the data in a new workbook.

CSV File Opened in Excel

This is the most direct (and quickest) route to open a CSV file. Microsoft Excel uses the default data format settings to read and import each column of data. But the automatic import does not give you the flexibility you want.

So, let’s see the second way which uses a wizard.

Method 2: Restore the Text Import Wizard

The Text Import Wizard enables you to control the structure of the data you want to import. It starts automatically when you import text files (i.e. a file with a TXT extension).

Open Microsoft Excel and browse to a text file (or change the extension of the CSV file to TXT).

Microsoft hid the old Text Import Wizard in Excel 365 and 2016 (version 1704 onwards). But you can bring back the text import wizard from Excel’s Options.

1. Go to File > Options > Data.

2. Scroll down to the Show legacy data import wizards section.

Enable the Text Import Wizard in Microsoft Excel

3. For importing text or CSV-files, select From Text (Legacy). Click OK to close the Options.

4. Now, you can use the wizard from the Ribbon. Go to Data > Get Data > Legacy Wizards > From Text (Legacy). Browse to and open the CSV file you want to import.

The Text Legacy Wizard in Microsoft Excel

Use this three-step process to control the format of the data.

Step 1

This is what the Text Import Wizard looks like in the first step.

Choose Delimited File Type in the Microsoft Excel Text Import Wizard

Select Delimited — When items in the text file are separated by tabs, colons, semicolons, spaces, or other characters.

Select Fixed Width — When all the items are the same length and neatly structured in space separated columns.

Sometimes, the raw data might have a header row. For instance: ["first_name","last_name","company_name","address","city","county"].

Use Start import at row to select the row from where the import will begin.

The File Origin can be left at its default for most cases.

The Preview displays the values as they will appear when they are delimited into columns on the worksheet.

Click Next.

Step 2

Choose the Delimiters for your file (comma, in our case). For some other character, check Other and enter the character in the little field. The Data preview window gives you a glimpse of the columnar data.

Choose the delimiter in the Text Import Wizard Screen

Select the Treat consecutive delimiters as one checkbox if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters.

For example, this helps you handle files which may have an extra space before or after another delimiter. You can help identify space as another delimiter and tick this box.

Use the Text qualifier dropdown to select the character that encloses values in your text file. We talked earlier how a text qualifier can help you import some values into one cell instead of separate ones.

Use the Data preview window to check the appearance.

Click on Next.

Note: The wizard screen changes when importing fixed-width data.

The Data preview window can help you set column widths. Use the top bar on the window to set a column break represented by a vertical line. Drag a column break to increase or decrease the width. Double-click a column break to remove it.

Import Fixed Width Data in Microsoft Excel

In a fixed-width file, no delimiters are used to separate the values in the file. Data is organized in rows and columns, with one entry per row. Each column has a fixed width, specified in characters, which determines the maximum amount of data it can hold.

Step 3

The Preview windows become more important in this screen because you can fine-tune the format of data that goes into each field with the Column data format. By default, Microsoft Excel imports data in the General format. Select the column in the preview window and set the appropriate format.

Column data format in Excel's Text Import Wizard

For example, you can select…

  • Text for the text fields.
  • Date and the date format for any column that contains dates.
  • General for converting currencies to the Excel Currency format.

Use the Advanced button to specify the type of decimal and the thousand place separators for numeric data.

For instance, if you want to display 100,000 as 1,00,000. Excel displays the numbers as per the format set in your computer’s regional settings.

Click Finish. A final Import Data dialog box pops up.

The Import Data Dialog the Text Import Wizard

Don’t worry about it too much now. It gives you a few options to insert the data in the spreadsheet or create a connection with an external database. Inserting the text-delimited values as a table in the present worksheet is the default setting.

The “old” legacy method is still the best way to go about it when your CSV file is simple. If not, there is a new method now which can fit the bill for any text import needs.

Method 3: Use Get & Transform Data

The Data tab includes all the tools you will need to gather external data and make it behave the way you want it too. For instance, you can create a PivotTable report and refresh it whenever the external data changes.

It is an overkill for simple CSV files, but let’s go ahead and see how to bring in columns of delimited data into Excel.

1. Open a blank workbook.

2. Go to the Data tab on the Ribbon. Then click the tiny dropdown arrow under the Get Data button (in the Get & Transform Data group). Choose From File > From Text/CSV.

Launch the Text Data Wizard manually

3. In the Import Text File dialog box, browse to the location on your desktop and select the CSV text file you want to import. The Text Import Wizard is neatly displayed with the options you can now select.

New Text Import Wizard in Excel

As you can see, you can change the character encoding and the choice of the delimited character or enter a custom delimiter.

Excel figures out the delimiter by analyzing the first few hundred rows of the dataset by default. You can change this and let Excel work with the entire dataset too. It’s not recommended if you have millions of records to import.

4. Click the Load button to import your data into a new pretty worksheet.

5. Whenever you import data into Excel, a data connection is created. You can run queries and connect the worksheet to the external source. Any change to the original source data will be automatically updated in the Excel sheet.

6. You can cancel this connection by going to Data > Queries and Connections to open the panel on the side.

Right-click and choose Delete. Or, hover over the file name of the data source and hit Delete in the window that comes up. If you are sure, click on Delete again.

Queries in Excel

Transforming the data is beyond the scope of this tutorial. So I will direct you to Microsoft’s Getting Started with Get & Transform in Excel support page for more help.

The Many Uses of Delimited Files in Excel

Need to separate a list of first and last names and prepare them for printing? Convert the delimited text file to Excel. You can import or export up to 1,048,576 rows and 16,384 columns. And delimited files are supported almost everywhere. Use Excel as a timesaver with the above techniques and the tips below.

Read the full article: How to Convert Delimited Text Files to Excel Spreadsheets


Read Full Article