Ka soo dejinta xogta dukumiintiyada PDF ee xaashida xaashida ee ^(PDF)Excel way fududaatay, xushmada Xidhiidhiyaha Xogta PDF^{(PDF Data Connector)} . Si la mid ah ilaha xogta kale ee Excel , Xafiiska 365^{(Office 365)} macaamiisha ayaa hadda dhisi kara xiriir ka dhexeeya Excel iyo dukumeenti PDF ah. Sidan, isticmaalayaashu waxay doortaan xogta ay rabaan inay ku soo dejiyaan xaashida xaashida ee Excel . Keenista xogta PDF ee xaashiyaha Excel^{(Importing PDF data into Excel spreadsheets)} waa qayb ka mid ah habka Hel & Beddelka ee Excel .

Sida loo isticmaalo Xidhiidhiyaha Xogta PDF^{(PDF Data Connector)} ee Microsoft Excel

Si aad awood ugu yeelatid isticmaalka habka soo dejinta PDF ee Excel^{(Excel’s PDF importer feature)} , waa inaad marka hore ku xidhaa dukumeenti PDF ah xaashida Excel ee^{(connect a PDF document to the Excel spreadsheet)} aad ku shaqaynayso.

Kuwa soo socda ayaa ah tillaabooyinka hagi doona isticmaaleyaasha Office 365 sida loo sameeyo xiriir ka dhexeeya dukumeenti PDF ah iyo xaashida xaashida Excel :

1. Samee xaashi cusub oo Excel ah.
2. Ka fur Hel Xogta^{(Get Data)} menu ka tab xogta^(Data) ee ribbon.
3. Ka dooro Faylka> PDF.
4. Hel dukumeentiga PDF ee aad rabto inaad isticmaasho.
5. Dooro xogta aad rabto inaad soo dejiso.

Markaad doorato dukumeenti PDF ah oo aad rabto inaad xogta ka soo dejiso, daaqada navigator ayaa soo bandhigi doonta liiska miisaska aad ku soo dejisan karto xaashida Excel .

Hadda, dooro tiro kasta oo ah dukumeenti PDF ah si aad u soo dejiso ^(PDF)Excel . Waxa kaliya ee^(All) aad u baahan tahay inaad sameyso waa guji batoonka Load si aad xogta u soo geliso xaashida faafintaada. Haddii kale, isticmaalayaasha Excel waxay sidoo kale dooran karaan Beddelka Xogta^{(Transform Data)} si ay u nadiifiyaan xogtaada oo ay ugu diyaariyaan falanqaynta, ixtiraamka Tifaftiraha Query Query^{(Power Query Editor)} .

Sida hal mar loogu soo dejiyo bogag badan oo ^(Excel)PDF ah^(PDF)

Habka aan soo bandhignay ilaa hadda waa mid faa'iido leh marka xogta laga soo dejiyo dukumeenti PDF ah oo la galiyo Excel . Si kastaba ha ahaatee, waxaa laga yaabaa inay jirto xaalad ah inaad xogta ka soo dejiso bogag badan hal mar.

Waxa kaliya ee aad u baahan tahay inaad sameyso waa inaad caddeyso boggaga Start iyo End inay yihiin xuduudo ikhtiyaari ah oo loogu talagalay isku xirka PDF . Hore u soco oo ka yeedh qaacidada soo socota ee Tafatiraha Query Query^{(Power Query Editor)} :

Pdf.Tables(File.Contents("C:\Sample.pdf"), [StartPage=5, EndPage=10])

Ma u aragtaa soo dejinta cusub ee Excel mid waxtar leh? Noogu sheeg faallooyinka hoose.^{(Do you find Excel’s new PDF importer feature useful? Let us know in the comments below.)}

Dhanka kale, waxaa jira 10 tabaha ugu faa'iidada badan ee Excel iyo tabaha loogu talagalay bilowgayaasha^{(10 most useful Excel tips and tricks for beginners)} oo ay tahay in qofku u baahan yahay inuu ogaado. Bal u fiirsada iyaga!

Use PDF Data Connector in Excel to import PDF data into spreadsheet

Importing data from PDF documents into Excel spreadsheets has become easier, courtesy of PDF Data Connector. Similar to any other data source in Excel, Office 365 subscribers can now establish a connection between Excel and a PDF document. This way, users select data they wish to import into an Excel spreadsheet. Importing PDF data into Excel spreadsheets is part of Excel’s Get & Transform feature.

How to use PDF Data Connector in Microsoft Excel

In order to be able to use Excel’s PDF importer feature, you must first connect a PDF document to the Excel spreadsheet you are working on.

Following are the steps that will guide Office 365 users on how to establish a connection between a PDF document and an Excel spreadsheet:

1. Create a new Excel spreadsheet.
2. Open the Get Data menu from the Data tab on the ribbon.
3. Select From File > From PDF.
4. Locate the PDF document you want to use.
5. Select the data you want to import.

Once you choose the PDF document you wish to import the data from, a navigator window will display the list of tables you can import into your Excel spreadsheet.

Now, select any number of PDF document elements to import into Excel. All you need to do is click on the Load button to bring the data into your spreadsheet. Alternatively, Excel users can also select Transform Data in order to clean your data and prepare it for analysis, courtesy of Power Query Editor.

How to import multiple PDF pages into Excel at once

The procedure we have demonstrated so far is useful when importing data from a single PDF document into Excel. However, there may be a situation where you have to import data from multiple pages at once.

All you need to do is specify Start and End pages as optional parameters for the PDF connection. Go ahead and invoke the following formula from the Power Query Editor:

Pdf.Tables(File.Contents("C:\Sample.pdf"), [StartPage=5, EndPage=10])

Do you find Excel’s new PDF importer feature useful? Let us know in the comments below.

Meanwhile, there are 10 most useful Excel tips and tricks for beginners that one must need to know. Take a look at them!

Related posts

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

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

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida faylka Excel loogu beddelo PDF onlayn addoo isticmaalaya Google Drive

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• 4 Siyaabood Oo Lagu Yareeyo Isticmaalka Xogta ee YouTube Appka

• Sida loo isticmaalo Gelida Xogta laga soo qaatay muuqaalka sawirka ee Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Adeegso Excel si aad u ogaato dulsaarka waxtarka leh ee ka imanaya heerka dulsaarka magaca ah

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel