Excel , iyo sidoo kale dhammaan codsiyada muhiimka ah ee Microsoft Office , waxay soo mareen tobanaan sano oo casriyeyn version ah. Kor u qaadisyadaas waxaa la socday habab yaryar oo lagu kordhinayo faylka Excel si loo xisaabiyo faraqa u dhexeeya faylalkaas Excel .

Ma aha kala duwanaanshaha nooca kaliya ee dhaliya kordhinta faylka cusub. Qaar ka mid ah fidinta faylka ayaa si gaar ah u tixraacaya nooca faylka, sida haddii ay tahay template Excel ama faylka ^(Excel)Excel oo ka kooban makro.

Haddii aad fahamto dhammaan kordhinta faylka Excel^{(understand all of the Excel file extensions)} , waxaad si fiican u qabsan doontaa sida loo kaydiyo faylkaaga sanduuqa wadahadalka kaydinta.

Waa maxay sababta Extensions File Extensions muhiim u tahay

Fidinta faylka Excel wuxuu ku siinayaa macluumaad muhiim ah oo ku saabsan faylkaas ka hor inta aadan furin. Waxa kale oo ay kuu ogolaanaysaa inaad habayso faylalka aad ku kaydsato hagayaashaada sida faylalka template, faylalka macro-awood u leh, iyo in ka badan. Markaad eegto kaliya kordhinta faylka Excel , waxaad wax badan ka ogtahay faylka ^(Excel)Excel iyo waxa loo isticmaalo.

Kordhinta faylka Excel ayaa kuu sheegaya:

• Haddii macros ama VBA lagu daro
• Haddii faylka lagu kaydiyay nooc ka sii weyn oo Excel ah^(Excel)
• Haddii qaabka faylka uu ku salaysan yahay dukumeenti XML ama binary
• Nooca dhaxalka guud ee faylka ayaa lagu kaydiyay
• Haddii faylku yahay qaab qaabaysan

Waxaad ku arki kartaa dhammaan faylasha kordhinta ee Excel adiga oo dooranaya Faylka^(File) menu-ka, dooro Save As , ka dibna dooro nooca faylka ee hoos yimaada goobta magaca faylka.

Sida aad arki karto, mid kasta oo ka mid ah noocyada faylalka ayaa leh magac qeexan oo ka caawinaya fahamka waxa kordhinta faylka loogu talagalay.

Kordhinta Faylka Excel ee Nooca

Kooxda kowaad ee kordhinta faylka waxay la xidhiidhaa ugu horayn nooca Excel xaashida shaqada lagu kaydiyay. Noocyada fidinta ee soo socda waxay ku xidhan yihiin noocyada Excel ee halkan lagu muujiyey:

• Excel 97-2003: *.xls
• Excel 97-2003 template: * .xlt
• XML Spreadsheet 2003: *.xml
• Microsoft Excel 5.0/95 : * .xls^(Workbook)
• Excel 97-2003 Kudar: *.xlam
• Excel 4.0: * .xlw
• Microsoft Works: *.xlr

Sida aad arki karto, * .xls faylka kordhintu waa qaabka dhaxalka ah ee Excel ee dhammaan noocyada Excel ka hor 2007^(Excel) . 

Laga soo bilaabo Excel 2007 wixii ka dambeeyay, kordhinta faylka caadiga ah ee fayl kasta oo Excel ahaa (oo hadhaa) *.xlsx.

Farqiga u dhexeeya XLS Vs XLSX

Iyadoo Microsoft ay u beddesho kordhinta XLSX ka dib ^(XLSX)Excel 2007 waxay u egtahay isbeddel magac-bixineed oo qarsoodi ah, runtu waxay tahay in uu jiray isbeddel ka badan oo kaliya kordhinta faylka.

XLS waxay ku kaydisaa xaashiyaha Excel qaab fayl ah oo loo yaqaan Qaabka Faylka Isweydaarsiga ^{(Interchange File Format)}Binary . Kani wuxuu ahaa qaab faylal iska leh oo ay abuurtay Microsoft .

