07-03-2025
Insert Data from Picture into Excel
Did you know that you can Insert data from a picture in Excel? {Reminder: Never save PHI.} I learned this from a Mini Learning Short Entitled Excelling in Excel: Tips & Tricks presented by Ronda Broome, MS, MSHMI, ODS-C available on NCRA Informatics Mini Learning Shorts page. Be sure to take advantage of these learning shorts to learn all sorts of new tips and tricks! Worker Smarter not Harder! Let technology work for you!
- Run your report of cases, then take a Snip of it & save it to your computer and/ or Clipboard. (The image should only show the data you want to import.)
- Open Excel
- Click Data>From Picture>Picture From File
- Select the Picture from a file or from clipboard if it’s an option
- Then click Insert Data
*Always double check the data to make sure it converted appropriately, and no figures were converted incorrectly.
