Login with Formloop account

Username (e-mail):
Password:

Click here to get an account for free.

Login with Google account

I agree to the FormLoop TOS    

Google Account or Gmail ?

Search for Calculators

On-line Stats

  • Created Formulas: 651
  • Created Widgets: 3502
APIs, Widgets & Apps
"Making the complex simple"

Instructions Spreadsheet Import

Use these instructions or look at the Instruction video, Spreadsheet upload.

Step 1. Prepare.

1. Create a formloop account and login and then choose "Create content" from the top-menus and there choose "import your spreadsheet". Or go to spreadsheet import module direct if your are logged in.
2. Download an example excel file or use your own file that you have for your excel application.
3. Prepare your file so it has a structured layout.

Excel file example

Step 2. Download file for spreadsheet.

1. Open the text file by pressing "Download File" and open it with excel, libre office or google docs.
2. Keep the file separated by semicolon and tabs and " as text delimiter.
3. Save the file in csv format for editing.

What the file should look like:

Excel file example

Step 3. Prepare Your file for upload

1. Input your variables and formulas in the downloaded file.

In the excel/txt file fill in or copy paste from your existing file; formula, variables, constant and formula name and description.

What the file should look like:

Excel file example

EXCEL

2. Select the Show Formulas button (via Formulas > show formulas).
3. Save As file-type CSV(MS-DOS).
4. Open the file in Notepad to verify that all your data is there.

LIBRE OFFICE

2. Choose Tools - Options - LibreOffice Calc - View.
3. In the Display area, mark the Formulas box. Click OK.
4. Choose File -Save As -Data Interchange Format, Click OK and save file.
5. Choose File -Save As -Text CSV , Click OK and when "Export text File" window is shown choose the following:
     Character Set:   UTF-8
     Field Delimiter:    {Tab}
     Text Delimiter:   "
     and tick "Save cell content as shown"
     and tick "Save cell formulas instead of calculated values"
6. Open the file in gedit or other texteditor to verify that all your data is there.

GOOGLE DOCS

2. Click the View menu.
3. Select All formulas.
4. Save As file-type CSV(MS-DOS).
5. Open the file in a texteditor to verify that all your data is there.

Step 4. Upload your File with data

PHP/MySQL File Repository. Here you upload your file with the data.

1. Upload your file.

Upload and Import module:

Excel file example

Step 5. Turn your excel into a web widget or app.

2. Press "Import to DB" on the far right for the spreadsheet file that you want to import or make a widget or app for.

Handling the import

3. The system will identify the variables and formulas if that are present in the system and new variables and formulas will be imported.

Import Handler:

Excel file example

4. Design and copy the code into your webpage.

The result

A web calculator widget:

Mobile calculator, press this button to test:

The button will show an app like this:

Picture of a handheld device

Picture of a handheld device