Iyadoo la sii daayay Excel 2007 , Microsoft waxay u beddeshay asalka XLSX , taas oo ku salaysan qaabka XML ee Xafiiska Furan^{(Office Open XML)} . Tani waa habka lagu keydiyo macluumaadka xaashida ee faylka XML.

Maxay ahaayeen faa'iidooyinka u beddelashada habkan cusub ee lagu badbaadinayo macluumaadka xaashida xaashida ee Excel ? Kuwa badan baa jira.

• La shaqayn karo : Faylasha qaabaysan ee ^{(Interoperable)}XML furan^{(Open XML)} ee Xafiiska furan waxa si fudud loogu jiidi karaa codsiyada kale^{(pulled into other applications)} ee akhrin kara qaababka XML ee Xafiiska.
• Extensible : Codsiyada dibadda ama barnaamijyada waxay maamuli karaan waxa ku jira qaabka hoose ee XML - tani waxay la macno tahay barnaamij-bixiyeyaashu waxay abuuri karaan software si ay u tafatiraan xaashida Excel iyada oo aan waligood furin codsiga Excel laftiisa.^(Excel)
• Ka badbaado musuqmaasuqa^{(Safer from corruption)} : Faylasha la qaabeeyey ee XML^{(XML formatted files)} aad bay ugu nugul yihiin musuqmaasuqa ama burburka marka loo eego faylalka binary sida faylasha XLS .
• Kayar^(Smaller) : Waxaad ku kaydin kartaa xog badan faylal yar marka aad isticmaasho qaabka XLSX . Microsoft waxay^(Microsoft) sheeganeysaa in faylasha XLSX ay 75 boqolkiiba ka yar yihiin faylasha XLS.

Haddii mid ka mid ah faa'iidooyinkaas aysan muhiim ahayn adiga, markaa waxaa laga yaabaa inaad ku fiicnaan lahayd inaad sii haysato qaabka hore ee XLS Excel . Waxaad helaysaa laba faa'iido markaad tan sameyso.

Midda koowaad waa in faylasha XLS ay u muuqdaan inay kaydiyaan oo si dhakhso leh u furaan. Marka labaad, faylasha Excel ee leh kordhinta ^(Excel)XLS ayaa laga furi karaa nooc kasta oo Excel ah , iyada oo aan loo eegin inta da'da.

Faylka kale ee Excel Extensions

Hadda oo aad fahantay faraqa u dhexeeya XLS iyo XLSX , way yara fududahay in la qeexo waxa macnaheedu yahay kordhinta faylka kale ee Excel .

• .xlsm : Qaabka XML ee faylasha Excel kuwaas oo sidoo kale taageera macros Excel
• .xlsb : Habka Binary-ga ah ee Excel (nooca ka weyn) oo sidoo kale taageera macros Excel
• .xltx : Fayl Excel ah oo loo kaydiyay qaab template ah si loogu isticmaalo barta bilawga buugaagta shaqada ee Excel mustaqbalka^(Excel)
• .xltm : Faylka ^(.xltm)Excel macro-enabled kaas oo loo kaydiyay qaab template ah

Excel Template Files

Haddii aadan aqoon u lahayn qaab-dhismeedka Excel , waxa ay noqon kartaa wakhti fiican inaad wax ka barato oo aad bilowdo isticmaalkooda. Haddii aad isku aragto inaad abuurto xaashiyo badan oo wadaaga qaabaynta, qaacidooyinka, ama qaabaynta isku mid ah, template-ku wuxuu kaa badbaadin karaa waqti aad u badan.

Waxa kaliya oo ay tahay inaad sameyso si aad u abuurto template waa inaad dejiso qaabayntaada, qaabayntaada, iyo qaybaha kale ee xaashidaada shaqada oo aadan rabin inaad mar kasta dib u abuurto. Kadibna ku keydi faylka mid ka mid ah kordhinta faylka Excel ee kor ku xusan ee qaabka template.

