Importing urls from CSV
Dear Sven,
I am trying to import a list of URLs to an existing project.
I already imported a list of URLs from a regular txt file and it worked without a problem.
But I also want to import URLs from CSV file because i want to have a few other columns, so that each URL has a few more values that i can use in my messages in order to make each message more unique. As far as I know, this is not possible with a regular txt file. Am i correct?
But no matter what i do, the program simply does not import the CSV data correctly and no new URLs are being added to the URL list of the project.
And yes, I already know that "Also after import you will NOT see new columns in the site listing, but you see CSV Data details in a mouse over hint." but in my case no new rows (URLs) were added to the project at all!
Can you please explain EXACTLY WHERE in the program should i import the CSV file?
And what exact CSV file format should i use?
I tried CSV-UTF 8 and also CSV COMMA DELIMITED but none worked!
Do I have to save the CSV file in a special way in order to be able to import it into the program??
Many thanks,
Z
I am trying to import a list of URLs to an existing project.
I already imported a list of URLs from a regular txt file and it worked without a problem.
But I also want to import URLs from CSV file because i want to have a few other columns, so that each URL has a few more values that i can use in my messages in order to make each message more unique. As far as I know, this is not possible with a regular txt file. Am i correct?
But no matter what i do, the program simply does not import the CSV data correctly and no new URLs are being added to the URL list of the project.
And yes, I already know that "Also after import you will NOT see new columns in the site listing, but you see CSV Data details in a mouse over hint." but in my case no new rows (URLs) were added to the project at all!
Can you please explain EXACTLY WHERE in the program should i import the CSV file?
And what exact CSV file format should i use?
I tried CSV-UTF 8 and also CSV COMMA DELIMITED but none worked!
Do I have to save the CSV file in a special way in order to be able to import it into the program??
Many thanks,
Z
Comments
When I save to CSV with excel, the default saving will not wrap the values with " "
And the program does not recognize the data in the CSV file.
I found a way to wrap the values inside the csv file, it takes a little more time but not the end of the world.
If the program could recognize CSV file with the default excel format that would be fantastic.
Z
By the way, you deserve A MILLION THANKS for adding the an option to make the GUI size larger, it's the first time I noticed this feature. Thank you thank you thank you for that. I struggle with this super small annoying fonts for a long time, but not anymore
Is it possible to change the GUI size also with Search Engine Ranker? and what about the GUI size of captcha breaker?
To import URLs from a CSV file, you can use Python's built-in
csv
module andrequests
module. Here's an example code that reads a CSV file and makes a GET request to each URL listed in the fileIn this example, assume that
urls.csv
is a CSV file that contains a list of URLs in the first column. Thecsv.reader
method is used to read the file, and therequests.get
method is used to make a GET request to each URL. The status code of each response is printed to the console.