How to

The CAD Block attribute data that is extracted to a table can be exported to an external file. On the Choose Output page, select the Output Data to an External File option. You can export the data to the following file formats:

  • Microsoft Excel (XLS)
  • Comma-Separated (CSV) 
  • Tab-Separated (TXT) 

What is XLS?

XLS is a former version of the file extension for a Microsoft Excel spreadsheet that uses a proprietary binary format. 

XLS

What is CSV?

A CSV file is a file format used for storing data in a tabular format. CSV stands for comma-separated values, which means that the values in the file are separated by commas.

CSV opened via text editor

A CSV file is a plain text file that can be opened with any text editor or even a spreadsheet software such as Excel.

Each line in a CSV file represents a row, and each comma-separated value represents a column. CSV files are widely used for data exchange between different software applications and databases.

What is the difference between CSV and XLS?

The difference between XLS and CSV is that an XLS file contains data in a workbook and spreadsheet, while a CSV file can only store the data in text format. It automatically removes all the formats and formulas. 

How to choose between CSV and XLS?

When it comes to choosing between CSV and XLS, there are a few things that you should consider.

One of the main advantages of CSV files is that they are simple. CSV files are just text files with values separated by commas. This means they can be opened and edited in any text editor.

XLS file is more complex and offer a wider range of features. XLS file can handle more complex data, including formulas, charts, and more.

When deciding between CSV and XLS, it’s important to consider the complexity of your data and the features that you need.

Reasons to Use a CSV File

  1. Portability: CSV files are lightweight and can be easily transferred between different platforms and applications, making them an ideal choice for sharing data.
  2. Compatibility: CSV files can be opened and edited by a wide range of programs, including Microsoft Excel, Google Sheets, and many others.
  3. Structured data: CSV files allow you to store data in a structured format, with each row representing a single record and each comma representing a field or attribute.
  4. Easy to read and edit: CSV files are easy to read and edit, even for non-technical users, since they are simply text files containing data separated by commas.
  5. Large data sets: CSV files are ideal for handling large data sets since they are efficient and fast to load and process.
  6. Automation: CSV files can be easily generated and processed using scripting languages like Python, making them a popular choice for automating data processing tasks.
  7. Standardization: CSV files are a widely accepted standard for exchanging data between different systems and applications, making them a reliable choice for data integration.

Reasons to Use a XSL File

  1. Data analysis and visualization: Excel offers a wide range of tools for analyzing and visualizing data, including formulas, charts, and pivot tables, making it ideal for data-driven decision-making.
  2. Organizing and managing data: Excel provides a flexible and customizable way to organize and manage data, including sorting, filtering, and searching, as well as the ability to create multiple sheets within a single workbook.
  3. Collaboration: Excel allows multiple users to work on the same file simultaneously, making it easy to collaborate on projects and share data with others.
  4. Automation: Excel can be used to automate repetitive tasks using either VBA or Office Scripts.
  5. Integration: Excel can be integrated with a wide range of other software applications, including databases, accounting software, and ERP systems.
  6. Accessibility: Excel is widely used and supported, making it easy to find resources and support for learning and using the software.

XLS is a versatile and widely used tool for managing and analyzing data.

If you only need to store a single tabular dataset and don’t need any advanced features, then CSV might be the better choice.

Otherwise, if you need to perform calculations, create charts, or work with multiple datasets, then XLS might be the better option.

How do you convert XLS to CSV? 

  1. Open the Excel workbook.
  2. Switch on the File tab and click on Save as.
  3. You can also press f12 to reach the Save as dialog.
  4. In the Save As type box, choose to save the XLS file as CSV (Comma delimited) option. 
  5. Other CSV options are also available. You can check them too. 
  6. Choose a folder to store your file. 
  7. Simply click OK and Yes to the dialog displaying on the screen. 

What are the differences between XLS and XLSX? 

