How to Turn Your Picture File into an Excel Spreadsheet Using Your iPhone
As you know, Badger only accepts an Excel or CSV file for data import. But what if the data you have is only a picture or a print out of an Excel table? You can definitely enter the information manually, but it’ll be time consuming if there’s a lot of info to be entered. Luckily, you can use the Microsoft Office app on your iPhone to convert the photo or the print out into an Excel spreadsheet. Continue reading to find out how.
1. Download the Microsoft Office app from the App Store, and sign up for an account if you don’t have one yet.
2. Once you’re in, go to Actions, then look for Convert text in images, and select Image To Table.
3. Take a photo of the print out. Or, tap the photo icon at the lower left of the screen to open up your Media, and choose the file that you want to convert.
Note: This app is a little fussy so there’s a possibility of a few retakes to get the perfect photo for file conversion.
4. Crop the photo if needed, then select Confirm to start extracting the data as an Excel file.
5. Then tap Open, and choose Review to review the info.
6. Edit the info as needed and tap Done, or Ignore if nothing has to be changed.
Note: Text to Column function isn’t available on Excel’s mobile app.
7. After reviewing, the picture will be converted into an Excel file. Tap the three-dot icon at the top right of the screen.
8. If you want us to import the file for you, tap Send a Copy, forward it to firstname.lastname@example.org, and tap the arrow up icon to send. Make sure it’s coming from your registered email address so we can easily locate your account. Click here if you’d like to find out how you can add your registered email account to your iPhone.
9. If you’re more of a DIY person, tap Save, then assign a name, and choose what folder you’d like to save the file. Tap Save on the top right corner of the screen when you’re done. We recommend saving it on your OneDrive folder so you can easily access it on your desktop when you’re ready to upload the file. Check our import guide if you need to find out how it’s done.