a way to convert a libreoffice file to a vcf?

[12345678]

every online tool seems to be broken

my file is like this

 

I tried to make a python code for it, but it did not end up well

https://pastebin.com/yyNT1A41

[Gokul_P]

57 minutes ago, 12345678 said:

every online tool seems to be broken

my file is like this

 

I tried to make a python code for it, but it did not end up well

https://pastebin.com/yyNT1A41

Export from spreadsheet to csv.
Import the csv into the Thunderbird address book.
Export from TB address book to VCF.

[12345678]

8 hours ago, Gokul_P said:

Export from spreadsheet to csv.
Import the csv into the Thunderbird address book.
Export from TB address book to VCF.

it works but it's incredibly slow

[Gokul_P]

1 hour ago, 12345678 said:

it works but it's incredibly slow

Huh what is your specs 

[12345678]

3 minutes ago, Gokul_P said:

Huh what is your specs 

5800h + 3060 mobile

 

in theory doing

import pandas as pd

 

# read CSV file using pandas

df = pd.read_csv('modified1.csv')

 

# convert dataframe to VCF format and write to file

df.to_csv('mf1.vcf', sep='\t', columns=['Name', 'Phone', 'Email'], header=False, index=False

 

# should be faster but I can't get it work because of pandas module missing, trying to make a new pip install manga, it looks installed,

# I tried to make a new enviroment, on vscode, but it doesn't work out

[Gokul_P]

2 minutes ago, 12345678 said:

5800h + 3060 mobile

 

in theory doing

import pandas as pd

 

# read CSV file using pandas

df = pd.read_csv('modified1.csv')

 

# convert dataframe to VCF format and write to file

df.to_csv('mf1.vcf', sep='\t', columns=['Name', 'Phone', 'Email'], header=False, index=False

 

# should be faster but I can't get it work because of pandas module missing, trying to make a new pip install manga, it looks installed,

# I tried to make a new enviroment, on vscode, but it doesn't work out

It is weird you have 5800H and it is still slow. Which os you are on

[12345678]

2 minutes ago, Gokul_P said:

It is weird you have 5800H and it is still slow. Which os you are on

w11

 

I don't think that's the problem, but the problem is the way that thunderbird process it

it goes line by line which is slow

and my file is huge