XLS and XLSX are two file extensions that are used by the very popular spreadsheet application from Microsoft named Microsoft Excel. XLS is very popular as it has been the default format for Microsoft Excel since it was first created up till 2003. In the Microsoft Office 2007 release, Microsoft decided to change the default file format to a different format and adding and additional x for all their document extensions; for Excel, this ended up as XLSX.

  • Excel XLS vs. XLSX has a basic difference in their existence; XLS is the default version of Microsoft Excel 2003, and XLSX is the file format of Excel since 2007. 
  • XLS is readable by all Microsoft Excel versions, but XLSX is readable only by Microsoft Excel 2007 and onwards.  
  • XLS vs. XLSX file storage system says that XLS information is saved directly to a binary format, whereas the XLSX file is stored in a text file. 
  • XLS can save the file that contains macros. On the contrary, XLSX can not support macros. 
  • There is also a difference between XLS and XLSM. Where both are file formats only, XLSM contains macros that XLSX doesn’t.  
  • The difference between XLS and XLSX and CSV can be understood as XLS and XLSX being Excel file formats featuring tables, graphics, formulas, etc., whereas CSV can save the file in text format only. 
  • XLS files are larger than XLSX files. 
  • XLS is a proprietary binary format, whereas XLSX is based on Microsoft Office Open XML format. 
  • In the files that require the use of complex formulas with big sets of data, XLS works faster than XLSX. 
  • XLSX can hold data in large quantities, but XLS can store fewer data. 
  • XLSX has more rows and columns capacity than XLS

What is the difference between XLS and XLSX in terms of the row/column limit? 

XLSX file format’s capability to compress the data and reduce the size of a file makes a big difference between XLS and XLSX.

The row limit in XLS workbook is 65,536 (2¹⁶), and in XLSX, it increases up to 1,048,576 rows (2²⁰).

The column limit for XLS and XLSX is 256 columns (2⁸) and 16,384 columns (2¹⁴), respectively.  

Read more

Sometimes when you add radius dimension, you find that you can’t extend the dim line to the center, just like below left dim lines.

If you would like to enforce dim lines to extend to the circle center, the corresponding Dimension Style setting can be adjusted.

  1. Use the DIMSTYLE command to access the Dimension Style Manager.
  2. Select the corresponding Dimension Style and select Modify… .
  3. Switch to the Fit tab.
  4. Under Fine tuning, check the setting Draw dim line between ext lines.
  5. Confirm with OK and Close.

The dim line will now be displayed even for smaller dimension lines.

Read more

With Adobe Fonts you have access to thousands of fonts from hundreds of foundry partners—all included with your Creative Cloud subscription. Enjoy quick browsing, easy use in desktop applications or on the web, and endless typographic inspiration. This is the easiest way to bring great type into your creative workflow, wherever you are.

How to Add Adobe Fonts on Your Computer?

Install the Creative Cloud desktop application

Fonts are added on your computer through Creative Cloud desktop.

Choose fonts to add

Start by browsing the library of fonts. You can choose the language support you require from the LANGUAGES AND WRITING SYSTEMS drop-down menu.

When you find a font you like, click to view the family page. Select the font weights and styles you want to use, or use the menu at the top of the list to add full families.

Added fonts are shown in Creative Cloud desktop by clicking the f menu icon in the upper right corner.

Use the fonts in your desktop software programs

Once the fonts are added, they will appear in the font menu of each application, alongside all of your locally installed fonts. They will be immediately available in most programs, but a few need to be restarted to add new fonts to the menu (for example, Adobe Acrobat and Microsoft Office).

Using the fonts in third-party apps

Please note that Adobe Fonts that have not been used in several months need to be reinstalled for use in non-Adobe apps. Creative Cloud keeps apps running smoothly by periodically cleaning up fonts that you don’t appear to be using.

You can quickly reinstall fonts from the Creative Cloud desktop by clicking the Install button next to the font name in your Added Fonts list. Once the fonts are reinstalled, they will show up as usual in all your font menus.

We also recommend keeping Creative Cloud software up-to-date for the best font experience.

How to activate Adobe fonts on your computer

How to Add Adobe Fonts on Your Website?

Create a web project

When you find a font you like, click the </> button to add the family to a web project.

You can also click on the font name to open the family page and see all of the font weights and styles that are available to use. Then click </> Add to Web Project at the top of the page to add the family to a web project.

