I'm new to programming and want to take values from an Excel spreadsheet and put them into a website. What language would be a good place to start?
What language should I use to copy spreadsheet values into a website?
Answers
Python is a good starting point. You can use openpyxl to read an Excel workbook and Playwright to open the website, fill in fields, and submit a form.
Start with one row rather than the whole spreadsheet. Playwright has a code generation tool that can record your actions in the browser as starter code. Once that works, replace the fixed values with values read from the sheet and add a loop for the remaining rows.
Test carefully before submitting lots of data. Some sites block automated browsers, and a changed form can break your script.
Reply to this answer
First check how the website accepts the data. If it offers an import feature or an API for adding records, you might not need to automate clicks at all. Reading the spreadsheet and sending the values through a supported interface can be simpler than keeping a form script working.
If there is no suitable import or API, browser automation is a reasonable next thing to look at.
Reply to this answer
You may not need a programming language for this. Power Automate can handle basic spreadsheet and web form tasks with relatively little code. It's worth checking if it supports the specific workbook and website you need to use.
Reply to this answer
Lots of languages can do it, including C# and PowerShell. The key distinction is that you can often read the spreadsheet file directly. Your program doesn't necessarily have to open Excel and control its window.
The file format matters when choosing a library. For example, openpyxl is aimed at newer Excel workbook formats, while older binary files may need a different approach.
Reply to this answer
Add your answer
Answers are reviewed before publication.
n.638!parcelgauge:
Selenium is another option for controlling the browser if you find its examples easier to follow.