SOLVED

Use Microsoft Forms to edit an existing row in Excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-2724263%22%20slang%3D%22en-US%22%3EUse%20Microsoft%20Forms%20to%20edit%20an%20existing%20row%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724263%22%20slang%3D%22en-US%22%3E%3CP%3E%22When%20we%20insert%20a%20Form%20in%20Excel%20Online%2C%20it%20will%20add%20a%20new%20Tab%20called%20like%20%22Form1%22%20with%20a%20linked%20updatable%20table.%20The%20table%20is%20created%20according%20to%20your%20form%20and%20it%20has%20some%20fixed%20columns%20recording%20form%20responders'%20information.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThere%20seems%20to%20be%20no%20method%20to%20create%20a%20form%20based%20on%20our%20existing%20table%2Frow.%20We%20can't%20make%20our%20existing%20table%2Frow%20updatable%20using%20Microsoft%20Forms.%22%20(%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F1549251%2Fuse-microsoft-forms-to-edit-an-existing-row-in-excel-online%2F1550595%231550595%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fsuperuser.com%2Fquestions%2F1549251%2Fuse-microsoft-forms-to-edit-an-existing-row-in-excel-online%2F1550595%231550595%3C%2FA%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20have%20an%20idea%20if%20there%20is%20a%20solution%20for%20this%3F%3CBR%20%2F%3EI%20have%20a%20members%20list%20with%20different%20data%20rows%20(name%2C%20birth%20date%2C%20etc.)%20for%20which%20I%20would%20like%20to%20create%20a%20form%20so%20that%20new%20members%20can%20enter%20themselves.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20understand%20it%20well%2C%20I%20have%20to%20create%20the%20form%20with%20my%20desired%20sections%20and%20then%20copy%20%26amp%3B%20paste%20all%20the%20existing%20data%20into%20the%20connected%20form%20columns%2C%20right%3F%3C%2FP%3E%3CP%3EThere%20is%20no%20way%20to%20create%20the%20form%20automatically%20out%20of%20the%20existing%20rows%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%20guys!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2724263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2726223%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20Microsoft%20Forms%20to%20edit%20an%20existing%20row%20in%20Excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F510099%22%20target%3D%22_blank%22%3E%40Markus_Espeter%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20first%20create%20the%20Form%20connected%20to%20your%20Excel%20file.%20It%20creates%20structured%20Table.%20Without%20changing%20this%20table%20columns%20names%20you%20may%20add%20existing%20data%20from%20other%20source%20to%20the%20table.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEach%20time%20someone%20fills%20the%20form%20new%20row%20will%20be%20added%20to%20the%20table%2C%20it%20won't%20affect%20already%20entered%20into%20the%20table%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMoreover%2C%20you%20may%20add%20another%20columns%20to%20that%20table%20(e.g.%20for%20comments%2C%20whatever)%2C%20and%20add%20into%20such%20columns%20information%20manually.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20important%2C%20columns%20linked%20to%20the%20Form%20shall%20not%20be%20changed.%20I%20don't%20remember%20now%20they%20are%20linked%20by%20internal%20ID%20or%20by%20names%2C%20in%20any%20case%20it%20will%20be%20more%20reliable%20to%20keep%20created%20by%20Form%20columns%20as%20they%20are%20without%20modifications.%20Data%20and%20other%20columns%20could%20be%20added%20manually.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAll%20above%20is%20quite%20easy%20to%20test%20before%20deploying%20final%20variant%20into%20production.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

"When we insert a Form in Excel Online, it will add a new Tab called like "Form1" with a linked updatable table. The table is created according to your form and it has some fixed columns recording form responders' information.

There seems to be no method to create a form based on our existing table/row. We can't make our existing table/row updatable using Microsoft Forms." (https://superuser.com/questions/1549251/use-microsoft-forms-to-edit-an-existing-row-in-excel-online/...)

 

Does anybody have an idea if there is a solution for this?
I have a members list with different data rows (name, birth date, etc.) for which I would like to create a form so that new members can enter themselves.

If I understand it well, I have to create the form with my desired sections and then copy & paste all the existing data into the connected form columns, right?

There is no way to create the form automatically out of the existing rows?

 

Thank you for your help guys!

3 Replies
best response confirmed by Markus_Espeter (New Contributor)
Solution

@Markus_Espeter 

You may first create the Form connected to your Excel file. It creates structured Table. Without changing this table columns names you may add existing data from other source to the table.

 

Each time someone fills the form new row will be added to the table, it won't affect already entered into the table data.

 

Moreover, you may add another columns to that table (e.g. for comments, whatever), and add into such columns information manually.

 

What is important, columns linked to the Form shall not be changed. I don't remember now they are linked by internal ID or by names, in any case it will be more reliable to keep created by Form columns as they are without modifications. Data and other columns could be added manually.

 

All above is quite easy to test before deploying final variant into production.

Thank you for your help Sergei!