Dhab ahaantii, marka aad furto fayl cusub gudaha Excel , waxaad ka raadin kartaa kumanaan qaab-dhismeedka hore ee qaybo badan.

Furitaanka Noocyada kale ee Faylka

Excel kuma koobna furitaanka kaliya faylalka leh kordhinta faylka Excel . Markaad furto faylka Excel oo aad ka doorato sanduuqa nooca faylka, waxaad arki doontaa liis dheer oo ka baxsan waxa ku qoran maqaalkan.

Tani waa sababta oo ah waxaa jira qaabab faylal aan Microsoft ahayn oo sidoo kale lagu taageero Excel .

• *.xml : Xadhig kasta oo ka mid ah codsiyada kaydiya xaashida qaabka XML Spreadsheet 2003^{(XML Spreadsheet 2003)} , ama faylasha xogta XML toosan loo habeeyey.
• *.prn : xaashida lotus
• .txt : Faylasha qoraalka ee Tab-delimited ama Unicode
• .csv : Faylasha qoraalka ee Comma-xadaysan
• .dif : Faylasha qoraalka qaab beddelka xogta^{(Interchange Format)}
• .slk : Faylasha qoraalka ee isku xirka astaanta
• .dbf : faylasha xogta dBase
• .ods : xaashiyaha dukumeentiga furan ^(OpenOffice)_^{(Google Docs)}
• .pdf : Waxay haysaa habaynta xogta marka aad furto faylasha PDF
• .xps : XML Faylasha Xogta Warqadda^{(Paper Specification)}

Maskaxda ku hay in ay ku xiran tahay nooca Excel ee aad isticmaalayso, dhammaan noocyada faylalkani kuma soo bandhigi doonaan ikhtiyaar ahaan marka aad kaydinayso ama aad furayso faylasha.

A Guide To All Excel File Extensions & What They Mean

Εxcel, as well as all of the core Microsoft Office applications, have gone through decades of version upgrades. Along with those upgrades cаme small tweaks to Excel file extensions to account fоr the differences between those Excel files.

It isn’t just version differences that spawn new file extensions. Some file extensions refer specifically to the type of file, such as whether it’s an Excel template or an Excel file that contains a macro.

If you understand all of the Excel file extensions, you’ll have a better handle on how to save your file in the file save dialogue box.

Why Excel File Extensions Matter

The extension of an Excel file provides you with important information about that file before you open it. It also lets you organize the files you save into your directories as template files, macro-enabled files, and more. With just a glance at the Excel file extension, you know more about the Excel file and what it’s used for.

Excel file extensions tell you:

• Whether macros or VBA is included
• If the file was saved with an older version of Excel
• Whether the file format is based on XML documents or binary
• The general legacy version the file was saved with
• Whether the file is a template

You can see all of the file extensions in Excel by selecting File from the menu, select Save As, and then select the file type dropdown under the file name field.

As you can see, each of the file types have a descriptive name that helps with understanding what the file extension is for.

Excel File Extensions By Version

The first group of file extensions are related primarily to which version of Excel the worksheet was saved with. The following extension types are connected to the Excel versions shown here:

• Excel 97-2003: *.xls
• Excel 97-2003 template: *.xlt
• XML Spreadsheet 2003: *.xml
• Microsoft Excel 5.0/95 Workbook: *.xls
• Excel 97-2003 Add-in: *.xlam
• Excel 4.0: *.xlw
• Microsoft Works: *.xlr

As you can see, the *.xls file extension is the default legacy Excel format for all versions of excel prior to Excel 2007. 

From Excel 2007 onwards, the default file extension for any Excel file was (and remains) *.xlsx.

The Differences Between XLS Vs XLSX

While Microsoft switching to the XLSX extension after Excel 2007 seems like a superficial naming convention change, the truth is that there was more change than just the file extension.

XLS stores Excel spreadsheets in a file format known as Binary Interchange File Format. This was a proprietary file format created by Microsoft.

