CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 1672

CAD tip CAD tip # 12671:

Question CAD 
 %  platform  category 
Q - question

Import Excel table by snapping a photo of it.

A - answer Sometimes the daunting task of entering tabular data can have a surprising and simple solution.

Even in the field of CAD and BIM design, the preparation of tabular data is a frequent requirement - entering a dimensional table from technical standards book, adding current price information to BIM data, allowed values to the lookup table of parameters, data of CAM tools, etc.

If you have the required tabular data only on paper (e.g. in a technical book or magazine, in a printed price list), you do not have to retype them, just take a picture of them.

Launch the mobile version of MS Excel on your mobile phone or tablet (Android or iOS), log in to your Microsoft account, tap the screen button (left) in the bottom bar and select the Data from Picture icon in the expanded toolbar.



Take a picture of the table and crop it to the desired part. Confirm the recognized cells and table data and save the XLS file to a shared storage. Then just use the Excel spreadsheet on your desktop computer for the desired purpose.




inspired by PC Magazine

100% *  CAD 
21.7.2020    23516×  

See also:
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.
Tip 12926:How to import point coordinates from Excel to AutoCAD?
Tip 12815:How to fill iProperties into Inventor files from Excel?
Tip 12743:A change in iLogic processing of Excel tables since Inventor 2021.
Tip 12641:How to copy a graph from Excel to AutoCAD?

Back   All CAD Tips

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

Publish interactive 3D PDF models from AutoCAD, Inventor or Revit with Share3D More info

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.