In the Add fonts to a Web Project window, you’ll name your web project and decide which fonts should be included.

  1. Click on the menu and choose “Create a new project”
  2. Name your web project
  3. Use the checkboxes to select the font weights and styles you want to include.
  4. Create the project.

Next, you’ll be given the embed code to load the fonts into your website. The different options are explained in the embed code help page, and the default embed code works well for most projects.

Copy the embed code and add it to the <head> tag in your website.

Click Done to close the web project window and continue browsing.  To add more fonts to your project, click the </> button on another font family, then choose your project name from the menu (instead of “Create a new project”).

How to Manage Adobe fonts?

In the Manage fonts drop-down list on Adobe Fonts, you can open the Fonts panel in the Creative Cloud desktop app or open the web project editor to manage your created web projects. You can also access any fonts you’ve favorited or purchased.

In the Creative Cloud desktop app, you can:

  • Manage your current font selections
  • View your font use history
  • Reinstall added fonts that are no longer in use

Font Licensing

Adobe Fonts offers thousands of fonts from over 150 type foundries as part of your Creative Cloud subscription.

All fonts are licensed for personal and commercial use; read about the font licensing in full in the Terms of Use.

Can I use the fonts to create a logo or other images?

Yes. You can use the fonts in any desktop program (such as Adobe Photoshop) to create images or vector artwork, which you can then use for any purpose. This includes generating a PDF, EPS file, or bitmapped file such as a JPEG or PNG.

Can I use the fonts to create products I will sell commercially, such as t-shirts, posters, books, magazines, or other printed merchandise?

Yes. You can use the fonts for any kind of merchandise, whether you’re designing a t-shirt for a friend or product packaging for a client. Other printed products, such as books or magazines, are permitted as well. There is no limitation on the number of impressions or items you may produce.

Can I install the fonts on my server?

No. The font licensing isn’t compatible with server installation. You will need to purchase the appropriate font license for any fonts that you want to install on your server from the font foundry directly or the foundry’s authorized reseller.

Read more

Students can get free one-year educational access to Autodesk products and services, renewable as long as you remain eligible.

If you’re a student, you can follow these steps to get free access to software through the Autodesk Education Plan on your personal computer.

A student wanting to install products that a teacher has assigned to you

If your teacher or colleague assigns an Autodesk product to you, you’ll receive an email from Autodesk telling you which products have been assigned and where to download them. Follow the steps below, depending on if you already have an Autodesk Account or not.

You can install the software on up to three devices. Assigned users have access to software until the educator who made the product assignment unassigns access or their eligibility for the Education plan lapses.

If you don’t have an account

If you don’t have an Autodesk Account, you’ll need to create one before you can download your products.

  1. In the Autodesk email you receive when you’re assigned a product, follow the instructions to create an Autodesk Account. Enter your first name, last name, email address, and password. The email field contains the email address where you received your product assignment. It is also your new Autodesk user ID.
  2. Check the box to agree to the Autodesk Terms of Use and Privacy Policy and click Create Account.
  3. Click Done in the confirmation message.
  4. Go to Products and Services in the navigation bar.
  5. Locate your product and click Download Now or View Downloads.
  6. Follow the on-screen instructions to download Windows or Mac software.
  7. After you download the .exe or .dmg file, follow the on-screen instructions to install.

Keep your Autodesk user ID and password in a safe place, such as a password management application. It’s required to access product downloads from your account and, in some cases, to sign in to Autodesk products.

If you have an account

If you have an Autodesk Account, sign in and download your products.

  1. In the Autodesk email you receive when you’re assigned to products, click the Sign In to Get Started button. You can also go directly to Autodesk Account and sign in.
    Note: If you’re prompted, set up 2-step verification or click Remind Me Later.
  2. Click Products and Services in the navigation bar.
  3. Locate your product and click Download Now or View Downloads.
  4. Follow the on-screen instructions to download Windows or Mac software.
  5. After you download the .exe or .dmg file, follow the on-screen instructions to install.

A student who hasn’t been assigned products and needs to obtain them yourself

