How to add multiple Columns into Sqlite3 from a for loop in Python

I think you just change

index =0
for link in names:
idofperson = ids[index]
c.execute("INSERT INTO thetable(name, id)VALUES(?, ?)", ( [link], idofperson ))

to this (use enumrate and change [list] to list, because you pass a list into a column need TEXT type):

for index, link in enumrable(names):
idofperson = ids[index]
c.execute("INSERT INTO thetable(name, id)VALUES(?, ?)", ( link, idofperson ))

your variable index is not increasing.try using the enumerate on for loop. or just add index += 1 after execute

for your problem, try this:

import sqlite3

names = ['Tom', 'Dick', 'Harry']
ids = ['A452', 'B698', 'Kd9f']
data = zip(names, ids)
conn = sqlite3.connect('testforinput.db')
c = conn.cursor()
c.execute("CREATE TABLE thetable(name TEXT, id TEXT)")


for d in data:
    sql = "INSERT INTO thetable (name, id) VALUES ('%s', '%s'); " % d
    c.execute(sql)

conn.commit()
conn.close()

I suggest change data to a list of dict, like this [{'name':'Tom', 'id': 'A452'}, {'name':'dick', 'id':'B698'}..] and you can generate insert sql by data, this make the insert more flexible.