Tagged: computer and internet

Converting Photo with Data to MS Excel and Google Sheets 0

Microsoft Excel has recently introduced an exciting feature in its mobile apps — the ability to snap and recognize a picture of data tables drawn or printed on a piece of paper. The result? You can quickly convert a printed datasheet to a digital spreadsheet using just your smartphone. Sounds amazing, right?

Microsoft Excel’s apps for Android and iOS support this feature known as “Insert Data from Picture“. It allows you to snap a picture of the data present in rows and columns on a sheet of paper and convert it into editable table data.

Unfortunately, there is no such feature in Google Sheets. However, you can convert a photo of data into a spreadsheet using Microsoft Excel, and then import the created spreadsheet into Google Sheets to further work on it.

Read a photo of data in Excel or SheetsRead a photo of data in Excel or Sheets

How does it work? Well, the tool sends the picture to its online image-recognition engine to process the numbers and words captured from the sheet of paper. Finally, it offers you an option to fix possible errors or make changes before it’s imported in the sheet.

In the following I will explain this process step-by-step. Let’s take a look.

Insert the image with data into Excel

First of all, let’s learn to import data from a picture in Microsoft Excel using the Excel app for Android or iOS:

  1. In the app, tap New from the top bar to create a new workbook. You can create a blank workbook or create one from the given templates.
  2. Create a workbook in Excel or SheetsCreate a workbook in Excel or Sheets
  3. Click the Data from Picture icon (grid icon with a camera) from the bottom bar. Next, click Allow to provide your permission for uploading and converting the image to data using the app’s online service.
  4. Data from Picture tool in Microsoft ExcelData from Picture tool in Microsoft Excel
  5. Locate the data on paper inside the red figure and click the Capture button.Note: The app may not identify the data on paper in the first attempt, so you would need to try a few times to make a successful capture.
  6. If you’re satisfied with the captured image, click the check-mark button to upload and convert the data; else, tap the x button to retry.Note: At this step, you can also edit the captured image using the three buttons given in the top bar — crop, rotate, and filter.
  7. Capture and edit a photo in Excel for mobilesCapture and edit a photo in Excel for mobiles
  8. In the preview (if it’ll be required), you may need to review and correct a few items, which the online service couldn’t understand from the captured image. Let’s check out how to review and edit items if required:
  • Excel will highlight the cell (in the sheet) and the part of the image to point out the error. Click Edit to fill in the data yourself or click Ignore to avoid filling the data if the error is a false positive.
  • If you clicked Edit, enter the information and click Done.
  • If you wish to browse the items, click the < and > buttons.
Review data under Preview in Microsoft ExcelReview data under Preview in Microsoft Excel
  • If the shown preview has some missing data, click the cell missing data, and then click Edit to enter the information and Done to save it.
  • Edit a cell to add any missing data
  • Once you’re satisfied with the previewed data, click Insert in the top bar to insert the previewed data in your workbook. And voila, it’s done.
  • Insert the previewed data in the workbook

    I found the “Insert Data from Picture” feature interesting and useful — mostly at dire times. It’s a kind of upgraded feature of Optical Character Recognition (OCR) which extracts text from images and understands data tables as well.

    In my tests, this feature worked well at reading data from a sheet of paper or a computer screen, but it didn’t work perfectly (on average in my tests). So, please ensure you snap a clear picture to ensure a smooth import process. Also, it doesn’t work well at analyzing handwritten data, so prefer printed papers.

    Insert Image with data to Google Sheets

    As I’ve mention above, Google Sheets doesn’t offer a feature to read tabular data from a piece of paper or a captured image. However, we can read data from a piece of paper and save it in a spreadsheet using Microsoft Excel.

    Then finally, we can import the same spreadsheet from Excel to Google Sheets.

    If you’re unsure about importing spreadsheets from Excel into Google Sheets, check out this official guide from Google, which details every step.

    That is all about importing data tables from an image or a sheet of paper using Microsoft Excel. Of course, you can import it later in Google Sheets as well.

    The post Converting Photo with Data to MS Excel and Google Sheets appeared first on Hongkiat.


    Becoming a Video Game Expert You’ve Got The Skills So Why Not? 0

    Video Game Expert

    If you find yourself playing video game day-in and day-out, you might be a prime candidate for establishing yourself as a video game expert. All you need is a good knowledge of a wide range of video game and gaming systems, and of course, a lot of patience. The rewards are phenomenal and in the end, you’ll be a better person for it.

    So what is an expert anyway? Just what is it that qualifies anyone to be an expert on anything? Since there aren’t any colleges that offer degrees in this genre, we can qualify any gamer as an expert who has the qualities described above. So if you have the knowledge or ability to play a game skillfully – and you enjoy solving problems, you could probably claim the rights to an expert status.

    Just be sure that you ensure your own growth in the gaming industry. Part of being an expert is admitting that there’s always more to learn and in the gaming industry, this should never be a hard thing to pull off. By exposing yourself to new games and new game systems, you can turn every opportunity to play with one into an opportunity to learn more than what you already know. In doing so, you’ll learn tons of new strategies and widen your resourcefulness as a point of help to others.

    You could also make multiple efforts to collaborate with others involved with video games. Get off the game and get out into the public so that you can network and discuss your discoveries with others. Networking gives you the wonderful opportunities to share or swap secrets, teach others, and learn a little something new at the same time. And the relationships that you build as a result are simply invaluable. There’s probably no other way you could gain access to little-known gaming secrets than to network among the best gamers around.

    If you’re completely dedicated toward becoming a gaming expert, consider taking some classes in game programming. Seek out and apprenticeship and find training programs that are offered in both your local area and the gaming industry as a whole. This is an excellent way to learn everything anyone would ever want to know about gaming, and its a good entrance into the gaming industry if you aren’t too crazy about making a commitment to a full-time gaming career.

    You could also subscribe to gaming magazines, participate in online discussion boards, or sign up for book clubs that focus on gaming material.

    Take note that your status as a gaming expert may not always be appreciated. Strong criticisms – whether right or wrong – come with the glory of being perceived as the “answer to everything.” As an example, you may be rejected for an opportunity that you feel you’re perfect for, or you may experience the spew of a less-than-experienced heckler. The first rule of thumb is to not take rejection or spew personally. People may be jealous of your position, or they may want to test you just to see how much you really do (or don’t) know. The reasons behind these reactions to your assistance don’t really matter as long as you’re confident about the quality and value of your help. A true expert looks past these things and they constantly look for ways to improve themselves.