CAD tip # 12671:

Question

CAD
% platform category

Import Excel table by snapping a photo of it.

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

inspired by PC Magazine

InventorFusion360ACADRevitCivil3DPlant3D

* CAD

21.7.2020 3094×

Comments Tell a friend

Prices - CAD eShop:

Product Design Collection

AEC Collection

applies to: Inventor · Fusion 360 360 · AutoCAD · Revit · Civil 3D 3D · AutoCAD Plant 3D 3D ·

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?

Selected tip: Difference volume (3D solid) between two TIN surfaces (sets of coordinates)

Back All CAD Tips

ReLinkField - re-link fields to source objects. « | » How to free up space in the local cache of Desktop Connector?

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: 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.

CZ \| EN \| DE
Login or
registration
	Visitors: 4841

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, 3ds max and other Autodesk software (support by Arkance Systems)	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2023 \| Advertise with us \| Online privacy