Yadda ake shigo da bayanai daga PDF zuwa Microsoft Excel

Cire bayanai da sauri daga fayil ɗin PDF, loda shi cikin takardar Excel, kuma ƙara haɓaka aikin ku.

Idan kuna da kowane bayanai a cikin PDF, kamar bayanin bankin ku ko wasu bayanan kuɗi, kuma kuna son shigo da su cikin fayil ɗin Excel, ba kwa buƙatar neman kowane aikace-aikacen ɓangare na uku. Za ka iya amfani da PDF Data Connector, wanda kayan aiki ne da aka gina a cikin Microsoft Excel.

Kuna iya shigo da tebur da/ko bayanan da aka adana a cikin fayil ɗin PDF cikin sauƙi a cikin takardar Excel ta amfani da wannan fasalin. Haka kuma, zaku iya gyara bayanan kafin shigo da su cikin Excel ta amfani da Editan Query wanda shima wani bangare ne na wannan kayan aikin. Kayan aikin yana samuwa ga masu amfani da Microsoft 365 kawai.

Jawo bayanai daga PDF zuwa takardar Excel

Shigo da bayanai a cikin takardar Excel tsari ne mai sauƙi. Abinda kawai ake buƙata shine cewa an adana takardar Excel akan ƙarar ku ta biyu.

Don shigo da bayanai daga fayil ɗin PDF, da farko, buɗe Microsoft Excel. Je zuwa menu na farawa kuma buga Exceldon yin bincike. Sannan danna Microsoft Excel don buɗe aikace-aikacen.

Sa'an nan, danna kan "Blank Workbook" zaɓi don ci gaba.

Na gaba, danna kan Data tab daga menu na ribbon sannan danna Zaɓin Samun Bayanai don ci gaba. Na gaba, shawagi kan Zaɓin Zaɓin Fayil sannan danna Daga zaɓin Fayil ɗin PDF daga menu na ƙasa. Wannan zai buɗe taga daban na mai binciken fayil akan allonku.

Na gaba, gano wuri kuma zaɓi fayil ɗin da kuke son shigo da bayanai daga ciki ta danna kan shi. Sannan danna maballin "Bude" don loda bayanan. Wannan zai buɗe taga daban akan allonku.

Yanzu, daga allon Navigator, duk abubuwan da aka zaɓa (Tables ko shafuka) na PDF zasu bayyana a gefen hagu. Kuna iya zaɓar takamaiman sashi ta danna kan shi ko amfani da zaɓin bincike. Za'a buɗe samfoti a cikin madaidaicin aiki. Kuna iya zaɓar duka shafin kuma. Da zarar an zaba, danna maɓallin Load don shigo da bayanan kai tsaye zuwa cikin Excel, ko danna maɓallin Maida Bayanan don ci gaba.

Idan ka danna maɓallin Maida Data a mataki na baya, za a nuna bayanan a wata taga daban a cikin tsari mai iya gyarawa. Idan kuna canza tebur, kuna iya ƙara/gyara shafi da sunan jere da bayanan tebur. Hakanan zaka iya amfani da kayan aikin daban-daban da aka bayar a cikin menu na kintinkiri don sarrafa bayanai bisa ga buƙatun ku.

Bayan yin gyare-gyaren da ake buƙata ga bayanan, danna kan "Rufe da Load" bayanan don shigo da su cikin takardar Excel.

Da zarar an ɗora bayanan, za ku iya duba su a cikin takardar Excel.

Shi ke nan. Lokaci na gaba da kake son yin aiki tare da bayanan da aka adana a tsarin PDF, zaku iya shigo da shi cikin sauri zuwa cikin Excel ba tare da lalata kayan aiki ba.

Related posts
Buga labarin akan

Ƙara sharhi