CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 12950

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.

Excel

tabulka->Excel

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.

Excel

Excel

Excel

inspired by PC Magazine

InventorFusion360ACADRevitCivil3DPlant3D
100% *  CAD 
21.7.2020    20078×  

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   



Featuring:
Increase your productivity with our set of BIM add-on functions for Autodesk Revit
CADstudio Revit Tools 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.
TOPlist