If a product hasn’t been assigned to you, you can still obtain free Autodesk software on your own. As a student, you can create an account and confirm your eligibility for the Autodesk Education Plan. Follow these steps:

  1. Create an Autodesk account using your school-provided email by going to the Get Products page and clicking Get Started.
  2. Confirm your eligibility, which involves validating your role as a student with a qualified educational institution.
    Note: You may need to submit additional documentation before your eligibility is approved.
  3. Download and install your software from the Get Products page.
    Important: Even if your software is already installed on the device you’re using, you must click Download on the product card to trigger your product entitlement.
  4. Start your product, sign in to Autodesk account, and begin using your software.
    Note: Once you’re signed in on your browser, you may need to click Go to Product to return to your software.

A student ready to renew access to the Education Plan

To continue your access to Education software, you must renew your eligibility every year.  You can check your renewal date by going to the Get Products page. Sign in to view your personalized banner at the top of the page. Also be sure to check your email, as Autodesk will send an email reminder 30 days before your eligibility expires.

If you do not renew your access, your free access ends when your Education plan expires. If you have files stored in Drive, you can continue to access them, but you will not be able to edit them or upload new files.

Note: Documents stored in Autodesk cloud service remain available for 30 days after your Education plan access expires. Be sure to retrieve any files stored in Autodesk cloud service before the end of this period.

Renew access

  1. Make sure you are still eligible for educational access by reviewing who is eligible.
  2. On the Get Products page, sign in to your account.
  3. Click Renew Now in the personalized banner notification.
  4. Once you confirm your eligibility, your access is automatically extended for another year.

Once you’ve renewed access, there’s no need to download a new version of your installed software unless you want the latest version.

Restart a subscription

After you complete the following steps, a new subscription will be assigned to your account.

  1. Go to the Get Products page.
  2. Click Get Started and sign in.
  3. Scroll down to the card for your product.
  4. Click Get Product.
  5. Click Install/Download. A new one-year subscription is assigned to your account.

Note: Even if your product is already installed, you need to click Install/Download to generate a new subscription. (You can cancel the download if you don’t need it.)

Restart access

If your access has already expired and you are still eligible, you can restart your educational access.

  1. On the Get Products page, sign in to your account.
  2. Click Restart Access in the personalized banner notification.
  3. Once you confirm your eligibility, your access is automatically extended for another year.

Once you’ve restarted access, you will need to follow the steps to restart a subscription in order to continue using the products that were previously obtained.

See also:

What are Qualified Educational Institutions?

“Qualified Educational Institution” means an educational institution which has been accredited by an authorized governmental agency within its applicable local, state, provincial, federal, or national government and has the primary purpose of teaching its enrolled students. Examples of Qualified Educational Institutions include, without limitation, public or private:

  • Middle schools and high schools
  • Junior colleges
  • Colleges, universities and technical schools
  • Home school programs which belong to a nationally recognized home-schooling body or are expressly recognized by a local school governing body as an acceptable alternative to an accredited educational institution

Specifically excluded, without limitation, from the definition of Qualified Educational Institution are:

  • Non-accredited educational institutions
  • Training centers
  • Churches
  • Hospitals, healthcare systems & research laboratories
  • Libraries
  • Museums 

How to Confirm Eligibility for Students?

To access software and services under the Education plan, you must confirm your eligibility. As part of this process, you may be asked to provide documentation of enrollment or employment at a qualified educational institution.

Note: An email address from your educational institution is not sufficient or required to confirm eligibility.

  • If your school is not already listed as a qualified educational institution, it may take seven days or more to validate it.
  • If you have to upload documentation, it may take a couple of days to confirm your eligibility.

To confirm eligibility:

Visit the Get Products page on the Autodesk Education Community.

  1. Click Sign In. Enter your email address and password.
  2. Choose your school from the drop-down list. If your school is not on the list, click Can’t find your school? and complete the form. It may take seven days or more to be validated. For homeschooling, type Homeschool in the field and select Homeschool from the drop-down list.
  3. Double-check all information.
    Important: Make sure that your profile information is correct and that it matches the information held by your school because you can’t change it later. Be sure you’ve selected the right segment for your institution:
    • Secondary includes K-12 schools.
    • Postsecondary includes universities and colleges, as well as trade and vocational schools. If you select the wrong segment, you won’t be able to select your school from the list. If you’ve selected the wrong segment, contact Autodesk Education Support.
  4. Click Verify.