With the release of Excel 2007, Microsoft changed the default to XLSX, which is based on the Office Open XML format. This is a method of saving spreadsheet information in an XML file.

What were the advantages of switching to this new method of saving Excel spreadsheet information? There are many.

• Interoperable: Office Open XML formatted files can more easily be pulled into other applications that can read Office XML formats.
• Extensible: External applications or programs can manipulate the contents of the underlying XML format — this means programmers can create software to edit Excel spreadsheets without ever opening the Excel application itself.
• Safer from corruption: XML formatted files are less susceptible to corruption or damage than binary files like XLS files are.
• Smaller: You can store more data in a smaller file when you use the XLSX format. Microsoft claims XLSX files are 75 percent smaller than XLS files.

If none of those advantages matter much to you, then you might be better off staying with the older default XLS Excel format. You do get two advantages when you do this.

The first is that XLS files tend to save and open faster. Secondly, Excel files with the XLS extension can be opened on every version of Excel, no matter how old.

Other Excel File Extensions

Now that you understand the difference between XLS and XLSX, it’s a little bit easier to decipher what all of the other Excel file extensions mean.

• .xlsm: XML format Excel files that also support Excel macros
• .xlsb: Binary format Excel files (older version) that also support Excel macros
• .xltx: An Excel file saved as a template to be used as a starting point for future Excel workbooks
• .xltm: A macro-enabled Excel file that’s saved as a template

Excel Template Files

If you’re unfamiliar with Excel templates, it may be a good time to learn about and start using them. If you find yourself creating a lot of spreadsheets that share the same formatting, formulas, or layout, a template can save you a great deal of time.

All you have to do to create a template is set up your formatting, layouts, and other aspects of your worksheet that you don’t want to recreate every time. Then save the file with one of the Excel file extensions listed above for template format.

In fact, when you open a new file in Excel, you can search through thousands of premade templates across many categories.

Opening Other File Types

Excel isn’t limited to opening only files with Excel file extensions. When you open a file in Excel and select from the file type drop box, you’ll see a long list beyond what’s listed in this article.

This is because there are non-Microsoft file formats that are also supported in Excel.

• *.xml: Any spreadsheets from applications that stored the sheets in XML Spreadsheet 2003 format, or straight XML formatted data files.
• *.prn: Lotus spreadsheets
• .txt: Tab-delimited or Unicode text files
• .csv: Comma-delimited text files
• .dif: Data Interchange Format text files
• .slk: Symbolic Link Format text files
• .dbf: dBase data files
• .ods: Opendocument spreadsheets (Google Docs or OpenOffice)
• .pdf: Retains the formatting of data when you open PDF data files
• .xps: XML Paper Specification data files

Keep in mind that depending on the Excel version you’re using, not all of these file types will display as options when you’re saving or opening files.

Related posts

• Hagaha ugu dambeeya ee Dayactirka Faylka Erayga Burburay ama La Musuqmaasuqay

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• U qaabeeya Unugyada iyadoo la isticmaalayo Habaynta Shuruudaha ah ee Excel

• Sida loo daro oo loo daabaco sawirada asalka ah ee Excel

• Sida loo furo faylka WPS

• Geli xaashida shaqada ee Excel Word Doc

• Sida Taariikhaha Looga Jaro Excel

• Sida loo saaro, loo jebiyo, ama loo jebiyo erayga sirta ah ee Excel XLS ee la iloobay

• Sida loo kala saaro Magacyada Hore iyo Dambe ee Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Sida loo Helo loona Xisaabiyo Range gudaha Excel

• Sida loo Helo Qiimaha Iswaafajinta gudaha Excel

• Sida Loo Sameeyo Liiska Hoos-u-dhaca ee Excel

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• Sida Loogu Beddelayo Inta u dhaxaysa Waraaqaha Shaqada ee Excel

• Hagaha Cilad-raadinta ugu dambeeya ee Dhibaatooyinka Rakibaadda Xafiiska 2013