How to Submit Additional Documentation?

You may be asked to submit additional documentation for proof of eligibility. This documentation must include:

  • Full name (must match the name as shown in school registration)
  • Full name of the educational institution
  • A date within the current school term

Here are some examples of appropriate documentation, assuming they include the information above:

  • Official letter from the educational institution
  • Registration receipt
  • Tuition receipt
  • Student or employee ID (photo not required)
  • Transcript
  • Faculty listing on school website

You have up to 14 days to upload a suitable document. Once you have uploaded your documentation, it may take a couple of days for your eligibility to be confirmed by SheerID.

Read more

Often, downloaded drawings or drawings sent by others will be prompted with a version too high when opened in AutoCAD.

At this time, we need to convert the drawings to a lower version before we can continue to use them in the current version of CAD.

Tip 1: Installing AutoCAD 2018 can open all current versions of CAD drawings

Tip 2: Because converting a drawing to an earlier release format may cause some data loss, we recommend that you assign a different file name to avoid overwriting the current drawing file.

The following are several ways to convert drawings. (Without Latest AutoCAD)

DWGSee DWG Viewer

The latest version of DWGSee can open all versions dwg files, open the dwg file and then click “Save as” button, give the new drawing file a name and from the drop down menu of the “Save as type”, select DWG or DXF format and the CAD version. Choose where you want to keep the new drawing file and click “OK”.

If you just need open dwg file, you can just use DWGSee Free DWG Viewer, there’s no need convert the drawing again.

AutoDWG DWG DXF Converter

With AutoDWG DWG DXF Converter, you may change versions of DWG and DXF both from low to high and high to low between AutoCAD R12 and Auto CAD 2024, it supports batch conversion.

DWG TrueView

Download and install the latest version of DWG TrueView (a free Autodesk file viewing software) and use the DWG Convert feature to convert the drawing.

  1. Create a copy of the drawing file to be converted.
  2. Launch DWG TrueView.
  3. Click the application menu in the upper-left and choose DWG Convert (or pick it on the ribbon if a file is open).
  1. Add the file(s) in the Files Tree list (click the green plus Add Files button).
  2. Choose the appropriate file format version.
  3. Click Convert.

Note: AutoCAD itself has the DWGCONVERT command for batch-converting files to older formats.

Free Online Conversions

Many Online Conversion Websites offer the free service to convert cad files to lower version, see following.

Free online conversion services usually have limitations on the number and size of files.

How to Identify the Drawing Version Quickly?

If you don’t want to purchase and install the latest version, how can you identify the drawing version to select the CAD version?

Firstly, we select the drawing, right click, select Open With, and select Notepad to open it, after opening it, we can see a bunch of messy codes. Just remember the AC1021 in front of it.

Then, by comparing the version format comparison table below, you can know the version of the drawing saved.

MC0.0 – DWG Release 1.1
AC1.2 – DWG Release 1.2
AC1.4 – DWG Release 1.4
AC1.50 – DWG Release 2.0
AC2.10 – DWG Release 2.10
AC1002 – DWG Release 2.5
AC1003 – DWG Release 2.6
AC1004 – DWG Release 9
AC1006 – DWG Release 10
AC1009 – DWG Release 11/12 (LT R1/R2)
AC1012 – DWG Release 13 (LT95)
AC1014 – DWG Release 14, 14.01 (LT97/LT98)
AC1015 – DWG AutoCAD 2000/2000i/2002
AC1018 – DWG AutoCAD 2004/2005/2006
AC1021 – DWG AutoCAD 2007/2008/2009
AC1024 – DWG AutoCAD 2010/2011/2012
AC1027 – DWG AutoCAD 2013/2014/2015/2016/2017
AC1032 – DWG AutoCAD 2018/2019/2020/2021/2022/2023

Read more